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?
... View more