topic Re: Input date format like YYYY-MM-DD? in SAS Programming

Input date format like YYYY-MM-DD?

ybz12003 — Thu, 11 Oct 2018 17:42:38 GMT

Hi all:

If I have a data like 2014-06-09, please advise me how to input it from a text file into date format as in SAS file.

Thanks.

Re: Input date format like YYYY-MM-DD?

novinosrin — Thu, 11 Oct 2018 17:44:33 GMT

do you mean

input date yymmdd10.;
format date yymmdd10.;

Re: Input date format like YYYY-MM-DD?

PaigeMiller — Thu, 11 Oct 2018 17:45:09 GMT

Using the Informat YYMMDD10. ought to work.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=leforinforref&docsetTarget=n18uyqeusnl0fxn1d9pvhm49j4za.htm&locale=en

Re: Input date format like YYYY-MM-DD?

ybz12003 — Thu, 11 Oct 2018 18:13:37 GMT

What about 12/9/2018?

Re: Input date format like YYYY-MM-DD?

novinosrin — Thu, 11 Oct 2018 18:15:09 GMT

do you have a mix of date values with some being yymmdd ,yymmdd and ddmmyy?

Re: Input date format like YYYY-MM-DD?

ballardw — Thu, 11 Oct 2018 18:26:40 GMT

@ybz12003 wrote:

What about 12/9/2018?

That is actually ambiguous as we cannot tell from the given value which is the month and which is the day.

There are a whole slew of date informats

mmddyy

ddmmyy

yymmdd

date

If your data in provided external file has varied date formats there is even ANYDTDTE. but that guesses about some sorts of values and they may not match your need.

Re: Input date format like YYYY-MM-DD?

ybz12003 — Thu, 11 Oct 2018 18:35:52 GMT

I don't have a mix date format, but I do have the different date format due to the source coming from the different places. For example,

A city's date format is 12-08-2015

B city's date format is 12/8/2016

C city's date format is 05/25/2015

Re: Input date format like YYYY-MM-DD?

Kurt_Bremser — Thu, 11 Oct 2018 18:34:55 GMT

@ybz12003 wrote:

What about 12/9/2018?

Do a google search for "sas date informats", and then select an informat from the documentation that suits your input data.

Re: Input date format like YYYY-MM-DD?

novinosrin — Thu, 11 Oct 2018 18:42:29 GMT

Does your source data looks like

A city's date format is 12-08-2015

B city's date format is 12/8/2016

C city's date format is 05/25/2015

If yes, let us know how you want to read it? Should i assume

A city's date format is --one char variable

12-08-2015--date variable

would be clear to let know what you want

Re: Input date format like YYYY-MM-DD?

PaigeMiller — Thu, 11 Oct 2018 19:02:44 GMT

A city's date format is 12-08-2015

B city's date format is 12/8/2016

C city's date format is 05/25/2015

As pointed out above, this is ambiguous. Can you clarify if A and B are month-day-year, or day-month-year?

Also, the different delimiters are not really a problem here, the format should read the dates properly even if the delimiters change.

Re: Input date format like YYYY-MM-DD?

ybz12003 — Thu, 11 Oct 2018 19:09:53 GMT

A city's date format is 12-08-2015 DD-MM-YYYY

B city's date format is 12/8/2016 MM/D/YYYY

C city's date format is 05/25/2015 MM/DD/YYYY

Re: Input date format like YYYY-MM-DD?

PaigeMiller — Thu, 11 Oct 2018 19:17:52 GMT

After you have identified in your own mind which city uses which convention as far as month-day-year or day-month-year, you need to write code so that the city will be read via the proper informat, which is MMDDYY. or DDMMYY. or possibly others

Maybe something like this

data want;
    input chardate $10. othervariables ... ;
    if city='A' then date=input(chardate,ddmmyy10.);
    else if city in ("B","C") then date=input(chardate,mmddyy10.);
    format date date7.;
run;

Re: Input date format like YYYY-MM-DD?

Ksharp — Fri, 12 Oct 2018 13:26:13 GMT

data have;
input char_date : $20. fmt : $20.;
num_char=inputn(char_date,fmt);
format num_char date9.;
cards;
12-08-2015  DDMMYY12.
12/8/2016   MMDDYY12.
05/25/2015  MMDDYY12.
;
run;
proc print;run;

Re: Input date format like YYYY-MM-DD?

ybz12003 — Tue, 16 Oct 2018 12:50:07 GMT

Thanks for all of your great suggestion. It helps! 🙂

Re: Input date format like YYYY-MM-DD?

KentL — Thu, 26 Mar 2020 02:01:21 GMT

this is a more elegant solution. At first I thought it was yyyymmdd10. Of course not! yymmdd10.

Re: Input date format like YYYY-MM-DD?

nktomar — Mon, 28 Jun 2021 05:28:40 GMT

format my_date YYMMDDD10.;
my_date = today();