topic Re: Splitting one row record into Multiple records rows in SAS Programming

Splitting one records into multiple records

TigerAn — Wed, 22 Feb 2017 22:48:57 GMT

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

cde

def

....

xyz

Splitting one row record into Multiple records rows

TigerAn — Wed, 22 Feb 2017 22:42:25 GMT

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

cde

def

....

xyz

Re: Splitting one row record into Multiple records rows

collinelliot — Wed, 22 Feb 2017 22:50:00 GMT

data want;

set have;

do i = 1 to count;

output;

end;

run;

Re: Splitting one records into multiple records

Peter_C — Wed, 22 Feb 2017 22:54:00 GMT

Data want( keep= name ) ;
Set have ;
Do i= 1 to count ;
Output;
End ;
Run ;

Re: Splitting one records into multiple records

TigerAn — Wed, 22 Feb 2017 22:56:22 GMT

thank you Peter!

Re: Splitting one records into multiple records

Peter_C — Wed, 22 Feb 2017 23:12:39 GMT

If this is the answer you wanted, please mark it as the solution

Re: Splitting one records into multiple records

art297 — Wed, 22 Feb 2017 23:16:30 GMT

@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

Re: Splitting one records into multiple records

Peter_C — Wed, 22 Feb 2017 23:19:19 GMT

Apols
This browser dod not make that clear

Re: Splitting one row record into Multiple records rows

Reeza — Wed, 22 Feb 2017 23:39:45 GMT

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.