Solved: date

kathisas · Posted 03-11-2017 03:54 AM

hey 🙂

please please help 🙂

I have got an excel file that I converted to a sas dataset.

put the date is shown as an characteristic variable and I need to convert this to a date variable.

I tried a lot and I am new with SAS and programming. I study medcine and need this for results. so please help me.

thanks a lot

kathisas · Posted 03-11-2017 06:25 AM

thanks a lot for your quick answers.

but my problem is solved now.

since I deleted the points in my excel files sas read the variables as date 🙂

thanks a lot.

and for everyone no points in excel files for missing values. this can misinterpret sas variable reading!!

ChrisBrooks · Posted 03-11-2017 05:35 AM

Can you post an example of what the dates look like please?

kathisas · Posted 03-11-2017 06:25 AM

thanks a lot for your quick answers.

but my problem is solved now.

since I deleted the points in my excel files sas read the variables as date 🙂

thanks a lot.

and for everyone no points in excel files for missing values. this can misinterpret sas variable reading!!

mkeintz · Posted 03-12-2017 07:25 PM

Then please mark your topic as solved.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

date