Solved: Re: idea about conditional statement

mona4u · Posted 05-30-2018 11:10 AM

Hi,

I have this dataset and this is the result I desire

Task_Name	Assigned_To	result	count
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Photo Image Preview QC	[email protected]	Photo Image Preview QC
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC			1`
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
irRC RECIST Oncology	[email protected]
Post Pre-Derm QC	[email protected]	Post Pre-Derm QC
Post Review QC 1	[email protected]	Post Review QC 1
Post Review QC 2	[email protected]	Post Review QC 2
Pre-Dermatology	[email protected]	Pre-Dermatology
Radiology Review 1	[email protected]
Radiology Review 2	[email protected]
irRC RECIST Oncology

and I want an idea to get the result I want

If the scan if scan(assigned_to,2,"@")="clinical.com" then result=assigned_to;

I want to create a variable that has the values that associated with the clinical.com email from the variable assigned_to

but also I want to create a variable called count witch count the blanks in the assigned_to variable if the value is in the result variable

Reeza · Posted 05-31-2018 11:35 AM

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.

View solution in original post

mkeintz · Posted 05-30-2018 11:16 AM

Could you

Put the incoming data in the form of a sas data set, and
(really important) show what you want the resulting data set to look like.

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

ballardw · Posted 05-30-2018 11:22 AM

Suggestion would be to cut the example data by maybe half.

Then show the desired result as well, which should be easier with the reduced set.

Reason for showing the desired result is the phrase "has the values that associated with the clinical.com email" is not exactly clear.

Does this mean that you want to do something with the "task_name" variable? Get the user name from such as tcollins from the string [email protected] or something else.

Since each record could only have 1 "blank" what you actually want to count appears to be something else, possibly a summary after this data set is created.

mona4u · Posted 05-30-2018 11:24 AM

I just edited my post.

this is a sample data has only one blank but my real data has more

Reeza · Posted 05-30-2018 11:28 AM

Why not use FIND/INDEX instead of SCAN, since you're searching for a specific string set.

mona4u · Posted 05-30-2018 11:37 AM

This point it doesn't really matter

mona4u · Posted 05-30-2018 12:24 PM

edited it

Reeza · Posted 05-30-2018 12:23 PM

if find('@clincial.com', assigned_to, 'i')>0 then result=task_name;

Isn't that all you need?

mona4u · Posted 05-30-2018 12:55 PM

I don't have a problem with this part
I have a problem with the variable count
I need to create count to count how many blanks are they if the values in the variable result without specifying the values of the variable result each time I run the program

Reeza · Posted 05-30-2018 01:02 PM

IF/THEN/DO.

Adding on to my previous answer, change it to conditional so that you can add the count. You only show one value of 1, so not sure why the rest are blank or if you want them incremented or something. If so, use RETAIN. If you cannot get it working at this point, post your code.

if <condition> then do;

<multiple sas statements>;

count=1;

end;

Please be much more clear in your initial question.

http://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n0el0y2a02ab1ln1pks3gbac1en3.htm&docs...

mona4u · Posted 05-30-2018 01:11 PM

I know if then do
the question is
if then always need to specify a value of the variable to subset
I want to specify the variable that has all those values but without mentioning the values

Reeza · Posted 05-30-2018 02:06 PM

@mona4u wrote:
I know if then do
the question is
if then always need to specify a value of the variable to subset
I want to specify the variable that has all those values but without mentioning the values

I have no idea what that means.

mona4u · Posted 05-30-2018 02:11 PM

I mean usually, we subset this way
if var=a and var1=" " then count
if var in ("a", "b") and var1=" " then count

but the code that I need is
if the value in the var then count without specifying the value of the variable

Reeza · Posted 05-30-2018 02:12 PM

Yeah, still not following. Show me 5 lines of data and exactly what you want as output - as two different data sets.

@mona4u wrote:
I mean usually, we subset this way
if var=a and var1=" " then count
if var in ("a", "b") and var1=" " then count

but the code that I need is
if the value in the var then count without specifying the value of the variable

mona4u · Posted 05-30-2018 02:15 PM

dataset

Task_Name	Assigned_To
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Photo Image Preview QC	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC	[email protected]
Image Preview	[email protected]
Admin QC
Admin QC	[email protected]
Image Preview	[email protected]
irRC RECIST Oncology	[email protected]
Post Pre-Derm QC	[email protected]
Post Review QC 1	[email protected]
Post Review QC 2	[email protected]
Pre-Dermatology	[email protected]
Radiology Review 1	[email protected]
Radiology Review 2	[email protected]
irRC RECIST Oncology

result I desire

Task_Name	Assigned_To	result	count
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Photo Image Preview QC	[email protected]	Photo Image Preview QC
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
Admin QC			1`
Admin QC	[email protected]	Admin QC
Image Preview	[email protected]	Image Preview
irRC RECIST Oncology	[email protected]
Post Pre-Derm QC	[email protected]	Post Pre-Derm QC
Post Review QC 1	[email protected]	Post Review QC 1
Post Review QC 2	[email protected]	Post Review QC 2
Pre-Dermatology	[email protected]	Pre-Dermatology
Radiology Review 1	[email protected]
Radiology Review 2	[email protected]
irRC RECIST Oncology

Call for content now open!

SAS Training: Just a Click Away