Date: Fri, 20 Nov 2009 11:02:32 -0800
Reply-To: Tom Abernathy <tom.abernathy@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Tom Abernathy <tom.abernathy@GMAIL.COM>
Subject: Re: Help with proc transpose
Content-Type: text/plain; charset=ISO-8859-1
I am not sure you are describing your problem correctly.
What is it that is getting truncated?
Can you post an example?
When I tried this example I did not get any truncation..
Perhaps it is the BY processing that is causing the trouble? But I do
not see why that would be true.
Do you have FORMATS attached? Perhaps it is just the DISPLAY that is
input c1 $1. c2 $2. c3 $3. ;
proc transpose data=test out=ascending;
var c1 c2 c3;
proc transpose data=test out=descending;
var c3 c2 c1;
On Nov 20, 10:39 am, Box666 <b...@mystical.demon.co.uk> wrote:
> On 20 Nov, 14:30, Dirk Nachbar <dirk...@googlemail.com> wrote:
> > On Nov 20, 12:39 pm, Box666 <b...@mystical.demon.co.uk> wrote:
> > > I am using proc transpose and it is truncating data in one of the
> > > columns. Is there a way to set column width to get the full data name
> > > included.
> > > proc transpose data=complaints3 out=complaints4/*(drop=_name_ _label_)
> > > */;
> > > by descending original_date_received;
> > > id current_user_group_name;
> > > run;
> > I might be confused but don't you need a var statement as well?
> > variable names can only have 32 characters, so shorten
> > current_user_group_name before.
> > Dirk
> Max char 8 min char 5 . All are truncated to 5. It seems as though the
> first line in sets the length for the others. I have tried various
> sorts to try and get one of the max char rows in first but it still
> only picks up first 5 char.!!- Hide quoted text -
> - Show quoted text -