topic Re: duplicating rows and adding a new variable in SAS Programming

duplicating rows and adding a new variable

gzr2mz39 — Wed, 16 Feb 2011 18:00:46 GMT

I have a list of names (John, Jack, Tom).
I would like to create the following dataset
John 1
John 2
John 3
Jack 1
Jack 2
Jack 3
Tom 1
Tom 2
Tom 3

Any ideas? Thank you.

Re: duplicating rows and adding a new variable

sbb — Wed, 16 Feb 2011 19:22:11 GMT

Sounds like a SAS examination "prep" question - suggest reviewing the DO/END statement construct in a DATA step, where you would have an outer DO/END with explicit values, and an inner DO/END code piece.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search arguments, this topic / post:

data step programming do loop site:sas.com

do statement documentation site:sas.com

Re: duplicating rows and adding a new variable

FloydNevseta — Wed, 16 Feb 2011 19:28:47 GMT

The solution I offer assumes that your list of names comes from another dataset.

** create dataset of names;
data names;
input nm $ @@;
datalines;
John Jack Tom Jill Sue Bob Jennifer Tim George
;
run;

data names2;
length name $ 10;
set names;
*do nm = 'John', 'Jack', 'Tom';
do i = 1 to 3;
name = cat( strip( nm ), ' ', put( i, 1. ) );
output;
end;
*end;
keep name;
run;

If your list doesn't come from another data set and is really short, you can uncomment the DO loop and type the names like I have above. Also comment the SET statement.

Re: duplicating rows and adding a new variable

gzr2mz39 — Wed, 16 Feb 2011 20:27:15 GMT

Thank you.
This code did the job:
data names2;
set names;
do var = 1 to 3;
nm = cat( strip( name ), ' ', put( var, 1. ) );
output;
end;
keep name var;
run;