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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.