topic Proc transpose and extract the labels in New SAS User

Proc transpose and extract the labels

mona4u — Tue, 18 Dec 2018 17:54:44 GMT

Hi all,

I have this data set which I used proc transpose to flip it but I still not able to get the results that I want because of the Qlabel Values.

I want to get the labels of the variables. I thought about if I use if Qname=".."then Qlabel="..."

but I want to check if I there are shortcuts to get the label names

my data

USUBJID	StID	CRFID	IDVAR	IDVARVAL	QORIG	QEVAL
A3921024 1006 10061050	A3921024 1006	2650261	AESEQ	1	CRF

the result that I am targeting

QNAME	QVAL	QLABEL	IDVAR	IDVARVAL	QORIG	QEVAL
USUBJID	A3921024 1006 10061050	SUBJECT ID	AESEQ	1	CRF
StID	A3921024 1006	Site id	AESEQ	1	CRF
CRFID	2650261	Crf ID	AESEQ	1	CRF

Re: Proc transpose and extract the labels

ballardw — Tue, 18 Dec 2018 18:43:22 GMT

It would help to show the code you are currently using.

On the PROC Transpose statement you can add the option Label= to name a variable to hold the label of transposed variables.

So I would guess that you want to add Label=Qlabel to the transpose code.

Re: Proc transpose and extract the labels

mona4u — Tue, 18 Dec 2018 19:01:12 GMT

I am not sure where to add it to my code!!

proc transpose data=prep_suppae out=trans
name=QNAM;
by USUBJID IDVAR IDVARVAL QORIG ;
var StID CRFID;
run;

Re: Proc transpose and extract the labels

ballardw — Tue, 18 Dec 2018 19:29:37 GMT

proc transpose data=prep_suppae out=trans
name=QNAM label=Qlabel;
by USUBJID IDVAR IDVARVAL QORIG ;
var StID CRFID;
run;

Should have the labels for Stid and CRFid in a variable named Qlabel, IF the variables have a label assigned.

Here is a brief example with other data:

proc sort data=sashelp.class out=work.class;
   by sex age;
run;
proc transpose data=work.class
   name=qname  label=qlabel;
by sex age;
var height weight;
label height='Height at age'
      weight='Weight at age'
;
run;

The Sashelp.class data set does not have any variable labels assigned and hence no value for qlabel without them. Putting a label statement in the transpose code makes them available for the step to demonstrate the result. If only one of the variables has a label only those rows of the output have a value for qlabel.

If you are wanting labels for other variables we'll need more information and possibly example data.