topic Re: Problem importing a date variable in SAS Enterprise Guide

Problem importing a date variable

fri0 — Tue, 17 Dec 2013 15:21:13 GMT

Hi, I'm attaching a txt file that is part of a database with more variables, but this column is the only one that gives problems.

If you open the file with a excel, you could show all dates until December, but if you use the Enterprise Guide to make the import you only get dates until Nov 29, but there are not December dates. Someones could help me please?

Re: Problem importing a date variable

ChrisHemedinger — Tue, 17 Dec 2013 15:30:49 GMT

These dates are locale-specific, so you need to make sure that your SAS session is running in the correct locale, and then select the appropriate NL* informat for your date format.

See this paper for more information:

http://support.sas.com/resources/papers/proceedings13/025-2013.pdf

Chris

Re: Problem importing a date variable

fri0 — Fri, 20 Dec 2013 13:10:20 GMT

Hi, thanks for your help. I was about to try but a friend told me that your solution could create problems in other projects where date variables are correctly imported. We change the original software to generate the txt file with another date form that could be imported correctly by Sas. Thanks again, I didn't know about that possibility of change the sas standards to import.

Re: Problem importing a date variable

Jagadishkatam — Fri, 20 Dec 2013 13:48:02 GMT

Hi,

On close observation of the data provided by you in the txt file, the dates of December has typo error. The month "Dec" is mistyped as "Dic". This is the possible reason why the dates after 29Nov2013 are not being read. After 29Nov2013, the date started is 02Dic2013, which should have been 02Dec2013.

May be after making the change, all the dates should be read.

Please check.

Thanks,

Jag

Re: Problem importing a date variable

ChrisHemedinger — Fri, 20 Dec 2013 14:10:39 GMT

Jag - it wasn't a typo, it was in Spanish. December => Diciembre en español...

Looks like the problem has been resolved though...

Re: Problem importing a date variable

Jagadishkatam — Fri, 20 Dec 2013 14:13:26 GMT

Thank you Chris,

I thought it was a typo error as i saw the other names similar to English names.

Re: Problem importing a date variable

fri0 — Fri, 20 Dec 2013 14:14:55 GMT

Exactly, in Spanish it's Diciembre. I will try to change the month to see what happens.

Re: Problem importing a date variable

fri0 — Fri, 20 Dec 2013 14:18:23 GMT

You were totally right. Thank you very much.

Re: Problem importing a date variable

Jagadishkatam — Fri, 20 Dec 2013 14:21:24 GMT

Thank you for checking this and confirming.