| Date: | Wed, 30 Nov 2005 14:41:06 -0500 |
|---|
| Reply-To: | Venita DePuy <depuy001@NOTES.DUKE.EDU> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Venita DePuy <depuy001@NOTES.DUKE.EDU> |
|---|
| Subject: | Re: Code |
|---|
|
| In-Reply-To: | <A3D5552AD7F7BB4A978B8B4A376775F50649DB8F@na1ecm60.dearborn.ford.com> |
|---|
| Content-Type: | text/plain; charset="US-ASCII" |
|---|
Hi Carol -
I would try:
if substr(dsn,1,4) in (' ', 'The ', '----', 'DATA', '04040404'x ) then
delete;
-Venita
Hi .
This code give me what I want, but it seems as if it could be "cleaner".
Any ideas/tips? Thanks In Advance, Carol
DATA FILE01;
INFILE IN01;
INPUT @2 dsn $44.
@49 job_name $8.
@60 action $9. ;
if substr(dsn,1,4) = ' ' then delete;
if substr(dsn,1,4) = 'The ' then delete;
if substr(dsn,1,4) = '----' then delete;
if substr(dsn,1,4) = 'DATA' then delete;
if substr(dsn,1,4) = '04040404'x then delete;
run;
|
