Hello,
I have a bunch of datasets labels a1y b2y c3y.
I would like to concatenate them into a single one, which would have a variable indicating the name of the original dataset.
It's probably easy, but I didn't find how.
Thank you
data want;
set
a1y
b2y
c3y
indsname=_inname
;
inname = _inname;
run;
If you're having a larger bunch of datasets, you might consider to use a data _null_step with call execute to build that data step.
data want;
set
a1y
b2y
c3y
indsname=_inname
;
inname = _inname;
run;
If you're having a larger bunch of datasets, you might consider to use a data _null_step with call execute to build that data step.
Good practice would be to set the length of the inname variable so the whole dataset name fits. Length of $ 41 will allow for the maximum 8 characters for library, the period separator and 32 characters for the data set.
If you have similar named sets like: A1y A2y A3y you can use a List modifier of a colon after the stem to get all similar names. A: would include all data sets in the library whose names start with A for instance.
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.