topic Re: How can I duplicate the records by many times (Control by a variable)? in SAS Procedures

How can I duplicate the records by many times (Control by a variable)?

deleted_user — Fri, 12 Mar 2010 03:23:21 GMT

Dear all,

How can I duplicate the records?

For example:

DATA TEST;
INFILE CARDS MISSOVER;
INPUT @1 ID4. @8 Factor 2. @13INVENCST COMMA10.2;
CARDS;
0001 2 45,000.00
0002 5 28,000.00
;
RUN;

If the first record of factor is 2. How can I duplicate the record by 2 times?

Finally, I want the results as following:

0001 20 45,000.00
0001 20 45,000.00
0001 10 28,000.00
0002 10 28,000.00
0002 10 28,000.00
0002 10 28,000.00
0002 10 28,000.00

Thanks all

Message was edited by: loverstar Message was edited by: loverstar

Re: How can I duplicate the records by many times (Control by a variable)?

sbb — Fri, 12 Mar 2010 12:11:40 GMT

You have the SAS OUTPUT statement which can be used in a DATA step for this purpose, as required. Without explicit coding of the OUTPUT in your example, only one SAS observation is generated. You can define a code paragraph using the construct below (coded within a DATA step):

DO I=1 TO ;
OUTPUT;
END;

Scott Barry
SBBWorks, Inc.

Recommended Google advanced search argument, this topic/post:

data step programming site:sas.com