Date Format

[Ela_84]

Hi Everyone 

I'm trying to format a numeric date field from '2020-11-30' to Date9. 30NOV2020. 

The below query is not working :

data want
set need

New_Date = input(Date, DDMMYYD10.);
format New_Date  date9.;

run;

[novinosrin]

you do not need to convert as your var is already numeric. Just format

data want
set need

New_Date = input(Date, DDMMYYD10.);
format date date9.;

run;

[Ela_84]

I get the below error

27 format Date Date9.;
______
484
NOTE 484-185: Format $DATE was not found or could not be loaded.

[novinosrin]

Can you do a PROC CONTENTS and check the data type of the variable plz .

The Proc CONTENTS report will contain information about the metadata or for easy understanding so called properties. Should your Date be character, you would of course need to convert to a numeric SAS date and assign to a new variable that is of type numeric.

@Ela_84 If it all your date is of type char, it may appear your dates are in the from YYMMDD, and therefore the appropriate INFORMAT needed to convert to numeric would also be YYMMDD10. 

So basically,

data test;
 char_Date='2020-11-30';
 num_sas_date=input(char_date,yymmdd10.);/*convert to numeric and save in a new var*/
 format num_sas_date date9.;
run;

[zaval025]

I was searching for 45 mins for the solution to this exact problem and this worked for me. Thank you so much!!!

[Tom]

You need to use a valid INFORMAT with the INPUT() function. There is no informat named DDMMYYD. 

Also if the strings follow the pattern YYYY-MM-DD then you want to use the YYMMDD10. informat.