I am interested in making categories(Large, small, medium) based on the log of [/CODE]market value of equity (z_ln_mve)
the variable (z-ln_mve) is standardized using commands:
Code:
gen z_ln_mve=0
Code:
replace z_ln_mve=ln_mve-mean(ln_mve)
I want the categories to be
small= less than or equal to _1 standard deviation in the market value variable (z_ln_mve)
medium= between greater than -1 and less than +1 standard deviation
large= greater than or equal to +1 standard deviation
the sample data is given below
where ln_mve= log of market value
and
z_ln_mve= standardized values of log of market values.

Code:
sum z_ln_mve
Variable | Obs Mean Std. Dev. Min Max
----------------------------------------------------------------------
z_ln_mve | 24,605 1.09e-06 2.304831 -6.974789 6.907081


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input double ln_mve float z_ln_mve
17.565108747112916  -3.331611
 17.40258981761514   -3.49413
  17.8344416808965  -3.062278
17.688934097225264  -3.207786
16.811052813465977  -4.085667
17.639541341895686 -3.2571785
 17.57640830236685  -3.320312
 17.46979856730859 -3.4269214
17.856760203852197   -3.03996
17.865213339563255  -3.031507
18.012122858133953  -2.884597
 18.10107034415045   -2.79565
18.137627939884247  -2.759092
17.875263675416754  -3.021456
18.181522133441472  -2.715198
17.993046711073138  -2.903673
 17.86689542574624 -3.0298245
17.788252298427125  -3.108468
17.692942118622803  -3.203778
17.875263675416754  -3.021456
17.753096041442546  -3.143624
17.830963416520177 -3.0657566
17.788252298427125  -3.108468
17.764332114709475  -3.132388
 17.87025113359321  -3.026469
17.955306383090292 -2.9414136
18.029414355244015  -2.867306
 17.88356247823145 -3.0131576
 17.93980219655433  -2.956918
 17.93980219655433  -2.956918
17.891792977367967  -3.004927
17.875263675416754  -3.021456
 18.34004536068134  -2.556675
 18.86851544842704 -2.0282044
18.907854862987072  -1.988865
18.865424255857366 -2.0312958
18.922582669697317 -1.9741373
 18.92841359000811 -1.9683064
18.856717733197325 -2.0400023
 18.84667370651199 -2.0500462
 18.87773210353196  -2.018988
18.959889722110127 -1.9368303
18.869749254875966 -2.0269709
18.589030143179436   -2.30769
18.641506411047253 -2.2552135
 18.78419405288462  -2.112526
19.458357612511254 -1.4383624
20.288196825579668  -.6085232
19.792186287598817 -1.1045337
  19.4210515607744 -1.4756684
 19.36027150947268 -1.5364485
19.174546659547016 -1.7221733
19.179081814712408  -1.717638
 19.00127493827298  -1.895445
18.920240748252233 -1.9764793
19.044127302629125 -1.8525927
 19.05032246957805 -1.8463975
 18.74376374345456 -2.1529562
 18.75765285561523 -2.1390672
18.974431365376567 -1.9222887
18.615612457460994 -2.2811074
18.291778619711504 -2.6049414
18.386089299182746 -2.5106306
 18.46859052069449 -2.4281294
 18.43487946335218 -2.4618406
18.605224829099416  -2.291495
18.636069504450514 -2.2606504
18.648453563650236 -2.2482665
18.481399478987072 -2.4153206
   18.335848082746  -2.560872
 18.28072878352492  -2.615991
 18.28072878352492  -2.615991
 18.28072878352492  -2.615991
18.345267304662492 -2.5514526
 18.35563009169804   -2.54109
18.386089299182746 -2.5106306
18.258255927672863  -2.638464
 18.42049072590008  -2.476229
18.481399478987072 -2.4153206
 18.43487946335218 -2.4618406
18.258255927672863  -2.638464
18.386089299182746 -2.5106306
18.308127757713034  -2.588592
 18.39702923922108  -2.499691
 18.49941798448975  -2.397302
 18.43487946335218 -2.4618406
 18.49941798448975  -2.397302
 18.55160373766032 -2.3451164
 18.55160373766032 -2.3451164
18.481399478987072 -2.4153206
18.391076840693785  -2.505643
18.391076840693785  -2.505643
18.385088798849164  -2.511631
 18.33374281881054  -2.562977
 18.33374281881054  -2.562977
22.984427670946943  2.0877078
22.984427670946943  2.0877078
 22.99255779703019  2.0958378
22.833960674210953  1.9372407
 22.92828914500774  2.0315692
end
please provide me with the necessary commands for the operations.
Thank you