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 your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.
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.