Hi everyone,
Suppose a variable y, with 100 obs, ranked by id (1 to 100). And among these obs, only one have a value of 1, and others were 0.
How can I get the row number of the cell have a value of 1? Or how can I impute all of cells before the cell with value of 1?
Thanks
Best regards
Chang
Related Posts with Get the row number of a cell
Managing dates for Panel dataDear All, I have a monthly stock market for 4 countries(Country ID). When I am trying to change the …
Changing the level of significance in CorrelationDear all, I would like to get an excel output related to correlation analysis. I ran the following c…
Average (Mean) of previous quartersHello everyone, I have the following problem with my unbalanced monthly panel data, where "permno" …
Exporting tabulation from stata to excel including a column with and another without value labelsHi All, I'd like to export a simple descriptive frequency table from stata to excel. My variable is…
Generating random numbers without seedHi, I have an Excel template file that I want to fill with data generated by Stata 16. As I want to…
Subscribe to:
Post Comments (Atom)
0 Response to Get the row number of a cell
Post a Comment