idea about conditional statement

[Reeza]

Why isn't the last record included in the count?

[mona4u]

I only count the blanks in assigned_to
if the value of task was in the result
"irRC RECIST Oncology" is not one of the variable result's values

[Reeza]

if the value of task was in the result

How is this identified? Do you have a list somewhere that identifies what's valid and what's not? 

[mona4u]

I don't have a list
the idea is I should include whatever is task_name if the email has "clinical.com"
I want the program to be able to create a list automatically and then
check the blanks assigned_to if anything of the list is there

[Reeza · Accepted solution]

Create your list then first:

proc sql noprint;
select distinct quote(task_name) into :task_list separated by ", "
from have
where email like '%@clinical.com';
quit;
%put &task_list;

If the macro variable is  too long you'll need a different approach.

[mona4u]

So The only way to do is by proc sql. 

I thought there is a better way by the data step 

THANKS SO MUCH 

[Reeza]

---

@mona4u wrote:

So The only way to do is by proc sql. 

I thought there is a better way by the data step 

THANKS SO MUCH 

---

It can probably be done in a data step as well, it would be a bit more code though. I thought the SQL  would be easier is all, for combining things across groups  it often is.