Date:         Wed, 10 Feb 2010 13:08:39 -0800
Reply-To:     SD <saurabhkdas@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SD <saurabhkdas@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Data Manipulation
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Hello Nathan,

thanks, I did try what you suggested : the new code would look like
this ( replacing the a/b/c/d etc with real SKU) .. this is your
code ..


data tt (rename = ( Sku1 = Sku ));
infile cards;
length sku1 $ 10;
input year    country $ SKU $ original  countft;
Value = count(sku , '/' ) + 1 ;
Original = Original / value;
Countft  = Countft  / Value;
do i=1 to value;
     sku1=scan(sku,i,'/');
     output;
end;
drop  i value sku ;
cards;
2009 germany E2345/E2346/E2347 40 20
2009 uk D345/D346/D347 30 6
;

And the output I am getting is
SKU     Year    Country Original        Counft
E2345   2009    germany 20      10
E2      2009    germany 20      10
D345    2009    uk      15      3
D34     2009    uk      15      3

Some where I think I am missing something.

SD





On Feb 11, 12:11 am, SD <saurabhk...@gmail.com> wrote:
> Thanks Nathan, Oleg, if I now replace SKU  -  a/b/c/d by E2345/E2346/
> E2347, will it give the same results ?
>
> thanks SD
>
> On Feb 10, 7:25 pm, nathaniel.wood...@DOM.COM (Nathaniel Wooding)
> wrote:
>
>
>
> > Here is a modification of Oleg's code that uses the V9 Count function which in this case tells us how many slashes appear in a particular SKU value.
>
> > Nat wooding
>
> > data tt (rename = ( Sku1 = Sku ));
> > infile cards;
> > length sku1 $ 10;
> > input year    country $ SKU $ original  countft;
> > Value = count(sku , '/' ) + 1 ;
> > Original = Original / value;
> > Countft  = Countft  / Value;
> > do i=1 to value;
> >      sku1=scan(sku,i,'/');
> >      output;
> > end;
> > drop  i value sku ;
> > cards;
> > 2009    germany a/b/c/d 40      20
> > 2009    uk      f/g/h   30      6
> > ;
>
> > -----Original Message-----
> > From: SAS(r) Discussion [mailto:SA...@LISTSERV.UGA.EDU] On Behalf Of SD
> > Sent: Wednesday, February 10, 2010 5:49 AM
> > To: SA...@LISTSERV.UGA.EDU
> > Subject: Data Manipulation
>
> > Hi everyone,
>
> > i have a dataset
> > year    country SKU     original        countft
> > 2009    germany a/b/c/d 40      20
> > 2009    uk      f/g/h   30      6
>
> > Want a dataset
> > year    country SKU     original        countft
> > 2009    germany a       10      5
> > 2009    germany b       10      5
> > 2009    germany c       10      5
> > 2009    germany d       10      5
> > 2009    uk      f       10      2
> > 2009    uk      g       10      2
> > 2009    uk      h       10      2
>
> > Need to scan , extract the SKUs  -which I have been able to do,
> > however getting the number of SKU and dividing the number, that the
> > area , I digging.
>
> > As you can see the numbers are divided by the count of SKUs in the SKU
> > column for Germany there are 4 skus and for UK there are 3, the values
> > of original and countft gets divided by 4 and 3 respectively.
>
> > Any help appreciated.
>
> > thanks
> > SD
> > CONFIDENTIALITY NOTICE:  This electronic message contains
> > information which may be legally confidential and or privileged and
> > does not in any case represent a firm ENERGY COMMODITY bid or offer
> > relating thereto which binds the sender without an additional
> > express written confirmation to that effect.  The information is
> > intended solely for the individual or entity named above and access
> > by anyone else is unauthorized.  If you are not the intended
> > recipient, any disclosure, copying, distribution, or use of the
> > contents of this information is prohibited and may be unlawful.  If
> > you have received this electronic transmission in error, please
> > reply immediately to the sender that you have received the message
> > in error, and delete it.  Thank you.- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -