st: help on creating a new variable

[<pmitra@ups.com>]

Hello All,

I have a dataset like the following (Original Data) and need to create
an additional variable (New Data). The data set is by pkgNo and
customer. Some of the pkgs. are in sequence which indicate they are from
the same source and I need to flag them by the first pkgNo. For example,
the first 4 obs. are from one source which have sequence no 1 to 4 and
ALWAYS identified by NON for the first pkgNo and MPS for the subsequent
ones. I need to create the flag "NewPkgNo" which will contain the value
of the first sequence for the entire source ("1ZA20F980340070869" when
Sequence == 1 & PieceCode[1]== "NON" & PieceCode[2] to PieceCode[4] ==
"MPS"). Obs. 5 and 6 are from the different sources since their sequence
numbers are 1 and PieceCode == "NON".

Original Data
-------------
Customer PkgNo             Sequence   PieceCode    Rate
A20F98   1ZA20F980340070869   1        NON          2.8
A20F98   1ZA20F980341667473   2        MPS          3.8
A20F98   1ZA20F980340721281   3        MPS          4.0
A20F98   1ZA20F980340376299   4        MPS          5.2
A20F98   1ZA20F980340721282   1        NON          3.0
A20F98   1ZA20F980340376200   1        NON          6.8
XX1122   1ZXX11220340721282   1        NON          3.0
XX1122   1ZXX11220340376200   1        NON          6.8
XX1133   1ZXX11330340721284   1        NON          3.0
XX1133   1ZXX11330340376255   2        MPS          6.8

New Data
--------
Customer NewPkgNo           PkgNo               Sequence   PieceCode
Rate
A20F98   1ZA20F980340070869 1ZA20F980340070869   1          NON
2.8
A20F98   1ZA20F980340070869 1ZA20F980341667473   2          MPS
3.8        A20F98   1ZA20F980340070869 1ZA20F980340721281   3
MPS         4.0        A20F98   1ZA20F980340070869 1ZA20F980340376299
4          MPS         5.2
A20F98   1ZA20F980340721282 1ZA20F980340721282   1          NON
3.0        A20F98   1ZA20F980340376200 1ZA20F980340376200   1
NON         6.8
XX1122   1ZXX11220340721282 1ZXX11220340721282   1          NON
3.0
XX1122   1ZXX11220340376200 1ZXX11220340376200   1          NON
6.8
XX1133   1ZXX11330340721284 1ZXX11330340721284   1          NON
3.0
XX1133   1ZXX11330340721284 1ZXX11330340376255   2          MPS
6.8

I can't figure out a way to tackle this problem. Can someone please
provide me any help?

Thank you,
Pinaki Mitra

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/