Traditional web-based reporting with SAS BI tools

Query regarding Cross tab report

Reply
Contributor
Posts: 30

Query regarding Cross tab report

I have a requirement for a report.

The output should be a crosstab report with total 3 columns.

1. Category(loan type,term loan, utlilization etc)

2. Months and yetd value(january14,february14....YTDFy1415)

3. $ amount.

The problem is In the crosstab report, if I give month values as character it wont be sorted in the desired order.How can I get the columns in the corrected order? I cant use the list report for this as the Month values wil get changed on a timely basis. Is there any way if we can get the months sorted in the below order (without adding prefixes)

Month values shud be sorted as below.

Jan - 14

Feb -14

Mar-14

.

.

.

YTDFY1415

Grand Advisor
Posts: 9,748

Re: Query regarding Cross tab report

A generic and across the board pretty powerful approach is to create a SAS date variable and use those with appropriate formats.

Contributor
Posts: 30

Re: Query regarding Cross tab report

thanks for the response. Now I have all the period values in one column, how can I apply the different formats?

Contributor
Posts: 30

Re: Query regarding Cross tab report

thanks for the response. Now I have all the period values in one column, how can I apply the different formats? I tried creatting date variables for the variables and for the ytd columns, I gave some future date so that it comes last in the sequence. But the business would like to see the YTD column as YTD_FY13-14. How wecan achieve this? I tried user defined formats. For some reasons its not getting displayed in the infomaps

Grand Advisor
Posts: 9,748

Re: Query regarding Cross tab report

The method may depend, or be more specific, if you can show how you are generating the crosstab. There are different approaches depending on the procedure used.

Post a Question
Discussion Stats
  • 4 replies
  • 5250 views
  • 0 likes
  • 2 in conversation