hello ALL,
I am looking for a solution which extract only character (A-Z) and numeric (0-9) data, remove special character and space.
Is there any function for same.
Output should be : Ram7shaym
data temp; input A $50.; datalines; Ram7$%?shay m ; run;
Sounds like a use case for the compress() function.
data temp;
input A $50.;
wantstr=compress(a,,'kda');
datalines;
Ram7$%?shay m
;
run;
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.