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?
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
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
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.
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
Jag - it wasn't a typo, it was in Spanish. December => Diciembre en español...
Looks like the problem has been resolved though...
Thank you Chris,
I thought it was a typo error as i saw the other names similar to English names.
Exactly, in Spanish it's Diciembre. I will try to change the month to see what happens.
You were totally right. Thank you very much.
Thank you for checking this and confirming.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.