Hi all,
I am trying to extract the 1st letter or 2nd letter of a postcode depending on its length.
So if a postcode is "G72 7RT" this would be G.
Alternatively, a postcode of "EH12 4GY" would just be EH.
Any help would be much appreciated.
Paul
Test for numeric, and use that for the substr:
data test;
input postcode $10.;
start = substr(postcode,1,anydigit(postcode)-1);
cards;
G72 7RT
EH12 4GY
;
run;
Thanks Kurt
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.