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
Meta analysis of hazard ratioDear , My name is Hatem Ali I am trying to do meta analysis of hazard ratio to assess effect of rise…
getting a sample sizehi, I'm trying to get the sample size of black women from my data set. I created a black women(bw) …
Droping observations with x amount of missing valuesDear all, I'm working with a messy data set with approximately 870 observations at the moment. After…
Collinearity error when including continuous variable in dummy regressionI am trying to run the following two regressions to compare the coefficients on the 'iso_str' dummie…
Creating a value that equals the average of other values for the same variable(Sorry about the poor phrasing of the question) My dataset contains variables such as country and pr…
Subscribe to:
Post Comments (Atom)
0 Response to Export output of levelsof
Post a Comment