Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Sum two fields from different excel sheets

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Sum two fields from different excel sheets

HI All ,

 

Iam Newbiee in SASva so need help

 

I need to Sum 2 field from different excel sheets , iam not able to achive it . Should i do in a Text box or table ? Please help

 

 

Thnaks and Regards

KIran

Cheers


Accepted Solutions
Solution
‎05-19-2017 02:27 AM
Contributor
Posts: 35

Re: Sum two fields from different excel sheets

Posted in reply to KiranPatil

Hi Kiran,

    Best practice is to have your data merged and ready to go before uploading to VA so you can work from a single data source but you should be able to do this with a data query. I searched the forum and found a good post for you to reference, I hope it helps!

 

https://communities.sas.com/t5/SAS-Visual-Analytics/Combining-report-data-sources/td-p/217673

 

View solution in original post


All Replies
Solution
‎05-19-2017 02:27 AM
Contributor
Posts: 35

Re: Sum two fields from different excel sheets

Posted in reply to KiranPatil

Hi Kiran,

    Best practice is to have your data merged and ready to go before uploading to VA so you can work from a single data source but you should be able to do this with a data query. I searched the forum and found a good post for you to reference, I hope it helps!

 

https://communities.sas.com/t5/SAS-Visual-Analytics/Combining-report-data-sources/td-p/217673

 

New Contributor
Posts: 2

Re: Sum two fields from different excel sheets

Thank You Smiley Happy

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 279 views
  • 1 like
  • 2 in conversation