sasbeginer
October 5th, 2009, 01:13 PM
Hi i am using sas and need help on construction a new URN. I currently have a URN field which is populated with 1_1urn, 1_2urn, 1_3urn etc..now everytime the code is run i need the urn to increment by 1..so the next time it is run the urn is 2_1urn, 2_2urn, 2_3urn and if run again 3_1urn, 3_2urn etc..any ideas..i am having trouble storing the incremented value. At the moment iv got
urn = 1
urn = urn + 1
everytime this is run it read the 1 i need a way to store the new urn value and so it doesnt read the 1...Do i need to create another table??
urn = 1
urn = urn + 1
everytime this is run it read the 1 i need a way to store the new urn value and so it doesnt read the 1...Do i need to create another table??