topic Defining different tables with different variables in same data set in New SAS User

Defining different tables with different variables in same data set

Jrower — Fri, 07 Feb 2020 12:27:51 GMT

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 🙂

Re: Defining different tables with different variables in same data set

Kurt_Bremser — Fri, 07 Feb 2020 12:38:25 GMT

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

rule_01 (keep=reason_1 rule_01)

Re: Defining different tables with different variables in same data set

PaigeMiller — Fri, 07 Feb 2020 12:52:22 GMT

or you can use DROP=