topic Re: Length of variables in Proc Summary output out statement in SAS Procedures

Length of variables in Proc Summary output out statement

johngds — Thu, 12 Mar 2020 21:00:33 GMT

In Proc Summary, is there any way to set the length of variables in the output out statement? I'm trying to avoid having to write a separate data step to set the variable lengths.

Re: Length of variables in Proc Summary output out statement

Kurt_Bremser — Thu, 12 Mar 2020 22:08:34 GMT

What do you want to gain by it? It is best to let the numeric variables keep the default maximum length of 8 (because of precision).

Re: Length of variables in Proc Summary output out statement

johngds — Fri, 13 Mar 2020 14:23:00 GMT

Setting variable lengths will enable me to cut the size of the file down from 4.5 GB to about 2.5 GB. I'll still be able to maintain precision.

@Kurt_Bremser wrote:
What do you want to gain by it? It is best to let the numeric variables keep the default maximum length of 8 (because of precision).

Re: Length of variables in Proc Summary output out statement

FreelanceReinh — Sat, 14 Mar 2020 23:15:57 GMT

Hi @johngds,

You can use the KEEPLEN option of the OUTPUT statement of PROC SUMMARY to let the statistics inherit the lengths of the analysis variables. If this is not applicable to your analysis dataset (because the variables in question have full length there), you can apply it to a DATA step view quickly created from the dataset using an appropriate LENGTH statement. (Edit: You may want to set the VARLENCHK= system option to NOWARN in this case.)

Re: Length of variables in Proc Summary output out statement

Kurt_Bremser — Sun, 15 Mar 2020 12:48:28 GMT

You might be better off implementing your stats in a data step in the first place. Could you show the code for the summary procedure?

Re: Length of variables in Proc Summary output out statement

Tom — Sun, 15 Mar 2020 19:43:50 GMT

@johngds wrote:

Setting variable lengths will enable me to cut the size of the file down from 4.5 GB to about 2.5 GB. I'll still be able to maintain precision.

@Kurt_Bremser wrote:

What do you want to gain by it? It is best to let the numeric variables keep the default maximum length of 8 (because of precision).

Is that with or without compression?

Re: Length of variables in Proc Summary output out statement

Tom — Sun, 15 Mar 2020 23:16:51 GMT

@johngds wrote:

In Proc Summary, is there any way to set the length of variables in the output out statement? I'm trying to avoid having to write a separate data step to set the variable lengths.

Which variables? What statistics are you generating? It might make sense to truncate the storage of integer values, but the mean, standard deviation and variance of integer is going to be a floating point value. Those variables you won't want to truncate the storage.

Re: Length of variables in Proc Summary output out statement

johngds — Mon, 16 Mar 2020 12:31:29 GMT

Thanks to all who responded. I was not aware of the KEEPLEN option for the OUTPUT OUT= statement. Clean and easy, and it saves an additional data step. The variable I am limiting the length to 4 is an integer and takes a value between 0 and 20,000.