topic Re: extracting the part of string in SAS Programming

extracting the part of string

SAS_inquisitive — Thu, 04 Feb 2016 21:37:23 GMT

How to get the last 4 digits of SSN from this data?

data SSN;
  input SSN $;
  cards;
  123456789
  12345678
  1234567
  ;
run;

Re: extracting the part of string

data_null__ — Thu, 04 Feb 2016 21:44:48 GMT

last4 = substrn(ssn,lengthn(ssn)-4+1);

Re: extracting the part of string

FreelanceReinh — Thu, 04 Feb 2016 21:45:21 GMT

With your data step you lose already the "9" in the first row.

data SSN;
input SSN :$9.; /* The default length 8 is insufficient! */
cards;
123456789
12345678
1234567
;
run;

data want;
set ssn;
length last4d $4;
last4d=substr(ssn,length(ssn)-3);
run;