topic Re: Logic needed in SAS Programming

Logic needed

Balaji_7992 — Sun, 10 May 2020 14:46:04 GMT

Kindly help me with the logic for this one

I am having a data set having 10 observations

Need Output like

Re: Logic needed

ed_sas_member — Sun, 10 May 2020 15:01:09 GMT

Hi @Balaji_7992

Here is a way to achieve this, using do loops:

data have;
	do i=1 to 10;
		output;
	end;
run;

data want;
	set have;
	do j=1 to i;
		k=i;
		output;
	end;
	drop j i;
run;

Best,

Re: Logic needed

r_behata — Sun, 10 May 2020 15:02:14 GMT

data have;
do i=1 to 10;
output;
end;
run;

data want;
	set have ;

	do _n_=1 to i;
		output;
	end;
run;

Re: Logic needed

Shmuel — Sun, 10 May 2020 17:40:15 GMT

Suppose the values you have are not 1 to 10 but

2 4 6 8 ...

would you like to duplicate output according to the value or according to

its sequence?

should it be:

2 2 4 4 4 4 6 6 6 6 6 6 ...

2 4 4 6 6 6 ...

Re: Logic needed

mkeintz — Sun, 10 May 2020 18:43:15 GMT

Question: why do you need to reproduce each record exactly X times, where X is an integer value (or rounded down to an integer) in your data set? If it mearely is to facilitate analysis procedures, like proc freq, proc reg, etc., so that you are treating each row with the frequency of observations that X represents, you don't need to create the dataset you appear to want.

Instead, you can use the

FREQ X;

statement in most analysis procedures, which will then treat each observation as if it appeared X times (or floor(X) times to be specific).