topic Operators in SAS Procedures

Operators

robertrao — Fri, 07 Jun 2013 20:25:52 GMT

where category variable has :

out

middle

Are these both notations correct to select all the value starting with in???
if category eq: "in" then....

if category eq "in:" then....

Thanks

Tom — Fri, 07 Jun 2013 20:41:17 GMT

The colon is a modifier on the comparison operator, not on the value.

if category eq: "in" then ...

If you are using WHERE instead of IF then you could use LIKE operator:

where category like 'in%' ;

robertrao — Fri, 07 Jun 2013 21:01:25 GMT

i was confused because we use colon operator beisde variable name to pick the variable names starting with the specified

if we have variables var1 to var50

we can just write for example( keep =var:)

how is this:

if category eq: "in" then ... different from the above????

Cynthia_sas — Fri, 07 Jun 2013 23:10:30 GMT

Hi,

Or, you can write a program to prove to yourself how the different syntax elements would work.

cynthia

data colon_mod;

infile datalines;

input string $;

test1 = 'n';

test2 = 'n';

test3 = 'n';

if string =: 'in' then test1 = 'y';

if string = 'in' then test2 = 'y';

if string = 'in:' then test3 = 'y';

return;

datalines;

inert

input

inagadda

nothing

;

run;

ods listing;

proc print data=colon_mod;

run;