topic Re: Create consecutive table in SAS in SAS Studio

Create consecutive table in SAS

mariange8282 — Sun, 18 Sep 2016 23:00:23 GMT

Hi, I'm trying to create a counting variable in PROC SQL to give name to tables.

PROC SQL;

i=1;

CREATE TABLE i AS SELECT* FROM A.A WHERE XX=i;

RUN;

I can not declarete the variable i to make it interactive.

Reeza — Sun, 18 Sep 2016 23:28:04 GMT

The usual recommendation is don't do this...if you specify why, send can usually offer a more efficient alternative.

Otherwise You want a macro loop.

How to split a table by groups.

Tom — Mon, 19 Sep 2016 00:15:02 GMT

You need to use macro language to generate code.

%let id=100 ;
%let inds=a.a ;


proc sql ;
   create table x&id as 
     select * 
     from &inds
     where id = &id
   ;
quit;

mariange8282 — Mon, 19 Sep 2016 03:59:40 GMT

Thanks, it was just the sintaxsis.. but I just forget said I want a loop. I change my code for this:

%LET i=1;

DATA A.A_&i;

SET A.A(WHERE=(XX=&i));

RUN;

But I need, i=i+1

%LET i=1;

DATA A.A_&i;
SET A.A(WHERE=(XX=&i));

i=i+1
RUN;

Kurt_Bremser — Mon, 19 Sep 2016 11:36:04 GMT

%macro make_datasets(max_i);
%do i = 1 %to &max_i;
data a.a_&i;
set a.a (where=(XX=&i));
run;
%end;
%mend;
%make_datasets(100);