st: RE: SV: RE: postfile

[Nick Cox <n.j.cox@durham.ac.uk>]

"in r" is short for "in red", which it seems is no longer documented, but should be considered equivalent to "as error". 

What doesn't "doesn't work" mean in your new question? 

Nick 
n.j.cox@durham.ac.uk 

Tomas Lind

Unfortunately I don´t understand the abrevation -in r- in your example but
when enclosing mpg in "" I display the word "mpg". In my problem the
variable prep is a string variable so I should refer to it with "". Then it
works.

New problem

I would also like to post the value of the time-window i (6, 12, 18). I
thought that should be simple but the syntax below (and different
modifications of it) doesn´t work. Why?

tempname  resul

postfile `resul'  str15 prep   time   mean lb ub    ///
                using H:\ANAL\prevalens.dta , replace 	
						
foreach i in 6 12 18 {
   foreach X of varlist   saba_L`i'  laba_L`i'  {

    preserve
    bysort idnr (`X') : keep if _n==_N    
    di " "
    di " "
    di "`X'"  					
	ci `X' , binomial    
	local  prep `X'
	local  time `i'
	local  mean    = r(mean)
	local  lb       = r(lb)		
	local  ub       = r(ub)			
    post `resul'  ("`prep'") (`time') (`mean') (`lb')  (`ub')   
 restore
    }
}	
postclose `resul'	



preserve
use H:\ANAL\prevalens.dta , replace	
list , noobs
restore				

Martin Weiss

The difference between:

*************
sysuse auto, clear
di in r mpg
di in r "mpg"
*************

makes your error clear, I think...

Tomas Lind

Below I try to post results to a dataset. Everything works fine but the
variable prep only contain 0´s. I had hoped to find the variable names
saba_L6, saba_L12, saba_L18, laba_L6, laba_L12, laba_L18 in it.

Anyone know what´s wrong with my syntax?

tempname  resul

postfile `resul'  str15 prep   mean lb ub    ///
                using H:\ANAL\prevalens.dta , replace 	
						
foreach i in 6 12 18 {
   foreach X of varlist   saba_L`i'  laba_L`i'  {

    preserve
    bysort idnr (`X') : keep if _n==_N    
    di " "
    di " "
    di "`X'"  					
	ci `X' , binomial    
	local  prep `X'
	local  mean    = r(mean)
	local  lb       = r(lb)		
	local  ub       = r(ub)			
    post `resul'  (`prep') (`mean') (`lb')  (`ub')   
 restore
    }
}	
postclose `resul'	



preserve
use H:\ANAL\prevalens.dta , replace	
list , noobs
restore				


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/