/ Published in: SAS
Need to construct and ID of the first 5 letters and the last 7 digits
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
/* We want to parse the current ID LOLOBRIDGIDA195703F and end up with an ID of the first 5 letters and the last 7 digits to end up with LOLOB195703F */ data _null_; length id2 $12; id = 'LOLOBRIDGIDA195703F'; id2 = substr(id,1,5)||reverse((substr(reverse(id),1,7))); put _all_; run;
URL: http://jaredprins.squarespace.com/blog/2008/5/15/fun-with-parsing-strings-in-sas.html