If I were to prevent any rows of data from showing up in my output if my dattim2 variable is a character instead of a number, how would I do it? input @4 numdate $1. @; drop numdate; if numdate in ('0','1','2','3','4','5','6','7','8','9') then do; input junk dattim2 $20. junk2 PM25 NO2 Precip PM10 WDir Humidity Temp Atm_pres Wspd_sclr Wspd_vect SO2 NOx O3 Wdir_sclr NO CO; day = input(substr(dattim2,1,index(dattim2," ")-1),anydtdte10.); time = input(substr(dattim2,index(dattim2," ")+1),anydtdtm10.); dattim = dhms(day,0,0,time); drop junk junk2 day time dattim2; end; I tried this, but for some reason my first 2 variables stopped showing up (dattim2 and PM25). options DATESTYLE=MDY; data burnaby; format dattim2 datetime22.; infile "C:\Users\Takuma\Documents\Burnaby_south_Feb2016.txt" firstobs=3 dsd delimiter="|"; input junk dattim $20. junk2 PM25 NO2 Precip PM10 Wdir_vct Humidity Temp Atm_pres Wspd_sclr Wspd_vect SO2 NOx O3 Wdir_sclr NO CO; day = input(substr(dattim,1,index(dattim," ")-1),anydtdte10.); time = input(substr(dattim,index(dattim," ")+1),anydtdtm10.); dattim2 = dhms(day,0,0,time); drop junk junk2 dattim day time; run;
... View more