Date:         Mon, 25 Jan 2010 16:13:18 -0600
Reply-To:     "Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: SASware ballot #18 Proc Transpose preserving variable
              attributes
Comments: To: Kevin Myers <KevinMyers@austin.rr.com>
In-Reply-To:  <EE9AC9DA8CAB4076898704C632AFB577@KAM1720>
Content-Type: text/plain; charset=ISO-8859-1

Just having some fun.

When the data are converted to character by the first transpose it
will be impossible in some situations to get back to the original
data.  I believe you and Ted have discussed this already.

That, is one reason I suggest that a PROC to read a data set CONTROL
data set could be useful but PROC TRANSPOSE is not the proper tool.

I use PROC TRANPOSE often but I rarely need to get back to the
original data or some even modified version with the same structure.

I guess I don't see why the data flip-flop is so useful to you or why
you need it.  Maybe if you showed some of the code you are using that
requires macro or whatever I would understand better.


On 1/25/10, Kevin Myers <KevinMyers@austin.rr.com> wrote:
> Oh come on Null...
>
> As mentioned in the message, the example program is merely an
> overly-simplistic test case strictly intended to illustrate and exercise all
> of the necessary features.  Any real application would include additional
> logic between the two transpose steps, or read the desired attributes values
> from a "self-defining" external file.
>
> The real trick is for you to simulate the *second* transpose step with
> comparably simple code of your own.  For you to say that the proposed
> TRANSPOSE enhancements are not needed, that is what you must be able to
> accomplish.  So, are you up to the challenge?
>
> ----- Original Message ----- From: "Data _null_;" <iebupdte@GMAIL.COM>
> To: <SAS-L@LISTSERV.UGA.EDU>
> Sent: Monday, January 25, 2010 15:12
> Subject: Re: SASware ballot #18 Proc Transpose preserving variable
> attributes
>
>
>
> > On 1/25/10, Kevin Myers <KevinMyers@austin.rr.com> wrote:
> >
> > > proc transpose data=original out=skinny type length format informat
> force
> > > noformat; by obsno;
> > >  var _all_; run;
> > >
> > > proc transpose data=skinny out=final noinformat; by obsno;
> > >  id _NAME_; idlabel _LABEL_; idtype _TYPE_; idlength _LENGTH_; idformat
> > > _FORMAT_; idinformat _INFORMAT_;
> > >  var col1; run;
> > >
> > > If you can manage to accomplish something similar with code that is
> anywhere
> > > remotely close to something this simple, then you win a (virtual)
> cookie.
> > >
> >
> > Seems obvious: data=original
> >
> >
>
>
>