Okay I solved the problem. I ran the same command you gave and got: I can’t replicate your problem. In the help file I read that the syntax of -ipolate- is: More about this item Keywords interpolation ; extrapolation ; times ; generate ; Statistics Access and download statistics Corrections All material on this site has been provided by the respective publishers and authors. Since I can’t name all variables, I created a varlist of numeric variables.
If CitEc recognized a reference but did not link an item in RePEc statw it, you can help with this form. This is my original data: That is what I did, but I do not get the results I want. Last edited by gicanzo ; 24 Jul It seems that you have data like this only part of your data is visible on the image: Since I can’t name all variables, I created a varlist of numeric variables.
Your question states that you must do this and I am explaining how. What I did so far: I think you’re arguing with yourself. Since I am working on panel, that command was calculating a cross-section average or something like that.
More about this item Keywords interpolation ; extrapolation ; times ; generate ; Statistics Access and download statistics. Swries also allows you to accept potential citations to this item that we are uncertain about.
Help us Syata Found an error or omission? In the example you gave, the yvar is Variable and the xvar is Year. I created a data set that looks like your photo.
Interpolating numeric values in Stata without creating new variables Ask Question. General contact details stats provider: This allows to link your profile to this item.
Also, I do not want to recreate thousands of extra variables, so I need to replace the existing missing values.
For technical questions regarding this item, or to correct stta authors, title, abstract, bibliographic or download information, contact: Well, since neither Nick nor I could replicate your problem, and it certainly appears you are doing it correctly, there may be something wrong with your Stata installation.
So do it in 3 commands.
Filling empty observations in panel – Statalist
Thanks in advance for your help. I will be very happy to see a better solution: If you have authored this item and are not yet registered with RePEc, we encourage you to do it here.
Ok, this is a workaround since I can’t find a way to replace values with ipolate that is feasible seties thousands of variables: Just to be clear, I have something like this: I solved by calculating it by cross-section unit: If the error means that factors exist in my varlist – how to detect them? How can I do this? Search in titles only.
time series – Interpolating numeric values in Stata without creating new variables – Stack Overflow
See general information about how to correct material in RePEc. How is the ‘replace’ even proper syntax? Sign up using Email and Password. Since it is reasonable to assume that this variable changes slowly over time, I would like to fill in the gaps following a function shata is basically a straight line between the two values.
Type -update all- in the command line. I only have 1 variable of which i want to extrapolate values.
You don’t show the year variable, but for the purpose at hand, I just let “year” be the observation number. Sign up or log in Sign up using Google. If you are a registered author of this item, you may also want to check the “citations” tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.
You can help correct errors and omissions. Sign up using Facebook. If not, how to get around this?