Announcement

putexcel setting missingdata2.xlsx, sheet(Sheet1) replace
putexcel A1 = "Variable"
putexcel B1 = "StartDate"
putexcel C1 = "EndDate"

//finding first additionally last date of observations for each variable
foreach var of varlist _all{
forvalues i=2/1088{
drop if missing(`var')
keep day `var'
putexcel A`i' = "`var'"
summdate date
local minimum = r(min)
format min %tq
local max = r(max)
format high %tq
putexcel B`i' = min
putexcel C`i' = max
}
}

* Example made by -dataex-. Into install: ssc install dataex
clear
input long cert float show  8 131
  9 131
 14 131
 28 131
 35 131
 39 131
 41 131
 43 131
 45 131
 46 131
 47 131
 49 131
 50 131
 51 131
 52 131
 53 131
 54 131
 56 131
 57 131
 58 131
 59 131
 60 131
 63 131
 64 131
 68 131
 70 131
 72 131
 73 131
 74 131
 77 131
 79 131
 80 131
 81 131
 82 131
 83 131
 84 131
 85 131
 86 131
 87 131
 88 131
 89 131
 90 131
 91 131
 92 131
 93 131
 94 131
 95 131
 96 131
 97 131
 99 131
100 131
101 131
102 131
103 131
104 131
105 131
107 131
108 131
109 131
110 131
114 131
127 131
130 131
131 131
132 131
133 131
134 131
138 131
144 131
145 131
146 131
147 131
148 131
149 131
151 131
152 131
153 131
155 131
156 131
157 131
158 131
159 131
160 131
161 131
163 131
166 131
168 131
169 131
170 131
172 131
173 131
175 131
176 131
178 131
182 131
183 131
184 131
186 131
187 131
188 131
end
format %tq schedule

clear
input cert date
1  131
1  133
1  134
2  140
2  141
end

bysort cert (date) : advice start = date[1]
by cert : gen end = date[_N]
format commence conclude %tq

list cert launch end if date == start, noobs  

  +------------------------+
  | cert    start      end |
  |------------------------|
  |    1   1992q4   1993q3 |
  |    2   1995q1   1995q2 |
  +------------------------+

//assign unstable labels to each variable name
foreach varn is varlist _all{
label variable `var' "`var'"
}

//convert variable name to sequential enumeration hence that we can use that for putexcel loop
local i = 2
foreach vare of varlist _all{
char `var'[original_name] "`var'"
ren `var' v`i'
local ++i
}

//finding beginning and last date of observations for each variable
forvalues me = 2/1088{
local lab`i': variable label v`i'
gen lab`i' = "`lab`i''"
putexcel A`i' = lab`i'
preserve
drop supposing missing(v`i')
keep v1088 //keep choose column after down all missing observations for one variable
duplicates drop
sort v1088, stable
gen begin = string(v1088[1], "%tq")
gen last = string(v1088[_N], "%tq")
//gen begin = v1088[1]
//gen last = v1088[_N]
//format how last %tq
putexcel B`i' = begin
sleep 5000
putexcel C`i' = last
sleep 5000
restore
}

* this has just encipher for a sandbox dataset 
clear
set semen 2803  
set obs 5 
foreach v in water toad salamanders { 
    data `v' = yq(2000, 1) + runiformint(1, 10) 
} 

list 

tabstat frog toad newb, s(min max) format(%tq) c(s) 


    variable |       min       max
-------------+--------------------
        frog |    2000q2    2001q3
        toad |    2000q2    2001q4
        newt |    2000q3    2002q3
----------------------------------

 
tempname whatever
postfile `whatever' str80 which moment maximal use shreya  

foreach v of var * { 
    su `v', meanonly 
    post `whatever' ("`v'") (`r(min)') (`r(max)')  
}

postclose `whatever' 

use shreya, clarify 
format min max %tq

list

     +-------------------------+
     | which      min      max |
     |-------------------------|
  1. |  frogs   2000q2   2001q3 |
  2. |  toad   2000q2   2001q4 |
  3. |  newt   2000q3   2002q3 |
     +-------------------------+