issues with declaring my unbalanced dataset

[Saleh sharmah]

two issues with my unbalanced dateset: 1) I am investigating a firm's cost of bank loan spread an international sample and a firm can have multiple loans in a given year so when I declare my data using xtset borrower_id year, stata returns an expected error of time repetition. how can i get this issue sorted, given that i will be using lags in my regression. The second issue is that i need to know the stata code that lists the number of non-missing observations for my study key of interest variables ;a firm's Loan_spread, level disclosure, trust level, by country and year. Any help or suggestions are greatly appreciated.

[Carlo Lazzaro]

Saleh:
welcome to this forum.
1) you can simply -xtset- your panel dataset with -panelid- only, provided that you do not plan to use time-series operators, such as lags and leads in your regression;
2) if your concern is about your panel data regression, please note that Stata omits by listwise deletion all the observations with at least one missing value.

[Saleh sharmah]

Thanks for your response, Carlo. Much appreciated