Proc SQL

chrissowden — Tue, 16 Oct 2018 02:19:22 GMT

proc format;
   value $dest
       'DFW'='Dallas/Forth Worth'
       'LAX'='Los Angeles'
       'ORD'="O'Haire"
       'WAS'= 'DC-ALL Airports'
       'CDG'= 'De Gaulle'
       'CPH'= 'Copenhaugen'
       'FRA'='Frankfurt'
       'LHR'='London-Heathrow'
       'YYZ'='Toronto'
   ;
run;

Proc SQL;
   create table ex1 AS
   select distinct s.state as Staff_State,s.empid,sup.state as SUP_Sate,p.jobcode, put(f.destination,$DEST.) AS dest,f.date
   from mysas.supervisors AS Sup

   full Join mysas.staffmaster AS s ON s.empid=sup.empid
   full Join mysas.payrollmaster as P ON s.empid=p.empid
   full join mysas.flightschedule as f ON s.empid=f.empid
   where destination in('CPH') and date ='04MAR2004'

   ;
quit;

when I try to select destination and the date I am getting an error in the log: date is a numeric value with date9. format.

_____

 ERROR: Expression using equals (=) has components that are of different data types.

Re: Proc SQL

Reeza — Tue, 16 Oct 2018 02:20:48 GMT

date ='04MAR2004'd

You need the d after the quotes to tell SAS it's a date, not a character field.

topic Re: Proc SQL in SAS Programming

Proc SQL

Re: Proc SQL