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 (814 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 (662 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
Read my blog for cool SAS and open source data science projects
0 Likes
Reply

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 815 views
  • 0 likes
  • 2 in conversation