Link to home
Start Free TrialLog in
Avatar of raniravs
raniravs

asked on

how to convert date wich is in MM/DD/YYYY to YYYYMMDD in enterprise SAS on unix platform

Hi,
   Here is my data set by name "file1.sas7b.dat"

                  Patient ID           DOB
1.              2SRE3456            01/12/2014
2.              S456HRW             1/2/2014
3.              GT567575            02/01/2014

Here is my SAS Enterprise program to convert DOB to YYYYMMDD. But it is not working... ANy help will be greatly appreciated

Data file2_YYYYMMDD;
   set file1;
New_Date = Input(TRIM(DOB),MMDDYY10.);
Run;
ASKER CERTIFIED SOLUTION
Avatar of Ian
Ian
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial