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
How to convert my FE-IV model (with intuitions borrowed from the RDD literature) into STATA language - Is IVREGHDFE the one?Hello dear stata friends! I am having some confusion regarding the implementation of my Individual-F…
expand dataDear Stata users, I have a panel database of countries observed on a yearly basis from 2004 to 2018…
Editing a spatial weighting matrix in neighbor list formI used spmat to create a spatial weighting matrix. I exported it in neighbor list form. The first ro…
How to Correct Data Errors in Longitudinal Format Data in Stata?I have a long format dataset with data error on the variables of kg5, k68, and k912 like this, clear…
treatment turns on and offHello everyone, I hope you are very well, I have some monthly panel data at the state level, in thi…
Subscribe to:
Post Comments (Atom)
0 Response to Export output of levelsof
Post a Comment