How to declare "string" condition in If condition

Hello, I am newbie in Stata and I have a problem with stata when I try to declare If condition. In my DB, I have "country" var...

Matching and generating hourly data

Dear Stata Users, I am working on hourly data sets. The datasets have the "zipcodes" variable as the common var to merge/joinby....

Pathways / event history

Dear Statalist users I am hoping you can solve a query I have I want to look at pathways for young people aged between 15 and 30 in and ...

Generating a variable

I want to generate variable that indicate if individuals continue to participate in a program at age of 72 or after. For example, if an indi...

Problem with SVY : poisson regression

Hi all, I'm trying to estimate the effect of containement measures on COVID 19 number of cases evolution (in one city). The thing is ...

Regressing growth rates of a variable on its initial level for separate decades

Dear all, I am currently trying to regress the growth rate of a variable on its initial level and an intercept. Specifically, the compound...

Is it possible to obtain ultra-precision in calculating p-values in Stata?

Dear Statalisters, What would be your suggestion to compute p-values as low as 1e-25? For example: One-sided test gene double p = 1-...

difference between meologit with sampling weights and svy:meologit?

HI, I have a general question about the difference in 2 commands. I have multilevel survey data and an ordered 3 level dependent variable (o...

Constant weight variable in panel data

Dear users, I am working with a static panel dataset including variables at the household level for three years. In the first wave only ru...

Constant weight variable in panel data

Dear users, I am working with a static panel dataset including variables at the household level for three years. In the first wave only ru...

Weight in panel data

Dear users, I am working with a static panel dataset including variables at the household level for three years. In the first wave only ru...

Systems of simultaneous equations with non-linear constraints

Dear Stata users, I have the following issue: I have to estimate a system of simultaneous equations with non-linear constraints of form 0 ...

egen maxdate gives dates 01/01/2500

Hello everyone I am trying to get the difference between two dates to calculate follow up per patient I am using a long format dataset wi...

Excel Table split by socio-demographics using Putexcel

Hello fellow Stata community, I´m looking for a way to automate my Analysis Output to Excel using Putexcel. I already found this Code by e...

Exporting detailed summary statistics to Word

Hello helpful Stata users, I am trying to generate a word export of my dependent variable via the sum function with details. Should basic...

ppmlhdfe Pseudo R2 0.99+

Here is the model to estimate the impact of free trade agreements (fta) and preferential trade agreements (pta) on exports (exports) for ann...

Bernanke Sims Decomposition Restriction for VAR IRFs

Hi all, I'm wondering if anyone knows if STATA has the functionality to do a bernanke sims decomposition when producing IRFs from VAR m...

Importance of misspecification test vs. R-sq. and consequences of xtsktest

Dear Statalist Members, I am analyzing a balanced panel of around 2400 firms over 12 years (Stata 13). The output I am able to present her...

Testing for weak instruments in 2SLS regression using robust SE (just-identified model)

Hi, I'am currently struggling to test for weak instruments when conducting a 2sls regression using robust standard errors (vce robust)...

Esport summary statistics by 5 groups

Dear all, Recfently I presented my research project to a faculty. One of the comment for improvement is related with descriptive statistic...

Generating a new variable with standardized values compared to a healthy control group mean and SD (z scores)

I'm working with crossectional test data with a selection of test results (all continuous variables) in both a patient and healthy contr...

Linear mixed effects models with random effects for subject

I have a dataset of 16 patients with 10 variables. The dependent variable is "bmizpre". It is a longitudinal study with a total of...

Unbalance panel data with gap in the timeseries

I have data of the following format where there is gap in between the time-series. Code: * Example generated by -dataex-. To install: ssc...

Stata keybindings (keyboard shortcuts) using a hammer spoon (almost perfect, except for one thing)

I've installed hammerspoon on my Mac OS. As a result, I can now use Emacs keybindings in Stata as well. It's very useful. Unfortu...

How to test coefficent difference across two group

Hi there, I have a problem in my research project, where I want to test the coefficent difference across two group, as shown by bellow pict...

Residuals as Dependent Variable - Interpretation of Coefficients?

Hi there, I try to model daily stock market trading volume with a bunch of independent variables like stock returns, stock price volatilit...

Saving a file takes forever

Hi, I have a problem with saving an appended file. I have couple of files to be appended, but it takes hours till a file saved! Sorry if my ...

Measuring Knowledge Level based on survey answers

Hi! I asked my respondents a few questions with 04 options each For example, "Which one is the largest state in area? Texas, Alask...

How to draw a twoway picture like these

How to draw a twoway picture like these, these two pictures，thanks Code: * Example generated by -dataex-. To install: ssc install dataex...

Convert SIF date to year

Hi all, Below is a few observations of my large panel data set I got after linking several data together. My question is about variable mt...

Desscriptive Statistics and Matrices

I have the code below. I want to export the result from the code below to excel and also want to add standard deviations for the two groups ...

xtreg Y X1 X2...Xn i.country, fe- Is it possible/ correct/ feasible?

Declared panel data as xtset year (instead of xtset panelid year) xtset YEAR panel variable: YEAR (balance d) . xtreg logXijt logGDPitG...

Limitation of arguments in mata

Cheers together, currently, I am trying to find the internal rate of return or cost of equity for companies over time. So I have many comp...

How to import several excels

Dear Statalist, I need to create a database using several (hundreds) of excels like the one I show below. The problem is that I do not kno...

wildcard in string variable

I'm trying to link different business locations to appropriate zip codes using a do-file. I have business names in a name variable and c...

How to organise my data, Im a beginner!

Hi I would like to know what commands to use to organise my data, I currently have a dataset with over 1000 observations and would like to...

estimating sample size for cohort studies

I am trying to compute the sample size of a cohort study, pregnant women beyond 20 weeks of gestation with normal blood pressure <130/80 ...

Counting up within ID

Hi everyone, Quick question that may be quite simple to answer but I am having trouble wrapping my head around it. Below I have pasted so...

Producting publication tables for loneway command

Dear Stata users, I computed different intraclass correlations using the loneway command. Which command can I use to produce publication-qu...

standard deviation of a variable

Hi everyone, I have a set data for 10 years. I want to calculate the standard deviation of one variable during year y-2 to y (three years) ...

Nelson aalen cumulative hazard function

Hi all! Hope you are doing good. I have a question about the Nelson aalen cumulative hazard function. I made a graph about chance of disch...

Treatment Effect in Panel Data with Many Time Periods and Various Treatment Starts

Dear Statalist, I have a question regarding the identification of a treatment effect in a large panel dataset (800.000 observations), spa...

serial/cross sectional autocorrelation and heteroscedasticity in panel data

Hello everyone, I am working with a paneldataset with N=170 and T=5. I want to test for heteroscedasticity/autocorrelation but I kind of g...

hcost: error occurred while loading hcost.ado

Good day all, i need to run a hcost command to calculate cost estimate based on censored data [ https://www.stata-journal.com/articl...art...

Hurdle model with nehurdle command in Stata 12

I am using nehurdle command in Stata 12. My dependent variable is education expenditure (consisting of many zeros), hence I am using a two p...

year dummies in xtreg and pooled OLS

Hello, I ran both a fixed effects model and pooled OLS model on the same dataset. I am now wondering if, including year dummies and thus t...

Elasticity estimates in Tobit regression

Dear Statalisters This is my first post so please excuse if the question is not posed correctly. While running a tobit regression (with ...

Help/advice on importing large number of text files into Stata

Dear all, I have a collection of around 2,400 PDFs of parliamentary debate transcriptions that I would like to import into Stata. Having f...

Tabout Error - Conformability r(3200)

Hello I am using running a series of crosstab tables using the following tabout command: Code: tabout sex v501_marital_stat_r religio...

Calculating effect sizes after MI and mixed

Hello All, I hope this message finds you well! After running the following code is there a way to calculate effect sizes? Code: mi e...

Help needed to adjust the outcome of bysort command

Dear Stata community members, I have created a count variable k and p based on the following syntax : by ID Illness (Year), sort: gen k =...

Can I select Fixed-effects model?

Dear, First of all, I really thank you everyone here sparing their efforts to help the person like me. - Fixed-effects model is proven v...

Generating summary statistics and exporting to excel

I have a table that looks like this: Country Name Country Code Series Name Series Code 2016 [YR2016] 2017 [YR2017] 2018 [YR2018] ...

How do you maintain your library of code sinppets?

This question is for anyone whose programmed for long enough to find that keeping snippets of code to hand is useful for remembering interes...

New version of -ranktest- available on SSC

With thanks to Kit Baum, a new version of ranktest by Kleibergen-Schaffer-Windmeijer, version 2.0.03, is now available on SSC Archives. T...