topic transpoing tables and labelling the column variables in SAS Procedures

transpoing tables and labelling the column variables

willy0625 — Tue, 09 Aug 2011 05:32:29 GMT

I have been working with some dataset called test2.

Proc means data=test2;

var gb_bin;

class AGE_GP ENQ_3MTS_GB;

output out=age_3 mean()=;

run;

This is the first few lines of the table generated by the above proc means.

Could anyone please tell me how to transpose this table so that I would obtain a table that looks like

ENQ_3MTS_GB

N obs

Mean

Age_GP

Just to clarify, Age_Gp is a factor with many levels(18-20, 20-22, …) and ENQ_3MTS_GB is a binary variable.

I would like to make sure N obs would show up after I transpose

Many thanks.

art297 — Tue, 09 Aug 2011 06:24:00 GMT

There are a number of ways to accomplish what I think you want. One way might be something like:

data need;

set have;

last_age_gp=lag(age_gp);

if mod(_n_,2) eq 0 then age_gp=last_age_gp;

run;

proc transpose data=need

out=temp1 (drop=_:) prefix=n_obs;

var n_obs;

id enq_3mts_gb;

by age_gp notsorted;

run;

proc transpose data=need

out=temp2 (drop=_:) prefix=mean;

var mean;

id enq_3mts_gb;

by age_gp notsorted;

run;

data want;

set temp1;

set temp2;

run;

Ksharp — Tue, 09 Aug 2011 11:08:47 GMT

You do not give the output.

Also want 1 2 for nobs and mean ...?

nobs_1 nob_2 mean_1 mean_2 ....

Ksharp