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.
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;
PG
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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.