Output two tables with different columns from one dataset

[Eathonhua]

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? 

[PaigeMiller · Accepted solution]

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

[Reeza]

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? 

---

[Eathonhua]

Thanks!