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

Proc summary in SAS VA

Reply
Contributor
Posts: 35

Proc summary in SAS VA

Hello All ,

 

I am looking for proc Summary kind of feature in SAS VA.

 

I can create report in Cross table however i require the data should be in proc summary classified by category variable.

So Please suggest can i use cross table as datasource or use proc summary type featire to architecture.

Esteemed Advisor
Posts: 5,100

Re: Proc summary in SAS VA

Do you need a report with all corresponding _type_?
Doesn't sound like an end user report so I would sugest that you use - proc summary for this.
If you want it published anyway in VA use a stored process.
Data never sleeps
Contributor
Posts: 35

Re: Proc summary in SAS VA

Thanks for responding.

My data is listed in below format.
History Geography Science
Marks 50 60 70

However I want my datasource should be in below format

Subject Marks
History 50
Geography 60
Science 70
Because I want to plot waterfall chart using the desired data format I believe we can not assign multiple category variavle in waterfall chart.

Please do suggest
Esteemed Advisor
Posts: 5,100

Re: Proc summary in SAS VA

Oh, you want to transpose your data. And transposing to long is a good thing - VA and many other reporting tools works best with normalized data.
I don't think that there's any easy/good way to this in VA so i sugest that you take care if this in Base SAS prior to loading to LASR.
Data never sleeps
Contributor
Posts: 35

Re: Proc summary in SAS VA

Thanks a lot..
Sorry for mess ..
Post a Question
Discussion Stats
  • 4 replies
  • 243 views
  • 0 likes
  • 2 in conversation