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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.