topic Generating repeated sequence in SAS Datastep in SAS Programming

Generating repeated sequence in SAS Datastep

shankvi8 — Fri, 17 Mar 2023 14:32:36 GMT

Dear All,

Need help in generating repeated sequence. I have 3 inputs in macro variable

Min Value = 1 (Starting number of the sequence)

Max Value = 3 (Ending number of the sequence)

No of iterations = 2 (No of times the sequence to be repeated)

With the above input I would like to see a dataset with the below result.

Re: Generating repeated sequence in SAS Datastep

ballardw — Fri, 17 Mar 2023 14:42:47 GMT

@shankvi8 wrote:

Dear All,

Need help in generating repeated sequence. I have 3 inputs in macro variable

Min Value = 1 (Starting number of the sequence)

Max Value = 3 (Ending number of the sequence)

No of iterations = 2 (No of times the sequence to be repeated)

With the above input I would like to see a dataset with the below result.

1

2

3

1

2

3

You could at least provide the names of your macro variables, the name of the data set and variable in the dataset.

One way:

%let min= 1;
%let max= 3;
%let iter= 2;

data want;
   do i= 1 to &iter;
      do x=&min to &max;
         output;
      end;
   end;
   drop i;
run;

Caution: this makes to checks that max is greater than min.

Re: Generating repeated sequence in SAS Datastep

PaigeMiller — Fri, 17 Mar 2023 14:44:17 GMT

data want;
    do j=1 to &no_of_iterations;
        do i=&minvalue to &maxvalue;
            output;
        end;
    drop j;
run;

Re: Generating repeated sequence in SAS Datastep

shankvi8 — Fri, 17 Mar 2023 14:45:09 GMT

Excellent. Thanks for sharing