topic Re: How to change date format in SAS Programming

How to change date format

Gieorgie — Tue, 26 Oct 2021 13:59:59 GMT

I would like to change the date format to the picture below 2021-01 eg I found in the documentation that it is YYMMw. However, when he tries to format, he gets this result.

When i tried use subtr like this:

    ,input(substr(t1.PRP_END_DATE,1,4)||'-'||substr(t1.PRP_END_DATE,5,2),yymmdd10.)		as POLICY_VINTAGE,

i got error :ERROR: Function SUBSTR requires a character expression as argument 1.

This my result :

And this is my code:

PROC SQL;     
create table PolisyEnd as 
    select distinct  
  ,datepart(t1.PRP_END_DATE) as PRP_END_DATE format yymmdd10.
	,datepart(t1.PRP_END_DATE) as POLICY_VINTAGE format YYMMw.,

Re: How to change date format

FreelanceReinh — Tue, 26 Oct 2021 14:23:54 GMT

Hello @Gieorgie,

@Gieorgie wrote:

I would like to change the date format to the picture below 2021-01 (...)
PROC SQL;     
create table PolisyEnd as 
    select distinct  
  ,datepart(t1.PRP_END_DATE) as PRP_END_DATE format yymmdd10.
	,datepart(t1.PRP_END_DATE) as POLICY_VINTAGE format YYMMw.,

Use the YYMMD. format. (The "w" in "YYMMw." is just a place holder for the width specification as in YYMM7..)

Re: How to change date format

PaigeMiller — Tue, 26 Oct 2021 14:48:18 GMT

@Gieorgie

We're trying to help you, so please help us. From now on do not show us error messages detached from the code. Please do show us the complete log, so we can see the code and the error message on the next line. Please also format the log properly, by copying the log as text and then pasting it into the window that appears when you click on the </> icon here in the SAS communities.

Re: How to change date format

ballardw — Tue, 26 Oct 2021 15:02:30 GMT

If you have a date, time, or datetime value then usually the easiest way to get a piece of the value is an appropriate date or time function. If you have a datetime value and want date elements then use the Datepart function to get the date information and then the day, month, year function.

data example;
   date = '23Jan2021'd;
   time = "12:45:18"t;
   dt   = "14Jun2021:09:23:14"dt;
   format date date9. time time8. dt datetime18.;
   dayofmonth = day(date);
   monthnumber= month(date);
   yearnumber = year(date);
   hour = hour(time);
   minutes = minute(time);
   seconds = second(time);
   dtday = day(datepart(dt));
   dtmon = month(datepart(dt));
   dthour = hour(dt);
run;

You want to test, as in create a variable with the value of any concatenation involving the || operator. The results may surprise you. Consider this example of concatenating a string with a numeric value 4 different ways. See the different results.

data example2;
   length x $ 30;
   x='abcdefg';
   y=25;
   cat1 = x||y;
   cat2 = cats(x,y);
   cat3 = cat(x,y);
   cat4 = catt(x,y);
run;

Also note in the log that only one of these provides a warning about conversion of numeric to character values.

The MDY function may be something to investigate to create new date value.

Re: How to change date format

Kurt_Bremser — Tue, 26 Oct 2021 15:44:40 GMT

This format will result in your wanted displayed value:

as POLICY_VINTAGE format yymmd7.