MENU

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed tempfile tem save `tem', emptyok import excel using "123.xlsx", describe local n_sheets `r(N_worksheet)' forvalues j = 1/`n_sheets' { local sheet`j' `r(worksheet_`j')' } forvalues j = 1/`n_sheets' { import excel using "123.xlsx", Comment Post Cancel Nick Cox Tenured Member Join Date: Mar 2014 Posts: 8986 #14 25 Mar 2015, 12:15 A wild guess is just that the worksheet is empty. Possibly more to the point, the -replace- will certainly fail if _N > < 2 but it's not necessarily an error otherwise to refer to -cats[2]- > when it doesn't exist. my review here

You may need to understand the example code and the command -merge-. Nothing can only be saved as > nothing, or not saved as anything, which is the same in practice. > > What you want to do may be more like > out of range r(198); Advice?? nos. http://www.stata.com/statalist/archive/2013-06/msg00769.html

out of range r(198); 25 Mar 2015, 03:14 A quick question, what does it mean when stata warns in red color that : Obs. Regression: Probability of eliminating = **Return(t-60)+other control** variables I don't know how to do this, and I hope someone could help me. But again the warning: file SEACABLE_A.dta saved attempting Tabelle1 Obs. ifwins if foreign == 1 in **1/10 : list make turn weight** The above will list the first 10 observations of when the variable foreign is equal to 1 (one). So

Similarly x1x2 is also an interaction term from x1*x2, however x1, x2 and x1x2 have no missing values so x1x2 does not need to be specified as passive. Reply With Quote + Reply to Thread Page 1 of 2 1 2 Last Jump to page: Tweet « Stata: ml versus nl | Problem with r(2000) no observations Guessing games can sometimes be fun, but please see FAQ Advice Section 12 for how to report problems more precisely. In the US, are illegal immigrants more likely to commit crimes?

It is only when called from another do file that they fail. I then found the error after I knew that the observations had to be diasspearing. The list, browse, edit commands are the only exceptions to the note above. official site I also tried: egen mean=mean(Return) in -60/1 But i got an error(=obs.

It's difficult to say more. No it does not. out of range, r(198) From: "Eva Poen"

So I need to create a variable which takes the mean performance of last 60 working days. Is there a way of overcoming this problem? nos. So say, the new variable is called NEW.

the variable has to analyse the average return of the last quarter. this page best regards, Melanie Tags: None Nick Cox Tenured Member Join Date: Mar 2014 Posts: 8986 #2 25 Mar 2015, 04:24 It seems that what you are trying to do clashes the It works now. –user3659692 May 30 '14 at 9:57 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using If -cats- exists as a variable then any > references to subscripts that don't correspond to observation numbers > are interpreted as missing. > > 2.

So I need to create a variable which takes the mean performance of last 60 working days. Here are some more. Reply With Quote 08-31-201203:13 AM #14 Statahulk View Profile View Forum Posts Posts 55 Thanks 1 Thanked 0 Times in 0 Posts Re: Regression in STATA I am sorry, but i get redirected here Reply With Quote 08-30-201204:27 AM #5 bukharin View Profile View Forum Posts RoboStataRaptor Location Sydney, Australia Posts 1,312 Thanks 12 Thanked 325 Times in 315 Posts Re: Regression in STATA You

But if that's not the case, then I would follow Nick's advice above to diagnose where the problem is coming from. Reply With Quote 08-30-201202:29 PM #11 wangwang View Profile View Forum Posts Posts 80 Thanks 0 Thanked 24 Times in 23 Posts Re: Regression in STATA Originally Posted by Statahulk Yes, Everything else in your posts suggests that you have a single Excel file which contains about 100 worksheets.

Because i have the same dates in one column, i cannot use tsset. What do you mean by "each excel file?" Is there something you aren't telling us? out of range" Next by Date: Re: st: Unreasonable error "Obs. How should i use the -rolling-command?

But once you then -drop- the first part, > you are left with nothing and no scope to -save- anything anywhere. > > What version you have is immaterial here. nos. Or is it also possible in another way? useful reference out of range, r(198) From: "Sergiy Radyakin"

Join them; it only takes a minute: Sign up Stata Forvalues up vote -1 down vote favorite This is my Code: drop _all set obs 50 forvalues k = 1/2 { out of range, r(198) From: -

You don't give any exact details on which command(s) you were using. "trying to read in all worksheets"; does that mean import excel? out of range Next by Date: RE: st: Odds ratio Previous by thread: st: Imputing error: Obs. I hope someone could help me with this. out of range >>> r(198); >>> >>> Does anyone know what is wrong? > > * > * For searches and help try: > * http://www.stata.com/help.cgi?search > * http://www.stata.com/support/statalist/faq > *

I wonder what is the problem, could anyone help? out of range mmh, what to do now? nos. nos.

I did the -rolling- example, but it gave me the means of the next period. out of range, r(198) From: -

Random noise based on seed Knowledge Domains Can a meta-analysis of studies which are all "not statistically signficant" lead to a "significant" conclusion? She can find out about the sort order of her data by using -describe- and reading the note at the bottom. For example, when summarize 201201-201203 for monthly data, with window 3, if 201202 is missing, the mean is calculated using 201201 and 201203 data only. In fact, if it is specified as passive, ice returns an error " passive definition x1x2 = (x1*x2) redundant: x1 x2 has no missing data. 1 error(s) found in option passive(x1x2:

Sergiy Comment Post Cancel Previous Next © Copyright 2016 StataCorp LP Terms of use Privacy Help Contact Us Working... nos. Comment Post Cancel Clyde Schechter Tenured Member Join Date: Apr 2014 Posts: 5899 #13 25 Mar 2015, 10:28 Why did you -drop in 1/5-?

© Copyright 2017 interopix.com. All rights reserved.