Re: st: Question on data manipulation

[Matthew White <mwhite@poverty-action.org>]

Hi William,

If cusip is an integer and has numeric type:
replace cusip = int(cusip / 10)

If cusip has string type:
replace cusip = substr(cusip, 1, length(cusip) - 1)

Best,
Matt

On Sat, Oct 29, 2011 at 5:42 PM, William Pratt <williamrpratt@gmail.com> wrote:
> Dear Statalisters,
> I have the following string data of 9 characters and would like to
> drop the last value so that it becomes 8 characters. Thanks for your
> consideration.
>
> cusip
> 000360206                  >>>                           00036020
> 000360206                  >>>                           00036020
> 000360206                  >>>                           00036020
> 000360206                  >>>                           00036020
> 000360206                  >>>                           00036020
> 000361105                  >>>                           00036110
> 000361105                  >>>                           00036110
> 000361105                  >>>                           00036110
> 000361105                  >>>                           00036110
>
>
>
> --
> wrpratt@utpa.edu
> University of Texas-Pan American
> College of Business Administration
> Department of Finance and Economics
> South Texas Border Health Disparities Center
> o - 956.665.7937
> f - 956.665.7310
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
>



-- 
Matthew White
Data Coordinator
Innovations for Poverty Action
101 Whitney Avenue, New Haven, CT 06510 USA
+1 434-305-9861
www.poverty-action.org

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/