topic Proc Report in SAS Procedures

Proc Report

Aman4SAS — Sun, 29 Sep 2013 09:59:15 GMT

proc import datafile="~bank.xls" out= bank dbms=excel replace;

getnames=yes;

run;

proc report data=bank nowd;

column accttype branch amount,sum;

define accttype/group;

define branch/across;

define amount /sum;

run;

OUTPUT:

18:48 Wednesday, September 28, 2011 34

Branch Amount

AcctType Central North County Westside sum

CD 97 60 54 3145845

Checking 158 61 59 1487914

IRA 8 15 5 212754

Savings 99 61 35 1689259

Is it possible to see amount in place of no of records ie. 34000 or (whatever sum is) in place of 97 , 60 54 or all????????????

Re: Proc Report

DR_Majeti — Sun, 29 Sep 2013 11:56:12 GMT

Hi Aman,

I think this code might help you.. please change the data set name as per your records..

proc report data=bank nowd;
column acctype (branch,amount);
define acctype / group;
define branch / across;
define amount / sum ;
run;

Durga.

Re: Proc Report

Jagadishkatam — Sun, 29 Sep 2013 13:31:08 GMT

You can get the output you want with proc tabulate procedure as well, here is the code for that

proc tabulate data=bank;

class accttype branch;

var amount;

tables (amount)*sum, accttype,branch all="Amount sum";

run;

Thanks,

Jagadish

Re: Proc Report

Aman4SAS — Mon, 30 Sep 2013 07:33:24 GMT

Thanks for your kind help.

i would like to share my effort with you please suggest me and please any one can help me to know what is the use of 'nofs' ?

proc report data=bank nowd ;

column accttype branch,amount amount;

define accttype/group;

define branch/across;

define amount /analysis sum;

compute after;

Accttype="Total:";

endcomp;

rbreak after / dol dul summarize;

run;

Re: Proc Report

Jagadishkatam — Mon, 30 Sep 2013 10:52:10 GMT

The options nofs and nowd are both same. By using these option we are preventing the proc report directing the output to report window. The output is displayed in the normal output window instead of report window.

The default if we are not mentioning any option is proc report will send the output to report window.

Thanks,

Jagadish