topic Re: Selecting one unit in a string of units in New SAS User

Selecting one unit in a string of units

juliagoolia — Fri, 18 Mar 2022 20:12:23 GMT

Hello!

I have a variable field that has 8 slots for 8 optional answers (A-H). They are not always in the same place, so I can't use substr.

I basically need to select all individuals who have an 'A' anywhere in the variable. Something like:

proc freq;

table var;

where var contains A; (How do I say this in SAS?)

Thank you so much for any assistance! I've been having trouble with the right search terms for google.

Julia

Re: Selecting one unit in a string of units

ballardw — Fri, 18 Mar 2022 20:26:53 GMT

The index function may be the easiest for single letters:

proc freq data=yourdata;
    table var;
   where index(var,'A') > 0;
run;

The Index function returns the position, number of character in the string, as an integer if found or zero if not found. The first parameter is what to search and the second parameter is what you search for. This is case sensitive and would not find 'a' when searching for 'A'.

Re: Selecting one unit in a string of units

tarheel13 — Sun, 20 Mar 2022 16:30:11 GMT

you can also use prxmatch