topic Re: date format in SAS Programming

date format

rohitkrishna — Tue, 25 Feb 2020 07:36:16 GMT

Hi team,

I had one regarding the date format checkpoint

the question is

if the hdrdate is 20200120

it updated fine in the table but I was given instead of 20 I have given 40 in the dd I mean to date it accepted that one how come it happens I don't know bez a month date has ending with the 31 only right

so i requesting you give some solution above problem how to put a checkpoint on the issue.

Thanks & Regards

Rohitkrishna

Re: date format

Kurt_Bremser — Tue, 25 Feb 2020 07:51:47 GMT

@rohitkrishna wrote:

Hi team,

I had one regarding the date format checkpoint

the question is

if the hdrdate is 20200120

it updated fine in the table but I was given instead of 20 I have given 40 in the dd I mean to date it accepted that one how come it happens I don't know bez a month date has ending with the 31 only right

so i requesting you give some solution above problem how to put a checkpoint on the issue.

Thanks & Regards

Rohitkrishna

Sorry, I can't make sense of this.

Please supply example data, code and logs that illustrate your issue.

Re: date format

rohitkrishna — Tue, 25 Feb 2020 08:02:45 GMT

Hi KurtBremser
Thanks for the quick response
ys sure i will give the example plz find below
{
first the hdrdate = 20200120 it's in ccyymmdd format
and it updated fine in table
then i have given hdrdate = 20200140 for testing
above date also updated
my question is how come it updated a month have only 31 days it went beyond 31 days right
how to put a checkpoint on the above issue

Thanks & Regards
Rohitkrishna

Re: date format

Kurt_Bremser — Tue, 25 Feb 2020 08:14:10 GMT

DATASET

CODE

LOG

EXPECTED OUTPUT

Please.

Re: date format

rohitkrishna — Tue, 25 Feb 2020 09:54:02 GMT

Hi KurtBremser
thanks for the response
ya sure
{
DATA DT_FT;
INFILE DATALINES;
INPUT @1 DATE $CHAR8.;
DATALINES;
20200120
20200140
;
RUN;
PROC PRINT DATA = DT_FT;
RUN;
output:
Obs DATE

1 20200120
2 20200140
my ask is how the second date has been updated
it is greater than 31 right
so my expected output is
{
20200120 it printing fine
but second, has to print error
bez it is greater than 31
}
plz kindly give some solution for the above issue
Thanks & Regards
Rohit

Re: date format

ed_sas_member — Tue, 25 Feb 2020 09:57:49 GMT

Hi @rohitkrishna

what if you read the data directly as a SAS date using the YYMMDD10. informat?

DATA DT_FT;
INFILE DATALINES;
INPUT @1 DATE:YYMMDD10.;
FORMAT DATE:YYMMDD10.;
DATALINES;
20200120
20200140
;
RUN;

PROC PRINT DATA = DT_FT;
RUN;

Re: date format

rohitkrishna — Tue, 25 Feb 2020 10:11:51 GMT

Hi ed_sas_member,
Thanks for the response it's working fine but my requirement is how to put a check point to stop the displaying the 20200140
and moreover, my expected output is
20200120
not 2020-01-20
i tried to give yymmdd8. but it shows
Obs DATE

1 20-01-20
2 .
above one i got
so plz kindly respond on the above issue
Thanks & Regards
Rohit

Re: date format

ed_sas_member — Tue, 25 Feb 2020 10:16:31 GMT

Hi @rohitkrishna

Please try this:

DATA DT_FT;
INFILE DATALINES;
INPUT @1 DATE $CHAR8.;
length check $ 20;
IF input(DATE,YYMMDD10.) ne . then check=Date;
else check = "not valid: "||date;
DATALINES;
20200120
20200140
;
RUN;

PROC PRINT DATA = DT_FT;
RUN;

Re: date format

rohitkrishna — Tue, 25 Feb 2020 10:45:00 GMT

Hi ed_sas_member
Thanks for the quick response
ya it's superb it's working fine
But my small request is
if the date is less then that it displays not valid
like
date < 31 display not valid
above condition possible kindly gives some suggestions
Thanks & Regards
Rohit

Re: date format

ed_sas_member — Tue, 25 Feb 2020 10:48:09 GMT

Hi @rohitkrishna

Here is a slight change:

DATA DT_FT;
INFILE DATALINES;
INPUT @1 DATE $CHAR8.;
length check $ 20;
IF 0 < day(input(DATE,YYMMDD10.)) <= 31 then check=Date;
else check = "not valid: "||date;
DATALINES;
20200120
20200140
;
RUN;

PROC PRINT DATA = DT_FT;
RUN;

Re: date format

rohitkrishna — Tue, 25 Feb 2020 12:05:50 GMT

Hi ed_sas_member
Thank you very much it's working
Thanks & Regards
Rohit

Re: date format

ed_sas_member — Tue, 25 Feb 2020 12:49:05 GMT

Thank you @rohitkhrishna!
Could you please accept the solution to mark the topic as answered?

Re: date format

Reeza — Tue, 25 Feb 2020 16:31:55 GMT

Because your field is CHAR8 it accepts anything that fits that structure.

If you'd like to have a date and verify it's a valid date, make the column a numeric type with a date format applied. Then if you try to insert an invalid date it will throw an error.

DATA DT_FT;
INFILE DATALINES;
informat date yymmdd8.;
format date date9.;
INPUT @1 DATE ;
DATALINES;
20200120
20200140
;
RUN;

@rohitkrishna wrote:
Hi KurtBremser
thanks for the response
ya sure
{
DATA DT_FT;
INFILE DATALINES;
INPUT @1 DATE $CHAR8.;
DATALINES;
20200120
20200140
;
RUN;
PROC PRINT DATA = DT_FT;
RUN;
output:
Obs DATE

1 20200120
2 20200140
my ask is how the second date has been updated
it is greater than 31 right
so my expected output is
{
20200120 it printing fine
but second, has to print error
bez it is greater than 31
}
plz kindly give some solution for the above issue
Thanks & Regards
Rohit

Re: date format

Tom — Tue, 25 Feb 2020 17:03:17 GMT

It is very difficult to understand what you are actually asking for.

It sounds like you have string of 8 digits and you want to use it to create a date. So use the INPUT() function with an appropriate INFORMAT will do that.

But it also sounds like you want to add a business rule that if the number represented by the last two digits is invalid as a date then to use the last day of the month implied by the first 6 digits.

Something like this:

data want;
   set have;
   datevar=input(hdrdate,??yymmdd8.);
   if missing(datevar) and not missing(hdrdate) then do;
     datevar=input(hdrdate,??yymmn6.);
     if not missing(datevar) then datevar=intnx('month',datevar,0,'end');
  end;
  format datevar date9.;
run;

Re: date format

Kurt_Bremser — Wed, 26 Feb 2020 07:46:28 GMT

@rohitkrishna wrote:

date < 31 display not valid

And what about February, April, June??? Those months do not have a 31st at all.