topic Re: different dates different format in SAS Programming

different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:00:31 GMT

Hi Experts

GoodMorning

here i have a dataset

how to print different date formats

i want ouput print datastep and proc step

data ds;
infile datalines;
input date anydtdte.;
format date date9.;
datalines;
01-01-17
30-10-19
31-10-19
01-11-19
02-11-19
03-11-19
30-Oct-17
31-Oct-17
1-Nov-17
2-Nov-17
3-Nov-17
30-10-19
31/01/16
01/05/16
15/05/16
;
run;

Re: different dates different format

PeterClemmensen — Wed, 30 Oct 2019 09:04:52 GMT

I assume you want to print the date value as they are in the datalines, correct?

Re: different dates different format

Patrick — Wed, 30 Oct 2019 09:06:48 GMT

SAS Date formats allow you to define how a SAS data value gets printed. You can either assign such a format permanently to a SAS variable, ie. via a Format statement, or you can define the format directly in many procedures.

Re: different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:07:52 GMT

Split the date formats as it is

In datalines

Re: different dates different format

Patrick — Wed, 30 Oct 2019 09:13:28 GMT

Docu here

data ds;
  infile datalines;
  input date anydtdte.;
  format date ddmmyyd10.;
  datalines;
01-01-17
30-10-19
31-10-19
01-11-19
02-11-19
03-11-19
30-Oct-17
31-Oct-17
1-Nov-17
2-Nov-17
3-Nov-17
30-10-19
31/01/16
01/05/16
15/05/16
;
run;

proc print;
run;

Re: different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:14:37 GMT

Split as dataset accordingly with date formats

Re: different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:18:57 GMT

Split as different dataset as given date formates

Re: different dates different format

Patrick — Wed, 30 Oct 2019 09:22:41 GMT

@BrahmanandaRao

Please explain in more detail or even better show us how the desired result based on your sample data should look like. Your "twitter feeds" leave too much open.

Re: different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:33:02 GMT

Here 15 dates in different formats

So i want those date formats split into according date formates

As per given data 15 dates each date format

Print as one dataset

Re: different dates different format

Patrick — Wed, 30 Oct 2019 09:39:09 GMT

@BrahmanandaRao

The data step you've posted uses informat anydtdte. to convert the source strings into SAS Date values. This appears to work.

You then apply a SAS Format to print these SAS Date values (a count of days since 1/1/1960) in a human readable form.

SAS format ddmmyyd10. prints SAS Date values in the form dd-mm-yyyy

That's my answer to how I understand your question with the code already provided previously. If you need anything else then please explain better or show us the desired result based on the data you've already posted.

Re: different dates different format

Jagadishkatam — Wed, 30 Oct 2019 09:45:56 GMT

please try

data date1 date2 date3;
infile datalines;
input date $10.;
if prxmatch('m/\d{2,2}\-\d{2,2}\-\d{2,2}/oi',date) then output date1;
else if prxmatch('m/\w[a-z]+/oi',strip(date)) then output date2;
else if prxmatch('m/\d{2,2}\/\d{2,2}\/\d{2,2}/oi',date) then output date3;
datalines;
01-01-17
30-10-19
31-10-19
01-11-19
02-11-19
03-11-19
30-Oct-17
31-Oct-17
1-Nov-17
2-Nov-17
3-Nov-17
30-10-19
31/01/16
01/05/16
15/05/16
;
run;

Re: different dates different format

BrahmanandaRao — Wed, 30 Oct 2019 09:50:11 GMT

Hi patrick

i want output print as below like different datasets

dataset 1	dataset 2	dataset 3
01-01-17	30-Oct-17	30/10/19
30-10-19	31-Oct-17	31/01/16
31-10-19	01-Nov-17	01/05/16
01-11-19	02-Nov-17	15/05/16
02-11-19	03-Nov-17
03-11-19

Re: different dates different format

Jagadishkatam — Wed, 30 Oct 2019 09:57:20 GMT

I believe the code i posted does the same, could you check.