cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10
Go to Solution

idea about conditional statement

Posted 05-30-2018 11:10 AM (940 views)

Hi, 

I have this dataset  and this is the result I desire 

 

Task_NameAssigned_Toresultcount
Admin QCtcollins@clinical.comAdmin QC 
Image Previewvpandya@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewvpandya@clinical.comImage Preview 
Photo Image Preview QCtcollins@clinical.comPhoto Image Preview QC 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QCmarnofsky@wcclinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QC  1`
Admin QCmarnofsky@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
irRC RECIST Oncologyrbht@bidmc.harvard.edu  
Post Pre-Derm QCcwalsh@clinical.comPost Pre-Derm QC 
Post Review QC 1araju@clinical.comPost Review QC 1 
Post Review QC 2araju@clinical.comPost Review QC 2 
Pre-Dermatologycwalsh@clinical.comPre-Dermatology 
Radiology Review 1csado@partners.org  
Radiology Review 2vassah@hotmail.com  
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 

0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-31-2018 11:35 AM (1070 views)  |   In reply to mona4u

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

21 REPLIES 21
mkeintz
PROC Star mkeintz
PROC Star

Re: idea about conditional statement

Posted 05-30-2018 11:16 AM (933 views)  |   In reply to mona4u

Could you

 

  1. Put the incoming data in the form of a sas data set, and
  2. (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

--------------------------
0 Likes
ballardw
Super User ballardw
Super User

Re: idea about conditional statement

Posted 05-30-2018 11:22 AM (928 views)  |   In reply to mona4u

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 tcollins@clinical.com 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
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 11:24 AM (924 views)  |   In reply to ballardw

I just edited my post. 

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

0 Likes
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-30-2018 11:28 AM (921 views)  |   In reply to mona4u

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

mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 11:37 AM (916 views)  |   In reply to Reeza
This point it doesn't really matter
0 Likes
mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 12:24 PM (889 views)  |   In reply to ballardw
edited it
0 Likes
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-30-2018 12:23 PM (891 views)  |   In reply to mona4u

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

 

 

Isn't that all you need?

mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 12:55 PM (884 views)  |   In reply to Reeza
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
0 Likes
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-30-2018 01:02 PM (883 views)  |   In reply to mona4u

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...

0 Likes
mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 01:11 PM (877 views)  |   In reply to Reeza
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
0 Likes
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-30-2018 02:06 PM (874 views)  |   In reply to mona4u
@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
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 02:11 PM (872 views)  |   In reply to Reeza
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
0 Likes
Reeza
Super User Reeza
Super User

Re: idea about conditional statement

Posted 05-30-2018 02:12 PM (869 views)  |   In reply to mona4u

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

 

0 Likes
mona4u
Lapis Lazuli | Level 10 mona4u
Lapis Lazuli | Level 10

Re: idea about conditional statement

Posted 05-30-2018 02:15 PM (867 views)  |   In reply to Reeza

 

dataset 

Task_NameAssigned_To
Admin QCtcollins@clinical.com
Image Previewvpandya@clinical.com
Admin QCtcollins@clinical.com
Image Previewtcollins@clinical.com
Admin QCtcollins@clinical.com
Image Previewvpandya@clinical.com
Photo Image Preview QCtcollins@clinical.com
Admin QCaraju@clinical.com
Image Previewarodriguez@clinical.com
Admin QCtcollins@clinical.com
Image Previewtcollins@clinical.com
Admin QCvpandya@clinical.com
Image Previewtcollins@clinical.com
Admin QCaraju@clinical.com
Image Previewarodriguez@clinical.com
Admin QCmarnofsky@wcclinical.com
Image Previewtcollins@clinical.com
Admin QCvpandya@clinical.com
Image Previewtcollins@clinical.com
Admin QCtcollins@clinical.com
Image Previewtcollins@clinical.com
Admin QCvpandya@clinical.com
Image Previewtcollins@clinical.com
Admin QCaraju@clinical.com
Image Previewarodriguez@clinical.com
Admin QC 
Admin QCmarnofsky@clinical.com
Image Previewtcollins@clinical.com
irRC RECIST Oncologyrbht@bidmc.harvard.edu
Post Pre-Derm QCcwalsh@clinical.com
Post Review QC 1araju@clinical.com
Post Review QC 2araju@clinical.com
Pre-Dermatologycwalsh@clinical.com
Radiology Review 1csado@partners.org
Radiology Review 2vassah@hotmail.com
irRC RECIST Oncology 

 

 

result I desire 

Task_NameAssigned_Toresultcount
Admin QCtcollins@clinical.comAdmin QC 
Image Previewvpandya@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewvpandya@clinical.comImage Preview 
Photo Image Preview QCtcollins@clinical.comPhoto Image Preview QC 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QCmarnofsky@wcclinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCtcollins@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCvpandya@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
Admin QCaraju@clinical.comAdmin QC 
Image Previewarodriguez@clinical.comImage Preview 
Admin QC  1`
Admin QCmarnofsky@clinical.comAdmin QC 
Image Previewtcollins@clinical.comImage Preview 
irRC RECIST Oncologyrbht@bidmc.harvard.edu  
Post Pre-Derm QCcwalsh@clinical.comPost Pre-Derm QC 
Post Review QC 1araju@clinical.comPost Review QC 1 
Post Review QC 2araju@clinical.comPost Review QC 2 
Pre-Dermatologycwalsh@clinical.comPre-Dermatology 
Radiology Review 1csado@partners.org  
Radiology Review 2vassah@hotmail.com  
irRC RECIST Oncology   

 

 

 

 

0 Likes

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 21 replies
  • ‎05-30-2018 11:10 AM
  • 941 views
  • 6 likes
  • 4 in conversation