SAS HELP!

[sasbeginner]

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 etc..any ideas..i was thinking of using an sql update statment....

 

[ChrisW75]

You can split the numbers out and increment it, then put it back in. I'm assuming that the record is the same record, you're just incrementing the URN on the record yes?

data outdat;
  set indat;

  num = input(scan(URN,1,'_'),2.);
  second_part = scan(URN,2,'_');
  num2 = num + 1;
  new_urn = catx('_',put(num2,2.),second_part);
run;

Try that and see if it gives you what you want.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.