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

Could you help me to solve the following question?

 

name  count

abc       2

cde       3

def        1

......

xyz       5

 

the result I want is the following

name

abc

abc

cde

cde

cde

def

....

xyz

xyz

xyz

xyz

xyz

1 ACCEPTED SOLUTION

Accepted Solutions
Peter_C
Rhodochrosite | Level 12
Data want( keep= name ) ;
Set have ;
Do i= 1 to count ;
Output;
End ;
Run ;

View solution in original post

8 REPLIES 8
TigerAn
Calcite | Level 5

Could you help me to solve the following question?

 

name  count

abc       2

cde       3

def        1

......

xyz       5

 

the result I want is the following

name

abc

abc

cde

cde

cde

def

....

xyz

xyz

xyz

xyz

xyz

 

collinelliot
Barite | Level 11

 

data want;

    set have;

   do i = 1 to count;

       output;

   end;

run;

 

 

Reeza
Super User

Just a note that there is no need to post in multiple forums. Since you have an answer in this post, I've merged your other, identical question, with this post. 

Peter_C
Rhodochrosite | Level 12
Data want( keep= name ) ;
Set have ;
Do i= 1 to count ;
Output;
End ;
Run ;
TigerAn
Calcite | Level 5
thank you Peter!
Peter_C
Rhodochrosite | Level 12
If this is the answer you wanted, please mark it as the solution
art297
Opal | Level 21

@Peter_C: Hi Peter!  It was marked as a solution almost immediately after you posted it. I know, because I had posted basically the same solution seconds after you did, saw yours, thus delteted mine.

 

Art, CEO, AnalystFinder.com

Peter_C
Rhodochrosite | Level 12
Apols
This browser dod not make that clear

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 8 replies
  • 2190 views
  • 1 like
  • 5 in conversation