topic Re: How to check the date format in SAS Programming

How to check the date format

SonyTrinesh — Mon, 02 Jun 2014 17:30:16 GMT

Hi all,

I have a Data set, it contains date column .My requirement is if the date values is not in the given format i just want to reject the record.

Example:

Data One;

informat Bday yyyymmn6.;

format Bday yyyymmn6.;

input Bday yyyymmn6.;

cards;

201401

201402

20140312

;

run;

I dont want the third record because it is not in given format and i want to capture in another table, for this is there any functions whether the date value is in particular format.

So can any one have idea on above case.

Re: How to check the date format

PGStats — Mon, 02 Jun 2014 17:53:01 GMT

The most flexible tool to achieve this is pattern matching :

Data One;

format Bday yymmn6.;

input BdayTxt $ ;

if prxmatch("/^[12]\d{3}[01]\d$/o", trim(bDayTxt)) then Bday = input(BdayTxt, yymmn6.);

cards;

201401

201402

20140312

;

proc print data=one; run;

Re: How to check the date format

slchen — Mon, 02 Jun 2014 19:03:55 GMT

Try this:

Data One;

input@;

if length(_infile_)^=6 then delete;

input Bday ;

informat Bday yymmn6.;

format Bday yymmn6.;

cards;

201401

201402

20140312

201406

;

run;

proc print;

run;