topic date format in SAS Data Management

date format

ab97_cd — Wed, 27 Nov 2019 15:11:23 GMT

Hi,

I have problem with date variable. I want to have format DD/MM/YYYY.

This is my code which doesn't work (date format is BEST12.):

DATA xxx;
   INPUT quantity date DDMMYY10. id;
   DATALINES;
   59 01/01/2009 3
   59 01/02/2009 2
   59 01/03/2009 1
;

Re: date format

PaigeMiller — Wed, 27 Nov 2019 15:12:14 GMT

Use the proper format, DDMMYYS10.

DATA xxx;
   infile cards missover;
   INPUT quantity date DDMMYY10.;
   format date ddmmyys10.;
   DATALINES;
   59 01/01/2009 
   59 01/02/2009 
   59 01/03/2009 
;

Re: date format

Amir — Wed, 27 Nov 2019 15:16:28 GMT

Further to the solution provided by @PaigeMiller, more details can be found in the documentation, including for data that uses another separator for dates:

https://documentation.sas.com/?docsetId=ds2ref&docsetTarget=p1uyobuitxtzhwn10vu2ri4v0p00.htm&docsetVersion=3.1&locale=en

Kind regards,

Amir.

Re: date format

novinosrin — Wed, 27 Nov 2019 15:24:41 GMT

Hi @ab97_cd Your code works fine. An addition of a format statement to display SAS dates makes it convenient for reading ease.

DATA xxx;
   INPUT quantity date DDMMYY10. id;
   format date ddmmyy10.;
   DATALINES;
   59 01/01/2009 3
   59 01/02/2009 2
   59 01/03/2009 1
; 

proc print noobs;run;

quantity date id 
59 01/01/2009 3 
59 01/02/2009 2 
59 01/03/2009 1

Re: date format

Kurt_Bremser — Wed, 27 Nov 2019 15:33:47 GMT

Use the colon modifier, or the format will override the delimiters.

Also assign a date display format when using an informat:

data xxx;
input quantity date :DDMMYY10. id;
format date ddmmyy10.;
datalines;
59 01/01/2009 3
59 01/02/2009 2
59 01/03/2009 1
;

The ddmmyy informat accepts all kinds of separators: colons, dashes, slashes, underlines, periods:

data test;
input date :ddmmyy10.;
format date yymmddd10.;
datalines;
27.11.2019
27/11/2019
27-11-2019
27_11_2019
27:11:2019
;

Re: date format

Krissy217 — Mon, 14 Dec 2020 02:59:17 GMT

You will need to use the DDMMYYS10. format. This tells SAS you want to have 10 characters (including the slashes) in your date and the "S" says to use slashes in the format.

You will need a format statement before the datelines statement that looks like:

Format date DDMMYYS10.;