Proq freq out

[Thalitacosta]

Como faço para ter a mesma tabela obtida pelo código abaixo em "resultados", exatamente o mesmo, mas nos "dados de saída"?

proc freq/base;
tabela dt*dt_end / out=matriz norow nocol nopercent;
executar;

[StatDave · Accepted solution]

The information from the TABLE statement is in the OUT= data set, but it is just arranged differently. If you want a data set that has the same basic arrangement as in the displayed output, you can create it using PROC TRANSPOSE. The following creates data set MATRIZ2 that is arranged like the displayed output.

proc transpose data=matriz out=matriz2 prefix=dt_end_; 
by dt; id dt_end; var count; 
run;