PROC summary with preloadfmt option truncates char variables

PavelD — Wed, 15 Mar 2023 08:48:52 GMT

hello

code:

data data_in;
    length Name $10;
    /* without the line above, Name has length 8 */

    set sashelp.class;
    /* Name has length 10 - as expected */

run;


proc format ;
    value $Name (multilabel)
    "Alfred" = "Alfred"
    "Alice" = "Alice"
    "Alice" = "Aggr"
    "Alfred" = "Aggr"
    other = "other"
    
;
run;

proc summary nway data = data_in completetypes;
	class Name / preloadfmt mlf;
	var Weight;

    format Name $Name.;
	
	output  out = data_out  ( DROP = _TYPE_ _FREQ_)   sum =  ;
    /* in data_out, Name has length 6, and NOT 10 ! */
run;

in data_in, Name has length 10. In data_out, Name has length 6.

Is there a way to force proc summary to MAINTAIN the length of the class variable?

thx

Re: PROC summary with preloadfmt option truncates char variables

Kurt_Bremser — Wed, 15 Mar 2023 09:02:49 GMT

Create the format with a default length of 10.

DEFAULT= option

Re: PROC summary with preloadfmt option truncates char variables

PavelD — Wed, 15 Mar 2023 10:10:41 GMT

Fantastic, thanks Kurt. I missed that option.

topic Re: PROC summary with preloadfmt option truncates char variables in SAS Programming

PROC summary with preloadfmt option truncates char variables

Re: PROC summary with preloadfmt option truncates char variables

Re: PROC summary with preloadfmt option truncates char variables