| Date: | Tue, 11 Dec 2001 14:39:37 -0500 |
|---|
| Reply-To: | "Kaskey, Larry" <LKaskey@SEISINT.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Kaskey, Larry" <LKaskey@SEISINT.COM> |
|---|
| Subject: | Re: proc FREQ help |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
If all you need is a count of unique values...create a table in Proc SQL
using the distinct statement on ID and check out the log for how many
records were written.
proc sql;
create table work.bigtable_ids
select distinct id
from library.bigtable;
-----Original Message-----
From: Fehd, Ronald J. [mailto:rjf2@CDC.GOV]
Sent: Tuesday, December 11, 2001 2:30 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: proc FREQ help
> From: jsahuqui@WORLDONLINE.ES [mailto:jsahuqui@WORLDONLINE.ES]
> I use SAS 8.2. I have a big Table (about 1000 records). One
> field in the
> table is the ID for the patient. Because of the design of the
> study each
> patient number (i.e. 345678) can be repeated 2- 5 yimes with the same
> variables. This correpsonds to the same patients evaluated at
> differnet
> days in independent tests. I would like to know how can I
> count how many
> unique IDs I have (Proc FREQ ?). Any help would be appreciated.
proc FREQ data = LIBRARY.BigTable;
tables Id
/ noprint
out = IDLIST
(keep = Id);
%LET NMBR_IDS = 0;
%NOBS(NMBR_IDS,data = WORK.IDLIST);
send e-mail with subject: request NOBS
Ron Fehd the macro maven CDC Atlanta GA USA RJF2@cdc.gov
OpSys: Win_Pro Ver: 8.2
---> cheerful provider of UNTESTED SAS code from the KludgeWrx !*! <---
| 
