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
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
> > On 1/25/10, Kevin Myers <KevinMyers@austin.rr.com> wrote:
> > > proc transpose data=original out=skinny type length format informat
> > > 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
> > > remotely close to something this simple, then you win a (virtual)
> > >
> > Seems obvious: data=original