topic Re: Proc import / two date variables with the same format in an excel file imported differently in SAS Programming

Proc import / two date variables with the same format in an excel file imported differently

Cruise — Thu, 02 Apr 2020 22:47:40 GMT

Hi Folks:

I imported a data.csv using 'proc import'. The data had two date variables: 'confirmed_date' and 'deceased_date'. Before importing, both appeared to have a format 'Date' in the CSV as shown in the screenshot below. However, one of the dates 'deceased_date' was broke in the resulting SAS dataset after imported.

What happened to cause that 'deceased_date' was broke but not 'confirmed_date' ?

Any pointers that could be corrected in my 'proc import' code below?

Thanks for your time in advance.

proc import 
datafile="...\patientinfo.csv"
out=patientinfo
dbms=csv replace;
getnames=yes;
run;

Re: Proc import / two date variables with the same format in an excel file imported differently

Reeza — Thu, 02 Apr 2020 23:20:41 GMT

Check the log and see that field is set to be read as a character. My guess is somewhere in the first 1000 rows you have a lot of missing data so it assumed it was a character and imported it as such. Add GUESSINGROWS=MAX; , which will take a long time is one try to fix it. If that works, I would recommend you take the code from the log and use that for future imports - it's much faster than when SAS has to guess each type.

In general, it's bad practice to use PROC IMPORT to rely on for data imports, you should be building your data import of a specification list or data dictionary.

Re: Proc import / two date variables with the same format in an excel file imported differently

Cruise — Thu, 02 Apr 2020 23:27:17 GMT

GUESSINGROWS=MAX; Fixed the problem. Yes. The date variable broke had missing for about 98% of the data.
Thank you very much Reeza. I greatly appreciate it.