BookmarkSubscribeRSS Feed
mmudasir
Fluorite | Level 6

I want to Publish a Report thru SAS Web Report Portal for  below given data

 

SnoDescriptionPartAmountDates   
1AppleAchieved120031-Mar-2022
2CarrotAchieved2950031-Mar-2022
3FishAchieved3001031-Mar-2022
4MeatAchieved5490831-Mar-2022
5GrappesAchieved3456031-Mar-2022
1AppleAchieved180017-Jun-2022
2CarrotAchieved3320017-Jun-2022
3FishAchieved2504017-Jun-2022
4MeatAchieved4790817-Jun-2022
5GrappesAchieved3659017-Jun-2022
1AppleTarget184030-Jun-2022
2CarrotTarget3350030-Jun-2022
3FishTarget2804030-Jun-2022
4MeatTarget5090830-Jun-2022
5GrappesTarget4059030-Jun-2022

 

the REPORT has to be like this with additional calculated Field

      Calculated Fields 
   AchievedTarget   
 S NoDescription31-Mar-202217-Jun-202230-Jun-2022Shortfall/Excess %age Against TargetShortfall/Excess %age Against March 2022 
 1Apple1200180018402.22%50.00% 
 2Carrot2950033200335000.90%12.54% 
 3Fish30010250402804011.98%-16.56% 
 4Meat5490847908509086.26%-12.75% 
 5Grappes34560365904059010.93%5.87% 
         

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

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 0 replies
  • 1721 views
  • 0 likes
  • 1 in conversation