proc sql drop variables from select

[Justin9]

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;

[Angel_Larrion]

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;