topic Re: Dynamic Column header in SAS Visual Analytics

Dynamic Column header

Niz — Thu, 28 May 2015 23:27:07 GMT

Hi Guys,

I was just wondering whether I can have dynamic column header for SAS VA report.

For eg:

If I run a report in Jan my report will look like

	Actuals	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected
Numbers in 000's	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

Total Claims	4000	-	-	-	-	-	-	-	-	-	-	-
# of Accepted	6790	679-	23	90	69.0	269	29.9	2	27	21	27	20.9
% Accpted	90.6%	90.6%	90.6%	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a

And if run in Feb then the Feb column header has to change

	Actuals	Actual	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected	Projected
Numbers in 00000's	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

Total Claims	3467	-	-	-	-	-	-	-	-	-	-	-
# of Accepted	356	3	31	26	26.0	26	26.9	2.8	270.3	20.1	27	279
% Active	90.6%	90.6%	90.6%	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a	n/a

Re: Dynamic Column header

avvy — Mon, 08 Jun 2015 12:45:14 GMT

Hi Niz,

To attain the obove requirement, you have to create a calculated Item and them custom category on calculated item.

1. Create a calculated Item:-

IF ( Month(Time) > Month(DatePart(Now())) )

RETURN 1

ELSE 0

where "Time" is the date measure. Let us say the name of this calculated item is "Calculated Item (1)"

2. Create a Custom Category based on the calculated Item that we have created above "Calculated Item (1)", let us name it "Custom Category 1" :-

Create label "Actual" with value of "0.00" and "Projected" with value of "1.00".

Now you can use the created "Custom Category 1" in crosstab as column role to attain the required report.

Hope this helps you.

Regards,

Abhishek

Re: Dynamic Column header

Niz — Thu, 11 Jun 2015 18:16:09 GMT

Hi Abhishek,

Thanks for your response.But what I was looking to change the column header label.

I will have measure for each month (12 column for each month) and till current month coulmn I want to have an Actual and for upcoming month measure should have the projected

Tha

Re: Dynamic Column header

avvy — Fri, 12 Jun 2015 06:03:06 GMT

Hi Niz,

I think so it is possible to attain the above requirement once you make all these 12 measures(months) into one category may be named as "Months" which can be achived at the stage of data preparation.

Thanks

Abhishek