I have a dataset with following variables:
Patient_ID Class Gender
015786 10 Male
012345 20 Female
0T7896 10 Female
45J056 50 Male
7895P7 05 Female
and so on.
I need to output a dataset based on alphanumeric values in variable Patient_ID as one dataset and all numeric variables in Patients_ID as another dataset.
Please advise.
data Numeric Alpha;
set have;
if findc(Patient_ID, "", "dks") > 0 then
output Alpha;
else output Numeric;
run;
Use notdigit(strip(patient_id)) to determine where to write a specific observation.
data Numeric Alpha;
set have;
if findc(Patient_ID, "", "dks") > 0 then
output Alpha;
else output Numeric;
run;
Brilliant! Works Perfectly! Thank you TomKari!! 🙂
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.