LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments: To: Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
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.


Back to: Top of message | Previous page | Main SAS-L page