Date:         Thu, 9 Nov 2006 08:27:33 -0800
Reply-To:     "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject:      Re: checking the dataset
Comments: To: hba2pd <hba2pd@GMAIL.COM>
Content-Type: text/plain; charset="us-ascii"

Hi,

Here is a start, a basic set of what we use often:
    proc contents
    proc freq
    sashelp.vtable
    sashelp.vcolumn
    proc means
    proc summary
etc.

e.g.


    * CONTENTS to Output(Print) window ;
proc contents data=sashelp.class varnum;
run;

    * CONTENTS to Output window and dataset ;
proc contents data=sashelp.class varnum out=xxx;
run;

    * CONTENTS to dataset ;
proc contents data=sashelp.class varnum out=xxx noprint;
run;



    * frequency distribution to Output window ;
proc freq data=sashelp.class;
    table age / list missing;
run;

    * frequency distribution to Output window ;
proc freq data=sashelp.class;
    table sex / list missing;
run;

    * frequency distribution to Output window ;
proc freq data=sashelp.class;
    table sex*age / list missing;
run;

    * frequency distribution to Output window ;
proc freq data=sashelp.class;
    table age / list missing;
    table sex / list missing;
    table sex*age / list missing;
run;

    * frequency distribution to Output window and dataset;
proc freq data=sashelp.class;
    table sex*age / list missing out=yyy;
run;

    * frequency distribution to dataset;
proc freq data=sashelp.class noprint;
    table sex*age / list missing out=yyy;
run;


proc sql;
    create table CurrentDatasetTableStats as
    select *
    from sashelp.vtable
    where libname eq 'SASHELP'
      and memname eq 'CLASS';
quit;

proc sql;
    create table CurrentDatasetColumnStats as
    select *
    from sashelp.vcolumn
    where libname eq 'SASHELP'
      and memname eq 'CLASS';
quit;


proc means data=sashelp.class;
run;




Hope this is helpful.


Mark Terjeson
Senior Programmer Analyst, IM&R
Russell Investment Group


Russell
Global Leaders in Multi-Manager Investing






-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
hba2pd
Sent: Wednesday, November 08, 2006 6:02 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: checking the dataset

Hello,

I understand that sas offers various procedures to check the summary
statistics, missing values, the distribution  of variables of a given
dataset. I am interested in learning what procedures and options you
use.

Best regards,