topic Re: Query regarding Cross tab report in SAS Web Report Studio

Query regarding Cross tab report

HashimBasheer — Wed, 14 Jan 2015 09:53:06 GMT

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

Re: Query regarding Cross tab report

ballardw — Wed, 14 Jan 2015 17:01:02 GMT

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

Re: Query regarding Cross tab report

HashimBasheer — Thu, 15 Jan 2015 02:33:03 GMT

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

Re: Query regarding Cross tab report

HashimBasheer — Thu, 15 Jan 2015 02:41:02 GMT

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

Re: Query regarding Cross tab report

ballardw — Thu, 15 Jan 2015 15:13:51 GMT

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.