Creating tables for each variable in a parent table and limit rows output.

puregallus — Tue, 20 Nov 2018 13:59:22 GMT

Hi all, I'm trying to create a table for each version of a variable in a parent table. Currently I am using the following code:

%let TABLE=libref.tablename
%let COLUMN=columnname

proc sql noprint;
select distinct
cat("DATA out_",compress(&COLUMN.,'','kad'),
";set &TABLE.(where=(&COLUMN.='" ,&COLUMN.,
" ')); run;") length=500 into :allsteps separated by ';'
from &TABLE.;
quit;
%macro runSteps;
&allsteps.;
%mend;
%runSteps;

My problem is that I would like to limit to rows of the output tables to a certain number say 5. But I can't quite figure out how to fit obsout into this code. Putting it in the proc sql statement just prevents the looping of of the runSteps macro.

Thanks for your help.

Re: Creating tables for each variable in a parent table and limit rows output.

gamotte — Tue, 20 Nov 2018 14:23:31 GMT

Hello,

with call execute in a data step :

%let table=sashelp.class;
%let column=age;

data _NULL_;
input age;
call execute(cats('data out_',&column.,'; set &table.; where &column.=',&column.,'; if _N_ le 3; run;'));
cards;
12
13
14
15
16
;
run;

topic Creating tables for each variable in a parent table and limit rows output. in SAS Programming

Creating tables for each variable in a parent table and limit rows output.

Re: Creating tables for each variable in a parent table and limit rows output.