topic Re: Separate alphanumeric and numeric values in a single variable in SAS Data Management

Separate alphanumeric and numeric values in a single variable

pmpradhan — Fri, 23 Mar 2018 14:45:32 GMT

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.

Re: Separate alphanumeric and numeric values in a single variable

Kurt_Bremser — Fri, 23 Mar 2018 14:59:33 GMT

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

Re: Separate alphanumeric and numeric values in a single variable

TomKari — Fri, 23 Mar 2018 15:03:29 GMT

data Numeric Alpha;
	set have;

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

Re: Separate alphanumeric and numeric values in a single variable

pmpradhan — Fri, 23 Mar 2018 15:21:26 GMT

Brilliant! Works Perfectly! Thank you TomKari!! 🙂