Hi. This will likely be a banal and rudimentary question. Apologies in advance, but I am stuck nevertheless. To my own disgrace, I am not able to troubleshoot through help format.
I have a string variable imported from an excel file. This string variable is stored as str6 %9s. I need to format this variable such that:
1. There are 6 characters/digits for each observation
2. There is a decimal before the final two characters/digits, and after the first 4.
Current values for this variable, TOP, include:
130800
83700
10100
100810
However, I need these (and all other) values to take the following form:
1308.00
0867.00
0101.00
1008.10
Thanks in advance.
Related Posts with Formatting a String
count *same names*in other groups?Dear All, I find this question here. The data is Code: * Example generated by -dataex-. To install…
Interpretation of marginal effects of a continuous variableHi all, I’ve been reading about this issue and I read pretty much all related topics but I still co…
Creating a new continuous variableHi everybody, Could anyone help me out with creating a new continuous variable? My main dataset do…
Addition by SICHi, Can you please help with the below. I need to add values by SIC code in the below example. (sim…
robust standard error for IV panel regressionHi I have been running panel data random effect 2sls (G2SLS) and i want to robust to heteroskedastic…
Subscribe to:
Post Comments (Atom)
0 Response to Formatting a String
Post a Comment