topic Re: Records Count in ODS and Base Reporting

Records Count

deleted_user — Mon, 25 Jun 2007 11:49:11 GMT

Is there in SAS function to return records count of the table?

Re: Records Count

deleted_user — Mon, 25 Jun 2007 12:09:59 GMT

Data X;
A=1;
;
Run;

Proc SQL;
Create table COUNT as select * from dictionary.tables
Where Libname='WORK' and memname='X';
Quit;

Re: Records Count

deleted_user — Mon, 25 Jun 2007 12:16:26 GMT

Thanks.

If I want only distinct records (by Field1), I must execute 2 queries?

create table test as (
select distinct Field1, Field2, Field3 from Table1
);

and after

select count(*) into: COUNT from test;

Or I can do it in one step?

Re: Records Count

deleted_user — Mon, 25 Jun 2007 12:30:14 GMT

Sorry for stupid question

the solution is

select count(Field1) as COUNT, Field2, Field3 from Table1

Am I right?

Re: Records Count

deleted_user — Tue, 26 Jun 2007 07:49:36 GMT

I think you need something like this:

proc sql;
create table NEW_TABLE as
select Field1, Field2, Field3
count(Field3) as COUNT3,
count(Field2) as Count2,
count(distinct Field1) as Count1_DISTINCT
from YOUR_TABLE;
quit;