DATA Step, Macro, Functions and more

PROC TABULATE

Reply
anonymous_user
Posts: 0

PROC TABULATE

[ Edited ]

Hi, 

 

I need my table output to read like this - 

 

01-Jun-15

 

FC

SC

Total

bal_sasout

bal_prov

bal_sasout

bal_prov

bal_sasout

bal_prov

01-Jun-15

           

01-Jul-15

           

01-Aug-15

           

 

This is my code below, any idea how I format it in this way please as the code below produces this output?

 

  SC FC Total Prov
£ £ £
Sum Sum Sum Sum
01AUG2015 22222221.82 222222222.82 222222222.64 222222222.64
01JUL2015 22222222.93 222222222.36 222222222.29 222222222.29
01JUN2015 22222222.76 2222222222.67 222222222.43 2222222222.43

 

 

data work.steve;
set mortbib.mortgagebible_201506;
keep snap acc_status_1 bal_sasout bal_prov;
merge mortbib.mortgagebible_201506 mortbib.mortgagebible_201507 mortbib.mortgagebible_201508;
by mortgage;
where acc_status_1 in ("FC","SC");
run;

 

proc tabulate data=steve missing;
class snap acc_status_1 /preloadfrmt order=data mlf;
var bal_sasout bal_prov;
table (snap=""),
(acc_status_1="" all="Total")*
(bal_sasout="£")
(bal_prov="Prov");
format acc_status_1;
run;

Super User
Posts: 19,851

Re: PROC TABULATE

Posted in reply to anonymous_user

I think it's the following: (untested as no sample data)

 

 

Table snap , acc_status*(bal_sasout*sum='sasout' bal_prov*sum='Prov') all='Total');
Super User
Posts: 5,516

Re: PROC TABULATE

Posted in reply to anonymous_user

I think we're all in the right playground.  I would try:

 

table snap=" ", (acc_status_1=" " all='Total') * (bal_sasout*sum=" " bal_prov*sum=" ");

Super User
Posts: 19,851

Re: PROC TABULATE

Posted in reply to anonymous_user

@brandon16 Did you just edit a post from more than a year ago. Is this even the same question and do you still need an answer?

 

I would suggest creating a new question and linking back to this one, rather than resurfacing an old question. 

 

Editing your post isn't helpful either because then we can't see the history or know what you originally asked. It's better to add it in as a reply. 

Ask a Question
Discussion stats
  • 3 replies
  • 229 views
  • 1 like
  • 3 in conversation