Hi
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
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;
Hi draycut
Thanks for your fast reply.
I'm looking for a solution within VA, without SAS programming. Is it possible?
/Ole
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 🙂
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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!