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: 
agoldberg2018
‎09-12-2018
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: strip put works in enterprise guide but not in schedule sas manage...

by Calcite | Level 5 in SAS Enterprise Guide
‎09-12-2018 09:00 AM
‎09-12-2018 09:00 AM
hello i am using SAS Management Console 9.4 to do the scheduling.  I monitor it using Platform Process Manager. Does this help?  Thank you!! ... View more

strip put works in enterprise guide but not in schedule sas management...

by Calcite | Level 5 in SAS Enterprise Guide
‎09-11-2018 05:39 PM
‎09-11-2018 05:39 PM
Hello,   I am able to use the below in a conditional formula within my project in SAS enterprise guide, however, it is not accepted in sas management console upon scheduling.  I use this is enterprise guide to convert a numeric ID to be character (STRIP(PUT(t1.TAAGID,L10.)))   I changed it to (replaced the "L" with "Z") (STRIP(PUT(t1.TAAGID,Z10.))) and it successfully ran in my schedule BUT it produced blanks. So clearly it didn't actually "work" it just didnt fail.   Does anyone have a suggestion of what I can change it to so that management console schedule accepts it?   Thank you ... View more

Re: How to use case statement to group multiple options within one lin...

by Calcite | Level 5 in SAS Enterprise Guide
‎07-18-2018 03:11 PM
‎07-18-2018 03:11 PM
@Reeza    Yes! The -1 one makes the most sense because of people who separate words in the email address like firstname.lastname@abc.com   Thank you again for taking the time to explain this to me! I greatly appreciate the knowledge. ... View more

Re: How to use case statement to group multiple options within one lin...

by Calcite | Level 5 in SAS Enterprise Guide
‎07-18-2018 01:52 PM
‎07-18-2018 01:52 PM
@Reeza can you explain to me what  SCAN(t1.EMAIL_ADDRESS, 2, '.@') means?  It actually didn't work so I am wondering if the .@ is wrong.. is there a link you know of I can reference for a deep explanation of this? Thanks for your help! ... View more

How to use case statement to group multiple options within one line?

by Calcite | Level 5 in SAS Enterprise Guide
‎07-18-2018 09:43 AM
‎07-18-2018 09:43 AM
Is there a more condensed way to write this? I want to know if I can do the "keep" group all in one line instead of needing to duplicate it for each variation of email domain.   CASE WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.COM' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.MIL' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.BIZ' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.NET' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.ORG' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.EDU' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.GOV' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.PRO' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.INFO' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.US' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.CA' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.AERO' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.ARPA' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.ASIA' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.CAT' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.COOP' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.INT' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.JOBS' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.MOBI' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.MUSEUM' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.NAME' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.TEL' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.TRAVEL' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'NULL' and t1.EMAIL_ADDRESS LIKE '%.UM' THEN 'KEEP' WHEN t1.NVL_COUNTRY_GROUP = 'POPULATED_COUNTRY' THEN 'KEEP' ELSE 'REMOVE' END ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-12-2018 10:06 AM
Quick links