BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Bhargav_Movva
Fluorite | Level 6

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

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;

View solution in original post

2 REPLIES 2
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1219 views
  • 1 like
  • 3 in conversation