May I know how to convert the data to date9. format? Thanks.
Post data, in the form of a datastep, in a code window ({i} above your post). I will not download files.
If your data is character which is probable, then you input() the data with the approriate format:
e.g. if you have 01-04-2016
datevar=input(chardate,ddmmyy10.); format datevar date9.;
Post data, in the form of a datastep, in a code window ({i} above your post). I will not download files.
If your data is character which is probable, then you input() the data with the approriate format:
e.g. if you have 01-04-2016
datevar=input(chardate,ddmmyy10.); format datevar date9.;
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.