topic Re: How to repeat the entire row in a dataset with change in one variable based on a condition in SAS Programming

How to repeat the entire row in a dataset with change in one variable based on a condition

Prash — Mon, 12 Sep 2016 05:13:52 GMT

I want to repeat the entore row in a SAS data set based on the following condition :

If the 'duration' of the fund is lesser then equal to 4 and type of 'base_fund' is Platinum or blank value ( which implies platinum), I need to generate additional 4 rows same as platinum row values, but changing the "base_fund' to these 4 funds 'Add_Silver', 'Silver'. 'Bronze','Add_gold'. These needs to be repeated twice based on type 'RO' and 'OT'.

I have attached the screen shot on how the raw data looks like and what I need as output for Reg_number : 8765432:

Data I have:

Data I want

I tried using repeat function and SQL, however I was not fully successful, Appreciate your quick help on this.

Reeza — Mon, 12 Sep 2016 06:33:48 GMT

Use a Data step with an explicit OUTPUT statement. Make sure to include an else output so that other records are also displayed.

If <condition> then do;
    Do base_fund= 'add_silver' , 'add_bronze', ... 'Add_awesome';
         Output;
    End;
End;
Else output;

Shmuel — Mon, 12 Sep 2016 08:33:54 GMT

If by "repeat" you mean to duplicate a row with changes then the code should be:

Data want;

set have;

output; /* save original row */

if <condition> then do;

output; /* with the changed data */

end;

run;

Jim_G — Mon, 12 Sep 2016 11:19:09 GMT

Data want; set have;

Output;

If duration le 4 then do;

Basefund=’add_silver’; output’

Basefund=’silver’; output’

Basefund=’add_gold’; output’

Basefund=’bronze’; output’

End;

JIm