topic IF THEN OUTPUT - LIKE Statement in SAS Enterprise Guide

IF THEN OUTPUT - LIKE Statement

Deesee — Tue, 10 Sep 2024 17:18:51 GMT

How do I use 'LIKE' or something similar to find anything that starts
with OCM ? Do I use a WHERE statement or something else?

IF UPCASE(id_role) like 'OCM%'
THEN OUTPUT work.output_ocm;

Re: IF THEN OUTPUT - LIKE Statement

PaigeMiller — Tue, 10 Sep 2024 18:19:11 GMT

IF UPCASE(id_role) =: 'OCM' then OUTPUT work.output_ocm;

Note the colon after the equal sign ... equal followed by colon indicates "starts with" ... that you want to find records where UPCASE(ID_ROLE) starts with 'OCM'

Re: IF THEN OUTPUT - LIKE Statement

Deesee — Tue, 10 Sep 2024 18:30:29 GMT

THANKS!