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 (750 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 (598 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 Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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