Date: Thu, 23 Dec 2004 13:16:41 -0500
Reply-To: "Bosch, Jules" <jules.bosch@SPCORP.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Bosch, Jules" <jules.bosch@SPCORP.COM>
Subject: Re: PROC REPORT
Content-Type: text/plain
Thank you very much. I did two things here. First I eliminated all
duplicate records from the data set. Then, most importantly, I added the
MISSING option to the PROC REPORT stmt. And, bada-bing, it worked!
Time is of the essence here so the timely response of everyone is sincerely
appreciated.
Jules
-----Original Message-----
From: Jack Hamilton [mailto:JackHamilton@FIRSTHEALTH.COM]
Sent: Thursday, December 23, 2004 12:59 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: PROC REPORT
I sometimes forget about that one - typing MISSING in procs REPORT,
SUMMARY, and TABULATE is so automatic for me - I think it's worked its
way into my reflexes - that it doesn't occur to me that there are people
who don't do it.
--
JackHamilton@FirstHealth.com
Manager, Technical Development
Metrics Department, First Health
West Sacramento, California USA
Coelum, non animum mutant, qui trans mare currunt.
>>> "Dennis Diskin" <diskin@SNET.NET> 12/23/2004 9:53 AM >>>
In addition, if you have any ORDER or GROUP variables with missing
values, they will not appear unless you use the MISSING option on the
proc statement.
Regards,
Dennis Diskin
Jack Hamilton <JackHamilton@FIRSTHEALTH.COM> wrote:
Without seeing the code it's difficul to say, but possibly it's
summarizing some records for you. Do you have any GROUP variables? Do
you have any numeric variables whose usage is not specified as
DISPLAY?
--
JackHamilton@FirstHealth.com
Manager, Technical Development
Metrics Department, First Health
West Sacramento, California USA
Coelum, non animum mutant, qui trans mare currunt.
>>> "Bosch, Jules" 12/23/2004 9:33 AM >>>
Can anyone guess why PROC REPORT would print only 10 records (one
page's
worth) from a 43-record SAS data set? The OBS option is set to MAX and
the
SASlog says "There were 43 observations read..." Any suggestions would
be
greatly appreciated at this late date.
Jules Bosch
*********************************************************************
This message and any attachments are solely for the intended
recipient.
If you are not the intended recipient, disclosure, copying, use or
distribution of the information included in this message is prohibited
-- Please immediately and permanently delete.
"MMS " made the following annotations.
----------------------------------------------------------------------------
--
This message, including any attachments, is intended solely for the
use
of the named recipient(s) and may contain confidential and/or
privileged information. Any unauthorized review, use, disclosure or
distribution of this communication(s) is expressly prohibited.
If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
Thank you.
===========================================================================
==
*********************************************************************
This message and any attachments are solely for the intended recipient. If you are not the intended recipient, disclosure, copying, use or distribution of the information included in this message is prohibited -- Please immediately and permanently delete.