Date:         Wed, 2 Feb 2000 10:48:33 +0100
Reply-To:     F a b r i z i o <Fabrizio1@USA.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         F a b r i z i o <Fabrizio1@USA.NET>
Organization: KLM Royal Dutch Airlines
Subject:      Re: delete many variables

Gehard Hellriegel wrote in message <41256878.00587937.00@data.WestLB.de>...
>I see no other chance than to read the whole dataset in one step to find ot
the
>zero-variables. Comfortable but not the fastest is PROC SUMMARY:
>
>%let yourdata=YOUR.DATA;
>proc summary data=&yourdata;
>var c1 c2 c3 c4 c5 ......;  /* list all your numeric variables c1-c?? */
>output out=test(drop=_type_ _freq_) sum=;
>run;


This is a dangerous one if your data might contain negative
values. Consider you have values -3, -1 and +4 in one col,
then your PROC SUMMARY will add up to zero, but the
column does not just contain zeroes.

You might want to calculate moth the MIN=, MAX=, and NMISS=.

Brgds; Fabrizio