Hey I have a dataset in this format:
Date(daily) var1 var2 var3 var4 var5
I only want to work with the value that each variable have the last day in each month
So for january I want the value for day 31, for february the value for day 28(unless leap year of course), and so on.
Also, if the last date in this month is a holiday and I have no value, can I make it use the last valid value for this month? Missing values are noted as NA instead of a number.
Related Posts with Using only end of month values for a daily dataset?
Help with parsing values in variablesDear Statalist, I'll like to create var3 as a dummy variable, with the value of 1 where an ID in var…
How generate terrain ruggedness, elevation over sea level and distance to points of interest?Hi, I am new in Stata. I don't find codes to generate terrain ruggedness, elevation over sea level a…
Adding gap years in the observationsHello everyone, I have three variables in my dataset - company name, year, and profit. The year var…
Need help figuring out this commandHi! I need help with a question on my stats homework and I cannot figure out how to set up this comm…
Multilevel mixed-effects negative binomial regressionI am running a multilevel mixed-effects negative binomial regression and have two questions I'd like…
Subscribe to:
Post Comments (Atom)
0 Response to Using only end of month values for a daily dataset?
Post a Comment