BookmarkSubscribeRSS Feed
SonyTrinesh
Calcite | Level 5

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.

2 REPLIES 2
PGStats
Opal | Level 21

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

PG
slchen
Lapis Lazuli | Level 10

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;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1774 views
  • 0 likes
  • 3 in conversation