09-26-2011 05:31 AM
I've got a data set where, for one reason or another, one of the date variables is coming in as a character variable. Missing variables are blank, dates are present as things like 01-Nov-08. I need these in the proper SAS days-since-1/1/1960 format.
I've tried using %sysfunc, but I can't seem to get it to cooperate. Any chance someone can point me in the right direction?
05-29-2014 01:49 PM
You don't say how you are reading the data but when you indicate " for one reason or another, one of the date variables is coming in as a character variable" I suspect proc import.
Proc Import uses lots of defaults and limited information from the source data. You might be able to write a datastep to read the data source and apply an informat at that time, but without details of the source data this is a guess.
05-30-2014 11:09 AM
What do you mean ?
Need further help from the community? Please ask a new question.