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>
Organization: http://groups.google.com
Subject:      Re: Help with proc transpose
Comments: To: sas-l@uga.edu
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
getting truncated?

data test;
 input c1 $1. c2 $2. c3 $3. ;
cards;
12345678901234567890
2345678901234567890
345678901234567890
45678901234567890
5678901234567890
run;
proc transpose data=test out=ascending;
  var c1 c2 c3;
run;

proc transpose data=test out=descending;
  var c3 c2 c1;
run;



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 -