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% 
         

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

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
  • 1132 views
  • 0 likes
  • 1 in conversation