How to apply where condition on multiple datasets

pdhokriya — Mon, 13 Sep 2021 14:26:15 GMT

Hi ,

how to apply where condition ( same condition ) when there are multiple ( apprx 30 - 100) datasets (dataset names and count is unknown ) in 1 library.

I have do this manually, but this is not feasible when there are multiple datasets in 1 library.

how do i short this code?

Also I want same naming covension for input dataset and output datasets. like one and one.

data one;
input name $ var1 ;
cards;
A 100
B 200
C 300
;
run;

data two;
input name $ var1 ;
cards;
A 100
B 200
D 300
;
run;

data three;
input name $ var1 ;
cards;
A 100
F 300
D 300
;
run;

data four;
input name $ var1 ;
cards;
A 100
F 300
D 300
G 300
;
run;

data one ; set one; if var1 = 300 then delete; run;

data two ; set two; if var1 = 300 then delete; run;

data three ; set three; if var1 = 300 then delete; run;

data four ; set four; if var1 = 300 then delete; run;

Re: How to apply where condition on multiple datasets

sbxkoenk — Mon, 13 Sep 2021 15:03:19 GMT

hello @pdhokriya ,

Use data-driven code generation with file-put-include!
Other techniques are also possible (call execute, macro, ...).

PROC SQL noprint;
 create table work.tables as
 select memname
 from dictionary.tables
; QUIT;

/* suppose above query results in below data set */
data work.tables;
LENGTH memname $ 32;
memname='one';   output;
memname='two';   output;
memname='three'; output;
memname='four';  output;
run;

filename tt temp;

data _NULL_;
 set work.tables;
 file tt;
PUT 'data ' memname '; set ' memname '; if var1 = 300 then delete; run;';
run;

/* proc fslist file=tt; run; */
options source2;
%INCLUDE tt;
/* end of program */

Cheers,

Koen

topic How to apply where condition on multiple datasets in SAS Programming

How to apply where condition on multiple datasets

Re: How to apply where condition on multiple datasets