BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Aman4SAS
Obsidian | Level 7

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????????????

1 ACCEPTED SOLUTION

Accepted Solutions
DR_Majeti
Quartz | Level 8

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.

View solution in original post

4 REPLIES 4
DR_Majeti
Quartz | Level 8

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.

Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag
Aman4SAS
Obsidian | Level 7

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;

Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 803 views
  • 1 like
  • 3 in conversation