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 (906 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 (754 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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—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
  • 907 views
  • 0 likes
  • 2 in conversation