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 (November 2006, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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,


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