Separate alphanumeric and numeric values in a single variable

[pmpradhan]

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.

[Kurt_Bremser]

Use notdigit(strip(patient_id)) to determine where to write a specific observation.

[TomKari · Accepted solution]

data Numeric Alpha;
	set have;

	if findc(Patient_ID, "", "dks") > 0 then
		output Alpha;
	else output Numeric;
run;

[pmpradhan]

Brilliant! Works Perfectly! Thank you TomKari!! 🙂