05-29-2012 07:57 AM
I have a date field that is defined as character(MMDDYYCC).
Example: 11301220(Novermber 30th, 2012)
Could anyone please help me to convert this to CCYYMMDD in Numeric value?
The result should look like this: 20121130.
The reason why I need this in Numeric value is to sort this data.
Thank you for your help in advance!!
05-29-2012 08:44 AM
format date1 yymmddn8.;
05-29-2012 09:11 AM
Thank you very much for the prompt response. I really appreciate it.
The thing is I'm completely new to SAS Enterprise Guide pr SAS and I was trying to use your code in the "Computed Columns" like this:
format date yymmddn8.:
And it gave me an error.
Would it be possible for you to tell me how I can do this in the Enterprise Guide screen?
Thank you very much!!
05-29-2012 09:19 AM
sorry. I am among those old school SAS programmers who are NOT the targeting populations of EG. I have never used EG myself even I know it has been installed on my pc. I am sure someone on the forum with EG experience will surely come to rescue.
On a side note, if you have posted your question on EG board, I would probably have never responded.