Hello, I have a mock data set and one variable is "country" with the corresponding two letters "AT" for the few observations in my mock data set. (HFCS dataset)
Now the actual data is stored at the university (security reasons) so I have to write the code and then let it run through the data there, when I am done.
I am having trouble though with the before mentioned country variable though. Even though it appears in the data set as letters (AT) it seems to be encoded as either numeric or something else.
if I type keep if country == "AT" I get a mismatch error. The variable is type long and the format is %8.0g (whatever that means).
So I tried to change it via tostring and typed in the command
tostring country , generate(count)
But now the new variable doesn't have AT anymore, instead it has the number 1 for each entry. Although if I now put in the command
keep if count == "1" (doesn't work without the "", so it seems to be coded as non numeric) it at least performs the command and seems to yield no errors.
I was just wondering, is there a way to change the country variable in such a way, that I do keep the two letters and not change that into a number? Otherwise it will get very confusing once I have access to the entire data set and now have over 20 different countries.
Related Posts with Problem with variable and its format.
Error 134: too many valuesHello STATA community, i am running a gravity model with exporter_time_FE, importer_time_FE and cou…
graphical presentationHi, I have a data of average steps over 12 weeks. How to use histogram/bar graph in stata to represe…
Ordered Regression (dependent variable)Hallo Statalist, i am trying to find out the effect of the macro variables on the credit Rating in …
How to explain and use Stephen Jenkins' J indiceDear Stata users, Professor Stephen Jenkins developed command named -ineqord- (SSC, Distribution-Da…
Too much margin on x-axis with graph combineHi Statalists, I am combining four graphs with datetime on the x-axes. The individual graphs have a…
Subscribe to:
Post Comments (Atom)
0 Response to Problem with variable and its format.
Post a Comment