Help using Base SAS procedures

transpose character variables

Accepted Solution Solved
Reply
Regular Contributor
Posts: 222
Accepted Solution

transpose character variables

Hi guys,

when I try to transpose a dataset, all the character variables will be ignored.

how to tranpose character variables?

Thanks!

Mike

proc transpose data=sashelp.class out=cs;

by name;

run;

/*variable sex missed*/


Accepted Solutions
Solution
‎06-12-2012 04:08 PM
Super User
Posts: 5,240

Re: transpose character variables

SAS usually puts a lot of thought into these decisions, rather than making them arbitrarily.  If your list of variables to transpose includes a character variable, then all the transposed variables will have to be character.  If you want to do this, you can always specify:

var _all_;

Good luck.

View solution in original post


All Replies
Respected Advisor
Posts: 3,780

Re: transpose character variables

Without a VAR statement only numeric variables are transposed. 

Solution
‎06-12-2012 04:08 PM
Super User
Posts: 5,240

Re: transpose character variables

SAS usually puts a lot of thought into these decisions, rather than making them arbitrarily.  If your list of variables to transpose includes a character variable, then all the transposed variables will have to be character.  If you want to do this, you can always specify:

var _all_;

Good luck.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 6330 views
  • 4 likes
  • 3 in conversation