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: 
dmen24
‎02-04-2025
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Capitalize first word after a dash only if there is a dash. Help!

by Fluorite | Level 6 in SAS Viya
‎02-04-2025 10:41 AM
‎02-04-2025 10:41 AM
Hi, I need to capitalize the first letter of the word if there is a dash. So in image above, 'Construction -industrial' should be 'Construction - Industrial'.   Here is my code:  Concatenate(UpCase(Substring('Industry_Desc'n, 1, 1)), LowerCase(Substring('Industry_Desc'n, 2, 1000)))     Can someone help?   Thanks! ... View more

Re: Wrong calculation when calculating difference between dates using ...

by Fluorite | Level 6 in SAS Visual Analytics
‎07-24-2024 01:25 PM
‎07-24-2024 01:25 PM
That was it! Thanks. ... View more

Wrong calculation when calculating difference between dates using Now ...

by Fluorite | Level 6 in SAS Visual Analytics
‎07-24-2024 01:02 PM
‎07-24-2024 01:02 PM
I need to calculate the number of days between today's date (Now operator) and another date (DOI).    I applied Treatas to the DOI and Treatas and DatePart for Now.   I created a variable (FLAG - Past year) based on subracting DOI from Now to get the number of days in between.    Then these are the results. You will see the NOW variable in the list table has different values. It should be the same value. The FLAG - Past year (1)  is the number of days between Now and DOI. The values are incorrect.   What's going wrong?  Suggestions please.      ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-04-2025 02:23 PM
Group Hubs for dmen24
View All
Quick links