Thanks to ALL who responded to my question. The answer (as you stated) is: To transpose a character variable you MUST use a VAR statement with PROC TRANSPOSE. Thanks again and have a great weekend.

abdu

> -----MY Original Message----- > From: abdu.elnagheeb(a)nationsbank.com > [SMTP:abdu.elnagheeb@NATIONSBANK.COM] > Sent: Thursday, July 16, 1998 5:24 PM > To: SAS-L@UGA.CC.UGA.EDU > Subject: proc TRANSPOSE > > Hello all, > Is PROC TRANSPOSE limited only to numeric variables? I ran the > program below and got the following SAS log > > >>>>>part of sas log<<<<<<< > PROC TRANSPOSE DATA = JUNKO2 OUT=JUNKO2 ;RUN; > > NOTE: No variables to transpose. > NOTE: The data set WORK.JUNKO2 has 0 observations and 14 > variables. > NOTE: The PROCEDURE TRANSPOSE used 0.16 seconds. > >>>>>>>>end <<<<<<<<<<<<<< > > Why can't I get the transpose of the variable NAME. Shouldn't I > expect something like: > > _type_ col1 col2 col3 col4 .......etc > Name annfee clsvar cluster insfee_k .....etc > > Please, help. Thanks. > > abdu > > ********program********* > DATA JUNKO ; > INPUT NAME $ ; > LENGTH NAME $8. ; > CARDS ; > ANNFEE > CLSVAR > CLUSTER > INSFEE_K > INTCHG > INTCHG_K > LTOLFE > LTOLFE_K > ; > RUN; > > > DATA JUNKO2;SET JUNKO; RUN; > > PROC PRINT ;RUN; > > PROC TRANSPOSE DATA = JUNKO2 OUT=JUNKO2 ;RUN; > > PROC PRINT DATA=JUNKO2; RUN;