|Date: ||Wed, 10 Dec 2008 13:16:23 -0200|
|Reply-To: ||Paulo Rodrigo <rodrigo.paulo.sp@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Paulo Rodrigo <rodrigo.paulo.sp@GMAIL.COM>|
|Subject: ||Re: Transpose operator in SAS DI Studio|
|Content-Type: ||text/plain; charset=ISO-8859-1|
Which D.I Studio are you using, 3.4? This is a default node on your
install or was generated by some analyst? Is this a User Written Code ?
Att: Paulo R. Herculano
On Mon, Dec 8, 2008 at 12:04 PM, Søren K <Soren.Kongstad@gmail.com> wrote:
> How does mappings work in the transpose operator?
> I have a table looking like this
> And I want to transpose it to
> without DI studio this works out as
> proc transpose data=Inputdata out=Outputdata
> by Product#
> var Week1,Week2,Week3,...,Week890
> Which produces a dataset looking like this
> However when I make the same transpose operation in DI Studio, I
> cannot map the _NAME_ and COL1 variables.
> I can see that an intermediate dataset is created that looks like what
> I described above, but when I try to map, I see all the variables from
> the input data set, and I cannot see the variables _NAME_ and COL1
> created by the transpose.
> What am I doing wrong? the documentation does not talk about this!