topic Re: Date format in SAS Programming

Date format

JHE — Mon, 23 Aug 2021 14:46:10 GMT

Date for example: 3/21/2021,

want to convert to 2021/3/21,

Is there as good way to do instead convert to Str ...?

Does SAS has date format as yyyy/mm/dd ?

Re: Date format

PaigeMiller — Mon, 23 Aug 2021 15:00:31 GMT

@JHE wrote:

Date for example: 3/21/2021,

want to convert to 2021/3/21,

Is there as good way to do instead convert to Str ...?

Does SAS has date format as yyyy/mm/dd ?

just assign a different format to this variable.

You want

format variablename yymmdds10.;

in a DATA step or PROC

Re: Date format

ballardw — Mon, 23 Aug 2021 14:59:29 GMT

SAS has a LOT of date, time and datetime formats plus you can roll your own. However you want to start with an actual SAS date value.

https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates.

If you already have date value then you just assign the format you want with a Format statement such as

Format datevariable yymmdd10.;

One of the very nice things about formats is that you can specify the format to use just about anytime you need to and are not stuck with a default set.

Example for creating a date value and then displaying it in Proc print with different formats:

data example;
   date ='21Mar2021'd;
   format date date9.;
run;
/* this uses whatever the default format may be*/
Proc print data=example noobs;
run;

Proc print data=example;
   format date yymmdd10.;
run;

Proc print data=example;
   format date worddate.;
run;

/* Julian date: year and then day of the year*/
Proc print data=example;
   format date juldate.;
run;

I suggest keeping track of https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/leforinforref/n0p2fmevfgj470n17h4k9f27qjag.htm

so you can look up the SAS formats and informats by type easily.

Re: Date format

JHE — Tue, 24 Aug 2021 20:20:24 GMT

thank you.

But need result as: YYYY/MM/DD, such as 2021/02/23

Re: Date format

JHE — Tue, 24 Aug 2021 20:36:08 GMT

I go it, YYYMMDDSD10.

Re: Date format

Cynthia_sas — Tue, 24 Aug 2021 20:47:08 GMT

Hi:

There is a way in the yymmdd format to specify what type of separator you want. Here's an example that shows the BIRTHDAY variable being read into a SAS numeric variable that represents a date. Then the year the person turns 21 and the year they turn 65 are calculated using the INTNX function to create 2 new variables. The date variables are each displayed using a different format for display:

Cynthia

Re: Date format

Kurt_Bremser — Tue, 24 Aug 2021 20:48:29 GMT

WHY DON'T YOU READ THE DOCUMENTATION???

YYMMDDxw. Format