Hey i have a data like this...
data DS1;
INFILE DATALINES;
INPUT NAME $;
DATALINES;
LION
TIGER
;
RUN;
output should be a dataset with 8 observations and it should look like
name
LION
LION
LION
LION
TIGER
TIGER
TIGER
TIGER
Like this
data DS1;
INFILE DATALINES;
INPUT NAME $;
DATALINES;
LION
TIGER
;
RUN;
data want(keep=name);
set ds1;
do i=1 to 4;
output;
end;
run;
data ds2;
set ds1;
do i = 1 to 4;
output;
end;
drop i;
run;
Like this
data DS1;
INFILE DATALINES;
INPUT NAME $;
DATALINES;
LION
TIGER
;
RUN;
data want(keep=name);
set ds1;
do i=1 to 4;
output;
end;
run;
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.