topic Re: Pivot By Function in SAS Visual Analytics

Pivot By Function

killiangavin — Wed, 03 Jul 2019 09:48:47 GMT

Hi all,

Is the pivot by feature in SAS Va version 7.3?

Thank you,

Killian

Re: Pivot By Function

koyelghosh — Wed, 03 Jul 2019 10:07:17 GMT

An appropriate use of PROC REPORT/TABULATE/MEANS should do the job, if pivot by means Pivot tables as obtained in Excel ... else please share some example data and expected output

Re: Pivot By Function

killiangavin — Wed, 03 Jul 2019 10:16:08 GMT

Hi,

Thanks for your reply. I'm looking to transpose a table and have the measures and catergories swapped. I've attached an example of the table I have. My aim is to swap what is on the veritcal and horizontal axis'.

Any help would be appreciated.

Killian

Re: Pivot By Function

koyelghosh — Wed, 03 Jul 2019 13:05:27 GMT

@killiangavin I am sorry but I don't see any example data

Re: Pivot By Function

Madelyn_SAS — Wed, 03 Jul 2019 13:22:42 GMT

In 7.3, measures are always on columns in crosstabs. You cannot place measures on rows (unless they are being used as categories).

In the current release (8.3.1) on SAS Viya you can place measures on the rows with a Placement option.