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 (1284 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 (1132 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

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand in the Innovate Hub.

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