Hey guys, Working with longitudinal data with lots of admission/discharge times. The data is entered into the .csv file as date + military time in the same cell, for example: 01/03/2011 0534. Trying ti get SAS to read the whole entry but it only reads the date part, ignores the time. It autimatically assigns the format 'MMDDYY10' to these date-time columns. Tried to use various date-time informats to no avail, keep getting an error. Also tried to use the 'Picture statement' in PROC FORMAT to customize my own date-time variable. SAS wont budge. Here's a copy of my code: FILENAME REFFILE '/folders/myshortcuts/SAS/PIMs.csv'; /*Define your own date-time format using a date-time "Picture" options*/ proc format; picture Nada other= '%0m/%0d/%Y %0H%0M' (datatype=datetime); run; data WORK.PIMs ; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile REFFILE delimiter = ',' MISSOVER DSD firstobs=2 ; informat Arrv_Date_Time datetime_20. ; informat Disch_Date_Time MDYAMPM25. ; format Arrv_Date_Time Nada. ; format Disch_Date_Time Nada. ; input Arrv_Date_Time Disch_Date_Time ; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ run; ___________________________________________________________________________________________________________ Any input is much appreciated, thanks! Nada
... View more