Good Day to all you SAS users,
I would like some advice on a problem with SAS. I am importing an ACCESS DB with specific dates into SAS. Unfortunately, the field is coming over as date/time format. I would like to convert it to date only. I tried a number of manipulations (substr, format, scan) but with no luck.
Input data is imported in following format :
30OCT2003:00:00:00
04APR2003:00:00:00
25MAR2003:00:00:00
17JUN2003:00:00:00
etc.
Desired output:
30102003
04042003
25032003
17062003
Any feedback is much appreciated.
Thanks
I would like some advice on a problem with SAS. I am importing an ACCESS DB with specific dates into SAS. Unfortunately, the field is coming over as date/time format. I would like to convert it to date only. I tried a number of manipulations (substr, format, scan) but with no luck.
Input data is imported in following format :
30OCT2003:00:00:00
04APR2003:00:00:00
25MAR2003:00:00:00
17JUN2003:00:00:00
etc.
Desired output:
30102003
04042003
25032003
17062003
Any feedback is much appreciated.
Thanks