Hi, I received this error when I tried to do a select distinct in proc SQL: ERROR: Result of WHEN clause 2 is not the same data type as the preceding results. I'm programming in SAS Enterprise Guide 8.3. Here is my code: proc sql; create table OneTerm as select drv.TERMS_ID, drv.day, (drv.day+drv.start_dt) as date format YYMMDD10., drv.SECTID, case when a.CreditHours is missing then 0 else a.CreditHours end as CreditHours, case when a.seatcount is missing then 0 else a.seatcount end as seatcount from(select distinct a.TERMS_ID,a.day, (a.date-a.day)as start_dt format YYMMDD10., b.SECTID from work.ADDREGDAY as a left join (select distinct TERMS_ID, SECTID from work.addregday where TERMS_ID="&TERMS_ID" and SECTID is not null)b on a.TERMS_ID=b.TERMS_ID where a.TERMS_ID="&Terms_ID") as drv left join (select * from work.addregday where TERMS_ID="&TERMS_ID") as a on drv.day=a.day and drv.SECTID=a.SECTID; quit; Here is the logs: proc sql; 277 create table OneTerm as 278 select drv.TERMS_ID, drv.day, (drv.day+drv.start_dt) 41 The SAS System 12:22 Friday, October 22, 2021 278 ! as date format 279 YYMMDD10., drv.SECTID, 280 case when a.CreditHours is missing then 0 else 280 ! a.CreditHours end as CreditHours, 281 case when a.seatcount is missing then 0 else 281 ! a.seatcount end as seatcount from(select distinct 281 ! a.TERMS_ID,a.day, 282 (a.date-a.day)as start_dt format YYMMDD10., b.SECTID 283 from work.ADDREGDAY as a left join 284 (select distinct TERMS_ID, SECTID from work.addregday 284 ! where TERMS_ID="&TERMS_ID" and SECTID ne .)b 285 on a.TERMS_ID=b.TERMS_ID where 42 The SAS System 12:22 Friday, October 22, 2021 285 ! a.TERMS_ID="&Terms_ID") as drv 286 left join 287 (select * from work.addregday where 287 ! TERMS_ID="&TERMS_ID") as a 288 on drv.day=a.day and drv.SECTID=a.SECTID; ERROR: Result of WHEN clause 2 is not the same data type as the preceding results. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. 289 quit; NOTE: The SAS System stopped processing this step because of errors. Could someone help me with what's going on? SECTID is a numeric Day is a numeric TERMS_ID is a character I appreciate any help you can provide.
... View more