Pool Regression
Posted: Wed Jan 30, 2013 12:27 pm
Hi, I am hoping to get a some help with syntax. I am unsure why my program is not working as I would like.
Below is the program, and of course I have the file path where I have noted location. The problem comes when I get to my step 3. I get an undefined variable error.
Can you spot anything right away or do you need more info?
Many thanks for any help.
Best,
Zach Sears
______________________
mode quiet
'Step1. Open and structure the data file CE_data
wfopen "location"
pageselect data
pagestruct country @date(year)
pageunstack(namepat="*_?", page=unstacked) country @date @ *
'Step 2. Create a pool called geo, kept in another program file, pool appears to be created successfully
pageselect unstacked
include "location"
'Step 3. Preliminary calculations
'THIS is the problem - it does not recognize the variables in the pool
'total retail spending per person per day, nominal and real
geo.genr retppd_?=(retexp_?/nights_?)/arr_?
geo.genr realretppd_?=retppd_?/(cpi_gbr/100)
stop
Below is the program, and of course I have the file path where I have noted location. The problem comes when I get to my step 3. I get an undefined variable error.
Can you spot anything right away or do you need more info?
Many thanks for any help.
Best,
Zach Sears
______________________
mode quiet
'Step1. Open and structure the data file CE_data
wfopen "location"
pageselect data
pagestruct country @date(year)
pageunstack(namepat="*_?", page=unstacked) country @date @ *
'Step 2. Create a pool called geo, kept in another program file, pool appears to be created successfully
pageselect unstacked
include "location"
'Step 3. Preliminary calculations
'THIS is the problem - it does not recognize the variables in the pool
'total retail spending per person per day, nominal and real
geo.genr retppd_?=(retexp_?/nights_?)/arr_?
geo.genr realretppd_?=retppd_?/(cpi_gbr/100)
stop