I've a raw file with different date values in different records.
eX:
Datalines;
08DEC2015
12112014
201113
;
How to read different date types from raw file.
Don't be surprised if you get values you don't expect.
Your example of 12112014 will depend on your national language setting for whether that is supposed to be MM/DD/YY or DD/MM/YY.
And 201113 is likely to have problems if it is supposed to be YYYYMMDD as it could be interpreted as 2011 Jan 3 or 20 Nov 2013
Personally I wouldn't risk trying to work with that data. Go back to your data import agreement - you have on of those right? - and check what it states in there. If you dont have one of those, make one and get the vendor to agree to it. They should be providing a robust, structured dataset, which they currently are not. For instance, what does 12112014, mean? Is it december or november. As with everything programmatic - specify, specify, specify, then code. Programming is in fact 99% irrelevant, specification and documentation is the key.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: