topic Re: create table for sas observation in SAS Programming

create table for sas observation

dht115 — Fri, 16 Dec 2022 15:14:41 GMT

Hello,

I need to create a table based on observation and keep the table name.

data test1;
input var1 $;
datalines;
a
b
c
;
run;

data test2;
input var1 $;
datalines;
a
b
c
d
;
run;

My output should be:

Re: create table for sas observation

Tom — Fri, 16 Dec 2022 15:25:20 GMT

Huh?

Are you asking how to find out how many observations are in your datasets?

proc sql ;
create tables want as
select libname,memname,nobs from dictionary.tables
  where libname='WORK'
;
quit;

proc print;
run;

Re: create table for sas observation

sbxkoenk — Fri, 16 Dec 2022 15:25:24 GMT

data test1;
input var1 $;
datalines;
a
b
c
;
run;

data test2;
input var1 $;
datalines;
a
b
c
d
;
run;

PROC SQL noprint;
 create table work.wanted as
 select memname , nobs 
 from dictionary.tables
 where LIBNAME='WORK' and memname in ('TEST1','TEST2') and memtype='DATA';
QUIT;
/* end of program */

Koen