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

[deleted_user]

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

[sbb]

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