BookmarkSubscribeRSS Feed
vishu2
Fluorite | Level 6

Hi everyone. 

 

i want to create a calculated item in SAS VA ;- 

Details:- 

 

RA Applicable = Y if there is an RA record and activity_exists = 'Y'
RA Applicable = N if activity_exists = 'N' or RA record does not exist for that country​

 

Activity_exist has 2 items Y and N 

Thanks in advance.

2 REPLIES 2
Mo_NHS
Fluorite | Level 6
I am using VA 7.3 but should be the same :
1. Once you added the table to the VA report right click on any of the field or menu and select calculated field,
2. A small screen will pop up, type a name for your calculated file and choose the data type,
3. its all drag and drop from here: under the login operator choose "if & else" statement and "And" to build the logic you need.
4. you can drag and drop the fields you want to use in your logic from the fields listed on the left hand side.
Saurabh77
Fluorite | Level 6

hello

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 2419 views
  • 0 likes
  • 3 in conversation