topic Re: Checking date in SAS Procedures

Checking date

nickb — Thu, 24 Jan 2013 17:25:01 GMT

I'm trying to use an IF statement to check and see if the value I want is in the date format MMDDYY8. and if so do.....

Data:


	ENG-112 ENGLISH COMPOSITION II..... 06/30/03 CR	1.5 *TE
	ENG-113 ENGLISH COMPOSITION III.... 06/30/03 CR	1.5 *TE

IF statement:

IF index(row, '-')= 14 and ANYDIGIT(row)= 15 and substr(row,findc(row, '/')-2,8)= "MMDDYY8.d" then

....

end;

Re: Checking date

Reeza — Thu, 24 Jan 2013 17:28:40 GMT

Is your data one long string or are you trying to figure out how to parse it? I would parse it as text and then deal with it separately, you can try anydtdte format as well as an informat.

Re: Checking date

nickb — Thu, 24 Jan 2013 17:49:34 GMT

It is one long string. I plan on parsing it but i need the IF statement to check and make sure I want the values.

Re: Checking date

ballardw — Thu, 24 Jan 2013 18:03:32 GMT

You may want something like:

pos = prxmatch('/\d{2}\/\d{2}\/\d{2} /',x);

X is the name of the variable to search the string.

Pos here is the position that a dd\dd\dd<space> string is found in X

You need to have the final space as otherwise dd\dd\dddd would not be differentiated.

Re: Checking date

DBailey — Thu, 24 Jan 2013 18:10:12 GMT

I guess you could hard code it:

data work.have;

length row $100.;

input @1 row $Char69.;

if substr(row,14,1)='-' and input(substr(row,47,8),mmddyy8.) ne . ;

cards;

ENG-112 ENGLISH COMPOSITION II..... 06/30/03 CR 1.5 *TE

ENG-113 ENGLISH COMPOSITION III.... 06/30/03 CR 1.5 *TE

;

run;

Re: Checking date

Astounding — Thu, 24 Jan 2013 18:28:38 GMT

To avoid getting messages about invalid data, you might want to replace this:

,mmddyy8.)

with this:

,??mmddyy8.)

Re: Checking date

ballardw — Thu, 24 Jan 2013 18:34:38 GMT

Test this version with a line of data containing 06/10/2003 and see what happens. This was my first approach to the logic.

It will treat it as a valid date of 6/10/1920 (assuming your year cutoff date is the same as my default).

If you never have mm/dd/yyyy data no problem.

Also, if the date is invalid such as 02/30/03 it will also be missing. So you may need to check further.