Date: Fri, 23 Jul 2004 08:58:32 -0500
Reply-To: Walter Scott <Walter.Scott@STATE.TN.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Walter Scott <Walter.Scott@STATE.TN.US>
Subject: Re: Position in a String
Content-Type: text/plain; charset=US-ASCII
You can try:
if input(badnum,3.0)=9; /* assumes badnum is a char var w/ length
if input(left(badnum),3.0)=9; /* assumes badnum is a char var of any
>>> x x <sas_user2000@YAHOO.COM> 04:10:37 23-Jul-04 >>>
I am a newbie with 8.2 on WIN platform.
I have a dataset with a field which is or should be a
4 digit number entered as a character.
Due to data entry error the field may have 1, 2, or 3
digits and in any position. ie "9 " or " 9 " or "
9 " or " 9".
I do have a list of those numbers and i need to know
what record they belong to but not knowing in what
position the number or numbers may be I was wondering
if there is a simpeler method that can look for the
number or numbers any of the 4 positions in the field?
I have been using the following for each position
which is time consuming. Is there an easier way?
if badnum ="9 " or badnum = " 9 " or badnum=" 9 "
or badnum= " 9";
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!