Defining different tables with different variables in same data set

[Jrower]

Hi, 

As you can see on the example below, I'm trying to create multiple tables on the same dataset however, I want specific variables to be shown in each table. Problem is, the way I'm doing, all tables end up having all the variables I've mentioned in all keep statements.

Example:

data rule_01 rule_02 rule_03 rule_04;
           set have;
           if rule_01 = 'fail' then output rule_01; keep reason_1 rule_01;
           if rule_02 = 'fail' then output rule_02; keep ID reason_2 rule_02;

           if rule_03 = 'fail' then output rule_03; keep reason_3 rule_03;

           if rule_04 = 'fail' then output rule_04; keep reason_4 rule_04;

run;

thank you 🙂

[Kurt_Bremser · Accepted solution]

You need to use keep= dataset options on the individual datasets in the DATA statement, like

rule_01 (keep=reason_1 rule_01)

[PaigeMiller]

or you can use DROP=