proc sql; 488! create table NACRS_AA_COSTsql as 489 select * 490 from NACRS_AA_1 as a, Costing_1 as b 491 where a.CIHI_KEY=b.CIHI_KEY 492 ; WARNING: Variable CIHI_KEY already exists on file WORK.NACRS_AA_COSTSQL. NOTE: Table WORK.NACRS_AA_COSTSQL created, with 1171 rows and 81 columns. 493 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.39 seconds cpu time 0.39 seconds   Hello Can someone please advise why I get the warning message     ... View more

data stroke_onset; set EVT.stroke_ischemic; where SP340_ONSET IS NOT MISSING; where FIRST_ADM_TM>SP340_ONSET; by CIHI_KEY_DAD FIRST_ADM_TM; Window1=(FIRST_ADM_TM-SP340_ONSET)/60; length cat $100.; if 0<=Window1<=360 then cat="0to6"; else if 360<Window1=<1440 then cat="6to24"; else if 1440<Window1 then cat = ">24"; else if missing (SP340_ONSET) then cat = "Stroke onset time missing"; else if FIRST_ADM_TM<SP340_ONSET then cat = "Stroke onset after First Admit Time"; else cat='NA'; run; Hello Can someone advise how I would write the above code i.e. using either the where or if clause to exclude the observations from the output for the bolded categories  What I have stated in the if then conditions is what I want but now I want to exclude those observations from the output Also did not want to combine the two where conditions using the and operator since I want to exclude observations for each condition applied separately. Do ijust use subsetting if statements   ... View more