I have a variable and i want to extract data like example
var1
kjjhf-0fdf-dfed
asd-fdfk-dfcsf
I want to get data which is between the -
var1
0fdf
fdfk
It is a good idea to post your test data in the form of a datastep:
data have; var1="kjd-fhf-asd"; output; var1="dfsf-dfg-dwe"; output; run; data want; set have; want=catx(' ',substr(scan(var1,2,"-"),1,2),substr(scan(var1,2,"-"),3,1)); run;
SCAN() function
Scan(var, 2, '-');
sorry, i gave a incomplete question. i also want space after scanning like
var1
kjd-fhf-asd
dfsf-dfg-dwe
i want like this
var1
fh f
df g
Use substr() to extract the two parts and the CAT function to create new variable.
It is a good idea to post your test data in the form of a datastep:
data have; var1="kjd-fhf-asd"; output; var1="dfsf-dfg-dwe"; output; run; data want; set have; want=catx(' ',substr(scan(var1,2,"-"),1,2),substr(scan(var1,2,"-"),3,1)); 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.