Date:         Thu, 5 Dec 2002 15:20:18 -0800
Reply-To:     "Huang, Ya" <yhuang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Huang, Ya" <yhuang@AMYLIN.COM>
Subject:      Re: Question on reading data and Displaying results in required
              forma              t
Comments: To: Surendranath Gujjala <Surendranath.Gujjala@INGENIX.COM>
Content-Type: text/plain; charset="iso-8859-1"

How about data _null_?

data xx;
infile cards;
input Sales  Units  profit;
cards;
1000    73      200
;

data _null_;
 set xx;
 file print;
 put 'Total Amount of Sales: ' sales /
     'Total Number of Units sold: ' units /
     'Total profit from these units: ' profit;
run;
--------
Total Amount of Sales: 1000
Total Number of Units sold: 73
Total profit from these units: 200

Kind regards,

Ya Huang

-----Original Message-----
From: Surendranath Gujjala [mailto:Surendranath.Gujjala@INGENIX.COM]
Sent: Thursday, December 05, 2002 1:16 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Question on reading data and Displaying results in required
forma t


Hi ,
I have following simple question.
I have a data file(.txt) as:

Sales  Units  profit
1000    73      200

I have to read this file and show the output as follows:

Total Amount of Sales: 1000
Total Number of Units sold: 73
Total profit from these units: 200

I tried options like transpose,array.  I'm unsuccessful yet.
Could you please tell how to create such report when we have labels in the
first line.

Thanks,
Surendra




This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.