topic Re: Automatic Sum data in SAS Procedures

Automatic Sum data

fred_major — Fri, 08 Aug 2014 15:17:06 GMT

Hi,

The table that I am working with contains over 600 metrics that I need to summarize and perform analysis on.

Without manually typing Sum(******)as ****** can this be performed keeping the metric names in source table?

Fred

Re: Automatic Sum data

data_null__ — Fri, 08 Aug 2014 15:28:30 GMT

PROC MEANS

Re: Automatic Sum data

Reeza — Fri, 08 Aug 2014 15:28:55 GMT

Yes, use proc means or proc summary NOT proc SQL.

data have;

array test(100) test1-test100;

do i=1 to 1000;

do j=1 to 100;

test(j)=rand('normal');

end;

output;

end;

drop i j;

run;

proc means data=have noprint;

var test1-test100;

output out=want sum=;

run;

Re: Automatic Sum data

data_null__ — Fri, 08 Aug 2014 15:50:49 GMT

You can even omit the VAR statement to make it "more automatic".

proc means data=have noprint; 
   output out=want sum=;
   run;

Re: Automatic Sum data

Reeza — Fri, 08 Aug 2014 15:59:27 GMT

That will include all numeric variables by default.

A lot of our identifiers facility/patient are numeric so I usually want to exclude them from summaries

Re: Automatic Sum data

data_null__ — Fri, 08 Aug 2014 16:46:48 GMT

I think for the most part identifiers "patient numbers" should be character.

Also for the OP with 600 metrics he may be more inclined to ignore a few sums or drop a few variables with a data set option. Also depends on what kind of "SAS Variable Lists" the OP can use, he did not mention the var names.

Re: Automatic Sum data

fred_major — Fri, 08 Aug 2014 17:37:38 GMT

Hi,

I tried this

Proc Means noprint data = results (where =(date >= 2014-08-01 and date = 2014-08-07));

CLASS date;

output out=BM SUM=;

RUN;

I Get

ERROR: A bug in SAS has been encountered. please call your sas rep and report the following.

Error: zaqlopt - option 1003 not supported fro data set

Re: Automatic Sum data

data_null__ — Fri, 08 Aug 2014 17:45:22 GMT

date constants in SAS are written 'ddMONyyyy'd where MON is three char abbreviation for month.

Re: Automatic Sum data

PGStats — Fri, 08 Aug 2014 17:52:38 GMT

I have to guess what you really meant in your where condition ... but try this instead:

Proc Means noprint data = results (where =(date >= '01AUG2014'd and date <= '07AUG2014'd));

CLASS date;

output out=BM SUM=;

RUN;

Re: Automatic Sum data

fred_major — Fri, 08 Aug 2014 18:07:36 GMT

Hi,

I am still getting the Error: A bug in Sas but the proc means is working.

Thanks you for your help.

Fred