Date: Tue, 3 Dec 2002 12:49:28 +0100
Reply-To: Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject: Re: A question regarding string.
Content-Type: text/plain; charset="iso-8859-1"
Hi Alex,
This is not the code that produces the table. I want to see that one
instead. Is it PROC PRINT? Or PROC TABULATE or REPORT? Furthermore, what is
your option pagesize? May be it is too short to display wide values in a
single line, causing wrapping. Show the table code and the table itself
(copy and paste to your email).
Regards - Jim.
--
Y. (Jim) Groeneveld, MSc IMRO TRAMARKO tel. +31 412 407 070
senior statist./data man. P.O. Box 1 fax. +31 412 407 080
J.Groeneveld@ITGroups.com 5350 AA BERGHEM, NL www.imrotramarko.com
My computer does what I tell it to do; sometimes it says my instructions are
illegal.
Notice of confidentiality: this e-mail may contain confidential information
intended for the addressed recipient only.
If you have received this e-mail in error please delete this e-mail and
please notify the sender so that proper delivery can be arranged.
> -----Original Message-----
> From: alex nilla [mailto:alexnilla@yahoo.com]
> Sent: 03 December 2002 12:29
> To: Jim Groeneveld
> Subject: Re: A question regarding string.
>
>
> Hi jim,
> This is code what i used -
>
> DATA final;
> SET comb;
>
> RETAIN subtxt nz;
> LENGTH subtxt $200. ;
> BY grptext linenr;
>
> IF first.linenr OR nz EQ 5 THEN DO;
> subtxt = TRIM(subid);
> nz=1;
> END;
> ELSE DO;
> subtxt = trim(subtxt)||','||trim(subid);
> nz=nz+1;
> END;
> IF last.linenr OR nz EQ 5 THEN OUTPUT;
> RUN;
>
> The output table comes out like this:-
>
>
> TREATMENT(char $200) SUBJID(char $50)
> ---------------- -------------------------
>
> xxxxxxxxxxxxxxxxxxx 123,223,444,555,676
> aaaaaaaaaaaaaaaaaaa 234,565,567,987,967
> zzzzzzzzzzzzzzzzzzz 345,654,334,554,234
> zzzzzzzzzzzzz -----------> blank line
> 454,332,897,786,654
> yyyyyyyyyyyyyyyyyy 233,243,356,789,876
>
> so. here the 3rd text zzzzzzzzzzzzzzzzzzz flows in the
> two lines also,so there is a blankline infront of it.
> so i want to remove the blankline from the table
> report. and both the variable are character typ.
>
>
> Alex, regards!
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --- Jim Groeneveld <J.Groeneveld@ITGROUPS.COM> wrote:
> > Sorry Alex,
> >
> > Completely unclear what you want, what your problem
> > is, in what instance,
> > etc.
> > Provide your code, your output, your log, your
> > desired output, tell what you
> > do, etc.
> >
> > Regards - Jim.
> > --
> > Y. (Jim) Groeneveld, MSc IMRO TRAMARKO
> > tel. +31 412 407 070
> > senior statist./data man. P.O. Box 1
> > fax. +31 412 407 080
> > J.Groeneveld@ITGroups.com 5350 AA BERGHEM, NL
> > www.imrotramarko.com
> >
> > My computer does what I tell it to do; sometimes it
> > says my instructions are
> > illegal.
> >
> > Notice of confidentiality: this e-mail may contain
> > confidential information
> > intended for the addressed recipient only.
> > If you have received this e-mail in error please
> > delete this e-mail and
> > please notify the sender so that proper delivery can
> > be arranged.
> >
> >
> > > -----Original Message-----
> > > From: alex nilla [mailto:alexnilla@YAHOO.COM]
> > > Sent: 03 December 2002 10:03
> > > To: SAS-L@LISTSERV.UGA.EDU
> > > Subject: A question regarding string.
> > >
> > >
> > > Hi dear all,
> > >
> > > I have a question regarding string! I have a table
> > where i am
> > > displaying treatments and its related
> > subjectids.but in one
> > > case there is a blank exists how to resolve it.
> > >
> > > suppose,
> > >
> > > treatement
> > subjid
> > >
> > > aaaaaaaaaaaaaaaaaaaaaaaaa 133,123,134,144,
> > 144,345
> > >
> > >
> > 123,456,432,345,223
> > >
> > > yyyyyyyyyyyyyyyyyyyyyyyyy
> > 222,333,445,234,345,678,
> > >
> > > yyyyyyyyyyy this blank line
> > has to remove
> > >
> > >
> > 123,234,568,498,234,456
> > >
> > > Note : The text of yyyyyy is comming to the second
> > line so this
> > >
> > > happening, actually i want to display subject id
> > just infront
> > >
> > > of the secondline yyyyyyyyyyyyy.
> > >
> > > Thanks in advance,
> > >
> > > alex
> > >
> > >
> > >
> > >
> > >
> > > ---------------------------------
> > > Do you Yahoo!?
> > > Yahoo! Mail Plus - Powerful. Affordable. Sign up
> > now
> > >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
| 
