Hi Guys, Im having some problems to convert a SAS char to a numeric sas date, In my project, i have a numeric column named DT_REFER, this column contains the date of my clients in sas DATE9. format ( Example: 19OCT2020), on my way in this project i needed to group by that data in a month format, so to do group by with data in sas i needed convert that DATE9. to a CHARACTER month format , i did it using a simple put function "PUT(DT_REFER, MMYYD.) AS DT_MONTH " on a proc sql with group by, now the original 19OCT2020 data has been converted to a character "10-2020" and the group by works normaly. But now i need to convert it back to a date format to send it to Teradata Database, and im having trouble to convert it back, i tried to do some input functions in a data step like that: DATA CONVERT_BACK; SET mybase; DATA_BACK = input(DT_MONTH, MMYYD.); RUN; I want to get a 10-2020 in numeric date format, but all i get is a empty DATA_BACK with a "." in it. What i need to do to solve this?
... View more