hi
I have a file that has dob dates coming in with char formats as 12/31/1977 and 1914-07-15. Same field different formats. How do i make them in the same format coming in as char in the end?
Thank you
You shouldn't store as char because you can't do calculations on a char date variables, but try anydtdte as your informat. If you really want it as a char you can convert it.
I am with @LinusH here, the problem lies with your data supplier. You will of course have a data import agreement setup which defines the structure, content of the data yes? If not, then whatever you code may need to change next time you get data, I mean wht if the vendor decides to drop that field, or add a field, or change them all to DDMONYYYY? The control and specification is all in the documentation, programming is more or less irrelevant.
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.