topic Re: Converting Character date to sas date in New SAS User

Converting Character date to sas date

MagD — Mon, 06 Apr 2020 14:40:38 GMT

Hi All,

I hope everyone is keeping safe during these uncertain and difficult times of global pandemic.

Please assist me with some coding regarding dates. I am trying to change this date 2020-04-06 (character) to ''06Apr2020'' in sas. Please assist me.

Re: Converting Character date to sas date

Reeza — Mon, 06 Apr 2020 14:46:29 GMT

sas_date = input(character_date, yymmdd10.);
format sas_date yymmdd10.;
*format sas_date date9.;

INPUT() converts the variable to a SAS date

FORMAT controls the appearance of the date, try un-commenting the third line to see the difference.

@MagD wrote:

Hi All,

I hope everyone is keeping safe during these uncertain and difficult times of global pandemic.

Please assist me with some coding regarding dates. I am trying to change this date 2020-04-06 (character) to ''06Apr2020'' in sas. Please assist me.

Re: Converting Character date to sas date

Tom — Mon, 06 Apr 2020 14:47:07 GMT

You can use INPUT() function (or INPUTN or INPUTC) to convert TEXT into VALUES. The INFORMAT for converting strings like that is YYMMDD. Once you have a date value you can attach the DATE format to have it displayed as text in the style you mentioned.

So if your source dataset is named HAVE and the strings are in the variable named CHAR then this data step will make a new dataset named WANT with a new numeric variable named NUM with the converted date values.

data want;
  set have;
  num = input(char,yymmdd10.);
  format num date9. ;
run;

Re: Converting Character date to sas date

MagD — Mon, 06 Apr 2020 15:01:41 GMT

Hi Reeza,

I've used your recommended solution but I am getting the following error:
''Format $DATE was not found or could not be loaded''. This error is applicable to the date9.

Re: Converting Character date to sas date

PaigeMiller — Mon, 06 Apr 2020 15:07:41 GMT

There is no $ before DATE.

Show us your code. Error messages by themselves without seeing the code are not particularly useful.

Re: Converting Character date to sas date

Tom — Mon, 06 Apr 2020 15:06:08 GMT

You cannot attach a numeric format, DATE, to a character variable. When you do that SAS tries help fix your mistake by assuming you meant to use a character format. But it cannot find any format named $DATE. Make sure that the variable you are creating to store the date values is numeric.

Re: Converting Character date to sas date

Reeza — Mon, 06 Apr 2020 15:18:42 GMT

Did you change the variable name or try and use the same variable name? You cannot keep the same variable name or need to rename it.

Show your code.

Re: Converting Character date to sas date

MagD — Mon, 06 Apr 2020 15:26:53 GMT

Hi,

This is my code:

data want;
set invoices;
invoice_date = input(character_date, yymmdd10.);
format invoice_date date9.;
run;

The invoice_date variable is the variable that I am trying to change from 2020-03-03 to 03MAR2020 but I am getting the following error:

Format $date9. was not found or could not be loaded.

Re: Converting Character date to sas date

Tom — Mon, 06 Apr 2020 15:34:48 GMT

@MagD wrote:

Hi,

This is my code:

data want;
set invoices;
invoice_date = input(character_date, yymmdd10.);
format invoice_date date9.;
run;

The invoice_date variable is the variable that I am trying to change from 2020-03-03 to 03MAR2020 but I am getting the following error:

Format $date9. was not found or could not be loaded.

Your comment makes it sound like INVOICE_DATE is the existing character variable. Your code is trying to create a NEW variable named INVOICE_DATE from an existing character variable named CHARACTER_DATE. The error message is basically saying that INVOICE_DATE already existed and is a CHARACTER variable. You also should have had notes about SAS converting the numeric values that the INPUT() function generate to text when it tried to store the results into the character variable.

Do you want to create a numeric date variable or not? What name do you want this new variable to have? Perhaps you just need to add a RENAME= dataset option on the reference to INVOICES in the SET statement.

set invoices(rename=(invoice_date=character_date));

Re: Converting Character date to sas date

Tom — Mon, 06 Apr 2020 15:56:40 GMT

If you just want leave it as a character variable but change how the dates are represented as character strings then add a PUT() function call to the assignment statement.

invoice_date = put(input(invoice_date , yymmdd10.),date9.);

Re: Converting Character date to sas date

MagD — Mon, 06 Apr 2020 16:03:27 GMT

Thanks everyone for all of the assistance. I will try all of the suggested changes tomorrow and revert.

Thank you, everyone.😊

Re: Converting Character date to sas date

MagD — Fri, 17 Apr 2020 07:05:12 GMT

I used this code as the solution:

data fix_date;
set ECOM.Invoiced_Apps;
format Inv_Date date9.;
Inv_Date = mdy(substr(Invoice_Date,6,2),substr(Invoice_Date,9,2),substr(Invoice_Date,1,4));
run;

Thank you all for all of your assistance with this query.