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
PPML and fixed effects commandsGood evening, guys. I'm currently working on a gravity model with PPML estimator. Here is the thread…
Converting Stata version 16 to Stata version 12 with Stat/Transfer in LinuxDear Forum Members, I have some Stata version 16 data files, which I would like to convert to Stata…
post and postfile help after regressionI am running a simple regression repeated for ~1,000 variables in a loop. I would like to capture th…
reshape errorHi, I am trying to reshape from wide to long, but it keeps saying that "variable id does not uniquel…
Exact matching on Propensity Score MatchingDear Stata Forum, I’m trying to perform a Propensity Score Matching with exact matching but found m…
Subscribe to:
Post Comments (Atom)
0 Response to Export output of levelsof
Post a Comment