DATA Step, Macro, Functions and more

Add duplicates and variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 10
Accepted Solution

Add duplicates and variable

Hello all, 

I am a beginner and I am trying to duplicate my dataset based on a condition. Every 6th observation the data set should be duplicated and range of numbers (1.2 to 1.5) needs to be added. 

 

I am using the below code: 

 

data have;
input ID sales; 
datalines;
1 car
1 motor
1 van
1 bike
1 ship
;
data want;
set have;
do i= 1 to 5;
cost= 1.2;
output;
end;
run;

 

I need the output like below: 

 

1Car1.2
1Motor1.2
1Van1.2
1Bike 1.2
1Ship1.2
1Car1.3
1Motor1.3
1Van1.3
1Bike 1.3
1Ship1.3
1Car1.4
1Motor1.4
1Van1.4
1Bike 1.4
1Ship1.4
1Car1.5
1Motor1.5
1Van1.5
1Bike 1.5
1Ship1.5

 

Many thanks!


Accepted Solutions
Solution
‎11-14-2017 11:37 AM
Super User
Posts: 6,537

Re: Add duplicates and variable

I'm not sure what you mean by every 6th observation.  But looking at the data coming in and the data set that you want:

 

data want;

set have;

do cost=1.2 to 1.5 by 0.1;

   output;

end;

run;

 

Then if the order of the observations is important:

 

proc sort data=want;

by cost;

run;

View solution in original post


All Replies
Solution
‎11-14-2017 11:37 AM
Super User
Posts: 6,537

Re: Add duplicates and variable

I'm not sure what you mean by every 6th observation.  But looking at the data coming in and the data set that you want:

 

data want;

set have;

do cost=1.2 to 1.5 by 0.1;

   output;

end;

run;

 

Then if the order of the observations is important:

 

proc sort data=want;

by cost;

run;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 97 views
  • 1 like
  • 2 in conversation