|
On Thu, 19 Oct 2006 08:23:45 -0700, phillyj <jessica.donato@GMAIL.COM> wrote:
>Hi everyone:
>
>Im trying to use a wild card to select all observations with the
>specified letters in them. For example my code is:
>
>Data SurgeryPrim;
>Set PSurgery;
>if DrugProcSite in ("Mast%", "modified%", "mrm%", "mat%", "quad%") then
> v009=1; else v009=2;
>run;
>
>This code is not working though. Any suggestions for what i did wrong?
> I also tried to remove the & and keep only quotes.
>
>Thanks for your help!
Jessica,
The '%' and '_' wildcards are used in conjuction with the LIKE operator,
which is not a valid operator in IF(-THEN-ELSE) statements.
HTH,
Ken
|
