topic change date format from $10. in SAS Procedures

change date format from $10.

sasphd — Fri, 31 May 2024 18:53:16 GMT

Hello

I want to change date format from $10. to yymmn6.

thanks

Re: change date format from $10.

ballardw — Fri, 31 May 2024 19:04:22 GMT

You will need to show some example values of your existing variable. The $10 attached to your variable means that it is a character value and so a date formatcannot be applied. You have to create a new variable this is numeric with the appropriate date value. To help do that you need to provide examples of the current variable and we can show how to make a date value.

Re: change date format from $10.

sasphd — Fri, 31 May 2024 19:06:57 GMT

Hello

my date variable is like "2023-09-18" but its format in SAS is $10.

I want to transform it to date format

thanks

Re: change date format from $10.

ballardw — Fri, 31 May 2024 19:30:32 GMT

Make a new data set with an added variable. Once a variable has a type you cannot change it.

data want;
   set have;
   newdatevar = input(current_datevar,yymmdd10.);
   format newdatevar yymmn6.;
run;

@sasphd wrote:

Hello

my date variable is like "2023-09-18" but its format in SAS is $10.

I want to transform it to date format

thanks

Re: change date format from $10.

Kurt_Bremser — Fri, 31 May 2024 22:31:55 GMT

Suppose the name of your variable is datevar.

data want;
set have (rename=(datevar=_datevar));
datevar = input(_datevar,yymmdd10.);
format datevar yymmn6.;
drop _datevar;
run;