topic Re: Newbie: How to swap row and columns in list table in Visual Analytics 7.3? in SAS Community Nordic

Newbie: How to swap row and columns in list table in Visual Analytics 7.3?

obertel — Fri, 01 Dec 2017 08:54:17 GMT

I'm struggling with a simple task. Having one category (year/month) and two measures, I want to create a report with year/month in the columns and the two measures in the rows.

Default the list table object looks like this:

Measure1 Measure2

2017-jan 10 20

2017-feb 15 10

2017-mar 11 12

2017-...

The requirement is to swap the rows and columns to get this result:

2017-jan 2017-feb 2017-mar 2017-...

Measure1 10 15 11

Measure2 20 10 12

I have already looked into crosstab but it doesn't seem to give the required result.

I'm using SAS Visual Analytics 7.3.

Any suggestions?

Thanks

/Ole

Re: Newbie: How to swap row and columns in list table in Visual Analytics 7.3?

PeterClemmensen — Fri, 01 Dec 2017 09:15:27 GMT

data have;
input date$ Measure1 Measure2;
datalines; 
2017jan 10 20
2017feb 15 10
2017mar 11 12
;

proc transpose data=have out=want(rename=(_name_=Measure));
	id date;
run;

Re: Newbie: How to swap row and columns in list table in Visual Analytics 7.3?

obertel — Fri, 01 Dec 2017 09:27:58 GMT

Hi draycut

Thanks for your fast reply.

I'm looking for a solution within VA, without SAS programming. Is it possible?

/Ole

Re: Newbie: How to swap row and columns in list table in Visual Analytics 7.3?

PeterClemmensen — Fri, 01 Dec 2017 09:43:06 GMT

Ok. I'm no VA expert, but my best guess is the Pivot By Feature .

If that doesn't work for you, there is a Visual Analytics Community on here where you can post your question or search for related threads 🙂

Re: Newbie: How to swap row and columns in list table in Visual Analytics 7.3?

SteffenBille — Fri, 01 Dec 2017 11:26:45 GMT

Hi Ole.

You are not the first to struggle with this issue, but this cannot be done directly in VA Designer / Explorer 7.3, but it can be done in VA 8.2. See more at https://www.sas.com/va

If you want this, then you need to prepare your data before VA, just like the other answer suggested. Either in SAS og VA data builder.

/ Steffen