topic Balance sheet in SAS Visual analytics in SAS Visual Analytics

Balance sheet in SAS Visual analytics

arefalcharbaji — Fri, 28 Dec 2018 10:20:20 GMT

Hey everyone,

I want to make financial statement in SAS Visual Analytics. But i dont know which object i can use.

I used crosstab but i get the variables in vertical sight, but i want to have it in Horizontal sight. will add a pic descriping an example of what i want to make in SAS Visual Analytics. this is a balance sheet and i also want to make a prfit and los and cashflow statement.

For more information am using SAS Visual Analytics 7.4

Thanks for your help

Re: Balance sheet in SAS Visual analytics

SASKiwi — Fri, 28 Dec 2018 22:24:11 GMT

The only way I think you are going to get the level of customisation you require is to create a SAS stored process perhaps using PROC REPORT to get the layout you want (or any other PROC or DATA step code). The report itself will not be dynamic but you will be able to apply filters to get the slice of data you want.

This link is a starting point to working with stored processes in SAS VA: http://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#p0x3cm87j971dun11jt9al9uquz5.htm