topic Re: Case When in SAS Programming

Case When

CTT53 — Fri, 01 Jun 2018 15:42:55 GMT

I am trying to add a "Case When" statement to my table with contains. I have 2 stings that are alike and it calculates both. How do I distinguish

1) Review and Discussion

2) Review and Discussion Client

Thanks

Re: Case When

Amir — Fri, 01 Jun 2018 15:54:26 GMT

Hi,

Can you avoid using the contains operator and use the eq (equals) operator instead for the first case?

Regards,

Amir.

Re: Case When

CTT53 — Fri, 01 Jun 2018 16:44:20 GMT

I tried that however I am trying to count the occurrence of each time it appear. There are approx. 40 other descriptions that in the row.

Re: Case When

Amir — Fri, 01 Jun 2018 16:52:09 GMT

Hi,

I think it would be useful if you shared your code (or a sample we can run) with some data in the form of a data step with datalines that we can also run to create the data.

Would the count function help?:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002260230.htm

Regards,

Amir.

Re: Case When

SuryaKiran — Fri, 01 Jun 2018 18:30:31 GMT

Simply igore the one you don't want to count

Find(var,"Review and Discussion",'i')>0 and Find(var,"Review and Discussion Client",'i')=0 then Count+1;