| 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 |
|---|
| In-Reply-To: | <2ad3a399-5c5a-4936-8df3-e62734896057@g38g2000yqn.googlegroups.com> |
|---|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Hi,
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
SAS Consultant
+55-11-9226 6618
Skål Thunar!!
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
>
> Product#,Week1,Week2,Week3,...,Week890
>
> And I want to transpose it to
>
> Product#,Week,Value
>
> 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
>
> Product#,_NAME_,COL1
>
> 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!
>
|
