We have been happily using the transpose in SAS Eg to collapse lines of data - or flatten data in adhoc reports.
ID
Gift
1
$50
1
$40
1
$30
1
$20
2
$50
2
$40
ID
Gift 1
Gift 2
Gift 3
Gift 4
1
$50
$40
$30
$20
2
$50
$40
This works great for adhoc reports. But then, someone asks us to add it to the portal.(Listing of pre-written reports).
The problem is that the number of columns, in this case Gift 1, Gift 2 can change (either go up or down) depending on several things. Let's say they are prompted with fiscal year.
If the original load had Gift 1 - Gift 4, but then say we prompt for the gift year and the data from that year has less data. For example, the transpose only produces Gift 1- Gift 3 , then our "Main" report will bomb because Gift 4 will not be defined.
Do you know of a way to get around this?
... View more