PROC TABULATE question
in [SAS]
|
From: greg6363 on 29 Apr 2010 14:11 I am summarizing data with the following code: proc tabulate data=tdrpull_a; class bookdate vintage bucket; var Current_Balance; table (bookdate=""), (vintage="" all="Total")*(Bucket="" all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20.) (rowpctsum="%"*f=pctfmt9.2))/misstext='0' printmiss rts=20 box='TDR'; run; It is working fine. Now I want to remove the rowpctsum and perform a count of the account numbers associated with the balance used for the var. I'm having trouble adding this new dimension. Any assistance would be greatly appreciated. Thanks.
From: bigD on 29 Apr 2010 14:42 On Apr 29, 2:11 pm, greg6363 <gregtlaugh...(a)gmail.com> wrote: > I am summarizing data with the following code: > > proc tabulate data=tdrpull_a; > class bookdate vintage bucket; > var Current_Balance; > table (bookdate=""), > (vintage="" all="Total")*(Bucket="" > all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20.) > (rowpctsum="%"*f=pctfmt9.2))/misstext='0' printmiss rts=20 box='TDR'; > run; > > It is working fine. Now I want to remove the rowpctsum and perform a > count of the account numbers associated with the balance used for the > var. I'm having trouble adding this new dimension. Any assistance > would be greatly appreciated. Thanks. Does this do it? proc tabulate data=tdrpull_a; class bookdate vintage bucket; var Current_Balance; table (bookdate=""), (vintage="" all="Total")*(Bucket="" all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20. n="# accts="%"*f=comma12.02))/misstext='0' printmiss rts=20 box='TDR'; run;
From: greg6363 on 29 Apr 2010 15:32 On Apr 29, 2:42 pm, bigD <diaphanos...(a)gmail.com> wrote: > On Apr 29, 2:11 pm, greg6363 <gregtlaugh...(a)gmail.com> wrote: > > > I am summarizing data with the following code: > > > proc tabulate data=tdrpull_a; > > class bookdate vintage bucket; > > var Current_Balance; > > table (bookdate=""), > > (vintage="" all="Total")*(Bucket="" > > all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20.) > > (rowpctsum="%"*f=pctfmt9.2))/misstext='0' printmiss rts=20 box='TDR'; > > run; > > > It is working fine. Now I want to remove the rowpctsum and perform a > > count of the account numbers associated with the balance used for the > > var. I'm having trouble adding this new dimension. Any assistance > > would be greatly appreciated. Thanks. > > Does this do it? > > proc tabulate data=tdrpull_a; > class bookdate vintage bucket; > var Current_Balance; > table (bookdate=""), > (vintage="" all="Total")*(Bucket="" > all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20. > n="# accts="%"*f=comma12.02))/misstext='0' printmiss rts=20 box='TDR'; > run; I want to have a count of the account numbers associated with the current_balance variable. Why would I want to include a percentage (%)?
From: greg6363 on 29 Apr 2010 15:36 On Apr 29, 2:42 pm, bigD <diaphanos...(a)gmail.com> wrote: > On Apr 29, 2:11 pm, greg6363 <gregtlaugh...(a)gmail.com> wrote: > > > I am summarizing data with the following code: > > > proc tabulate data=tdrpull_a; > > class bookdate vintage bucket; > > var Current_Balance; > > table (bookdate=""), > > (vintage="" all="Total")*(Bucket="" > > all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20.) > > (rowpctsum="%"*f=pctfmt9.2))/misstext='0' printmiss rts=20 box='TDR'; > > run; > > > It is working fine. Now I want to remove the rowpctsum and perform a > > count of the account numbers associated with the balance used for the > > var. I'm having trouble adding this new dimension. Any assistance > > would be greatly appreciated. Thanks. > > Does this do it? > > proc tabulate data=tdrpull_a; > class bookdate vintage bucket; > var Current_Balance; > table (bookdate=""), > (vintage="" all="Total")*(Bucket="" > all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20. > n="# accts="%"*f=comma12.02))/misstext='0' printmiss rts=20 box='TDR'; > run; I just made the following adjustment: proc tabulate data=tdrpull_a; class bookdate vintage bucket; var Current_Balance; table (bookdate=""), (vintage="" all="Total")*(Bucket="" all="Total")*(Current_Balance="")*((sum="Bal$"*f=comma20. n="#"*f=comma12.02))/misstext='0' printmiss rts=20 box='TDR'; run; And it worked. Thanks so much, bigD.
|
Pages: 1 Prev: sas - Complex plz help Next: How to create a SAS instalator program for SAS application? |