Hi Statalists!
This will be my first posts, but I have been lurking around this forum for a while looking at answers provided to questions similar to ones I have had about Stata.
Currently I am working with a dataset with a large number of stock trading observations. After having cleaned up part of the data I now wish to extract all the unique cusip id's (= a string variable). Using: levelsof cusip, clean Stata shows the unique values I wish to export. However when trying to get Stata to export this into an excel file via putexcel (A1) = (levelsof cusip, clean) is gives an error saying levelsof not found. I suspect that this means that it it not possible to export the results of levelsof via this method but am not sure as I am still quite new to Stata. I hope someone here is able to help me export the unique id's and enlarge my understanding of Stata.
Kind regards,
Pim
Related Posts with Export output of levelsof
Can I run GMM (and OLS, 2SLS, IV) with very unbalanced panel of poverty & financial development data (Africa, 2000-2019)?Hello Statalist 1). Can I run a gmm, 2sls, ols estimations using this (partial snapshot shown below…
output from outreg2.Dear All, With given data, I run the following regressions and use (ssc install) outreg2 to construc…
Replacing dummy variable value to one for the following daysHi Statalist, I am working on air pollution alert data and wondering how to make dummies (or replac…
Loop to create new variablesDear All I am working on a data set where I have to create (project) variables for age and position…
2 way clustering in fixed effects panel data regressionHi, I'm trying a fixed effects regression with panel data where I cluster across two dimensions. Fo…
Subscribe to:
Post Comments (Atom)
0 Response to Export output of levelsof
Post a Comment