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
krnkva
Calcite | Level 5 krnkva
Calcite | Level 5

Calculated Measure - If Else

Posted 06-06-2024 08:46 AM (562 views)

Hi, I would like to know how I can solve this error? Thanks.

image.png

0 Likes
Reply
1 REPLY 1
Stu_SAS
SAS Employee Stu_SAS
SAS Employee

Re: Calculated Measure - If Else

Posted 06-10-2024 01:00 PM (410 views)  |   In reply to krnkva

Hey @krnkva! You cannot return characters with aggregated functions, but you can return numbers. In your case, you can use a binary 1/0 indicator for repeated customers. For example:

 

Stu_SAS_2-1718038772434.png

Follow me on LinkedIn for SAS tips with #SASTipTuesday
Check out my GitHub for SAS tips and tricks
0 Likes
Reply

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Watch Tips for filtering data sources in SAS Visual Analytics on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎06-06-2024 08:46 AM
  • 563 views
  • 0 likes
  • 2 in conversation