topic Re: SAS String Function to lookup certain character? in SAS Programming

SAS String Function to lookup certain character?

deleted_user — Thu, 04 Sep 2008 10:24:40 GMT

Hi

I want to delete from an input dataset whenever a certain record contains the - (dash) character.

For example, Serial Number 125345-5545

So, if there is such a serial number like this, I want to exclude it from the input dataset

DATA XXXX;
INPUT YYYY;
@01 Serial $10.
;

Is there a string function that parses "Serial" in this case such that I can say something like this:

if SomeStringFunction(Serial,"-") then delete;

Thanks
Shelton.

Re: SAS String Function to lookup certain character?

LinusH — Thu, 04 Sep 2008 11:19:35 GMT

if index(serial,'-') then delete;

would probably do the job.

Regards,
Linus

Re: SAS String Function to lookup certain character?

deleted_user — Thu, 04 Sep 2008 22:24:50 GMT

Thankyou Linus - that worked.

Cheers
Shelton.