BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
ugly_duck_ling
Calcite | Level 5

I have a dataset that I am required to tell SAS to output the number of observations that are dictated by the "count" variable.

The dataset is:

 

data one;
input type $ count;
datalines;
1 2
2 2
3 1
4 5
5 3
;
run;

 

My code for that was:

 

data two;
set one;
do i= 1 to 5;
if i gt count then delete;
output;
end;
run;

 

The above code is satisfactory, yet I am wondering if could re-write the code and get the same result by starting my code with the following do loop:

 

do i= 1 to N /* where N is a variable */

 

Can anyone help me with that?

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
AMSAS
SAS Super FREQ

Is this what you mean?

data one;
	input type $ count;
datalines;
1 2
2 2
3 1
4 5
5 3
;
run;

 
 

data two;
	set one;
	do i= 1 to count;
		output;
	end;
run;

 

View solution in original post

2 REPLIES 2
AMSAS
SAS Super FREQ

Is this what you mean?

data one;
	input type $ count;
datalines;
1 2
2 2
3 1
4 5
5 3
;
run;

 
 

data two;
	set one;
	do i= 1 to count;
		output;
	end;
run;

 

ugly_duck_ling
Calcite | Level 5

Thank you so much!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 861 views
  • 0 likes
  • 2 in conversation