Pivot By Function

[killiangavin]

Hi all,

Is the pivot by feature in SAS Va version 7.3? 

Thank you,

Killian 

[koyelghosh]

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

[killiangavin]

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 

[koyelghosh]

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

[Madelyn_SAS]

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.