09-03-2014 08:57 AM
I have searched the forum, and unless I am missing something obvious I can't find the answer to this question...
I have monthly dates in the following format : 'JUL2010' and I need them to be converted to SAS dates. They are currently formatted as character variables. I need to get them formatted so I can work with some of the time series functions.
I am also unsure of where to do the conversion at...Currently I am bringing the dataset in via a proc import. Other discussions on similar topics had people creating a new dataset from the imported one. (Sorry for the naive question, I am just getting serious about SAS programming).
09-03-2014 09:10 AM
Use the input to convert character to a numeric format (dates/times are numeric):
format b monyy7.;