topic Re: Proc summary in SAS VA in SAS Visual Analytics

Proc summary in SAS VA

Dd07 — Tue, 28 Jun 2016 13:09:00 GMT

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.

Re: Proc summary in SAS VA

LinusH — Wed, 29 Jun 2016 15:03:04 GMT

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.

Re: Proc summary in SAS VA

Dd07 — Thu, 30 Jun 2016 11:34:57 GMT

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

Re: Proc summary in SAS VA

LinusH — Thu, 30 Jun 2016 14:18:05 GMT

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.

Re: Proc summary in SAS VA

Dd07 — Fri, 01 Jul 2016 13:37:34 GMT

Thanks a lot..
Sorry for mess ..