topic Re: Retrieving observations with specific letter/number in specific position in SAS Programming

Retrieving observations with specific letter/number in specific position

mlogan — Fri, 15 Apr 2016 01:59:54 GMT

Hi All,

I have the follwoing dataset and I want to retrieve the observations where variable CODE has 3 or 4 in its fourth position. can someone write the code for me please. Thanks.

data have;
input ID CODE$ 7.;
cards;
101 BIO4MU
101 ENG3NO
102 PHY2L
102 LOS1KO
103 HUM3P
;
RUN

Expected Output

ID CODE
101 BIO4MU
101 ENG3NO
103 HUM3P

Re: Retrieving observations with specific letter/number in specific position

Reeza — Fri, 15 Apr 2016 02:02:20 GMT

Look at the SUBSTR function.

Re: Retrieving observations with specific letter/number in specific position

PGStats — Fri, 15 Apr 2016 02:04:01 GMT

if char(code,4) in ("3","4");

Re: Retrieving observations with specific letter/number in specific position

mlogan — Wed, 18 May 2016 18:48:13 GMT

Hi PG Stats,
Would to please help me with the code to find where the observations ends with 'C' and at the same time 'C' appears in the sixth position as well. Simething like: 12ABDC, BH3GLC.

So far I have written what finds the C in the sixth position:

DATA Want;
SET Have;
IF char(var1,6) in ("C");
RUN;

Thanks,

Re: Retrieving observations with specific letter/number in specific position

Reeza — Wed, 18 May 2016 18:55:59 GMT

Use length(var1) to find the length of a variable and the corresponding last character

or use Reverse function and take the first character.

Re: Retrieving observations with specific letter/number in specific position

PGStats — Wed, 18 May 2016 19:14:55 GMT

IF char(var1, 6) = "C" and length(var1) = 6;