topic Output two tables with different columns from one dataset in New SAS User

Output two tables with different columns from one dataset

Eathonhua — Thu, 03 Feb 2022 17:09:30 GMT

Hello, I am a SAS beginner and encounter a question as follows:

I want to output two tables(parks, monuments) from one dataset, say, pg1.np_summary; While in output table parks I wanna keep variables Reg ParkName DayVisits; in output table monuments I wanna keep variables Reg. The following is my programming:

data parks monuments;

set pg1.np_summary;

where type in ('NM','NP');

if type='NP' then do;

output parks;

keep Reg ParkName DayVisits;

end;

else do;

output monuments;

keep Reg ;

end;

run;

However, I found the two output tables end up with having only one variable specified(Reg). May I know how to program that in order to have two output tables with different columns?

Re: Output two tables with different columns from one dataset

PaigeMiller — Thu, 03 Feb 2022 17:11:57 GMT

data parks(keep=reg parkname dayvisits) monuments(keep=reg);

Re: Output two tables with different columns from one dataset

Reeza — Thu, 03 Feb 2022 17:14:19 GMT

KEEP statements apply to all output data sets on the DATA statement.

KEEP data set options apply to only the data set referenced.

You're using a KEEP statement in the data step but need to use a data set option instead. @PaigeMiller provided the code for that solution.

@Eathonhua wrote:

Hello, I am a SAS beginner and encounter a question as follows:

I want to output two tables(parks, monuments) from one dataset, say, pg1.np_summary; While in output table parks I wanna keep variables Reg ParkName DayVisits; in output table monuments I wanna keep variables Reg. The following is my programming:

data parks monuments;

set pg1.np_summary;

where type in ('NM','NP');

if type='NP' then do;

output parks;

keep Reg ParkName DayVisits;

end;

else do;

output monuments;

keep Reg ;

end;

run;

However, I found the two output tables end up with having only one variable specified(Reg). May I know how to program that in order to have two output tables with different columns?

Re: Output two tables with different columns from one dataset

Eathonhua — Thu, 03 Feb 2022 23:59:04 GMT

Thanks!