proc sql drop variables from select

Justin9 — Wed, 12 Aug 2020 16:33:31 GMT

Hi,

I am using proc sql below but was wondering if someone could tell me what the best way is to exclude some variables in the "B" dataset from being selected when the table is being created (as I only want the "DATE" and "PLACE" variables from dataset A to be shown in the created table)? As my "B" dataset has over 100 variables, I would like to keep 98 of them when I left join in onto the "A" dataset, but not select the "DATE" and "PLACE" variables (i.e. not select B.DATE and B.PLACE).

proc sql;
     create table Final_Information as
     select A.*
           ,B.*   /*How to include all B dataset variables, except "B.DATE" and "B.PLACE"? */
      from AC.TEST as a
      left join INITIAL_DATA as b
            on a.RECORD_NUMBER=b.RECORD_NUMBER
      ;
quit;

Re: proc sql drop variables from select

Angel_Larrion — Fri, 14 Aug 2020 03:07:40 GMT

You can exclude those variables from the dataset in the from clause:

proc sql;
     create table Final_Information as
     select A.*
           ,B.*   
      from AC.TEST as a
      left join INITIAL_DATA(drop=DATE PLACE) as b
            on a.RECORD_NUMBER=b.RECORD_NUMBER
      ;
quit;

topic proc sql drop variables from select in SAS Programming

proc sql drop variables from select

Re: proc sql drop variables from select