02-07-2014 06:26 PM
I have a dataset with this layout.
PROVIDER MEMBER AMOUNT
provider1 memberA 1000
provider2 memberA 100
provider1 memberB 10000
provider3 memberB 10
provider4 memberC 100000
provider4 memberD 100
How do I reshape to create a report like the one below?
PROVIDER memberA memberB memberC memberD
provider1 1000 10000
provider4 100000 100
02-12-2014 05:47 PM
Thank you for the replies.
I got the error below when I ran the code though.
1336 Proc tabulate missing data=task format= 6.0 ;
1338 Class provider member ;
1340 var amount ;
1342 Table provider, member=' '*sum= ' ' / rts=10 misstext=' ';
1344 Run ;
ERROR: Statistic other than N was requested without analysis variable in the following nesting
: PROVIDER * MEMBER * Sum.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Need further help from the community? Please ask a new question.