Resources

Getting Started Example for PROC MODEL

/*--------------------------------------------------------------

                    SAS Sample Library

        Name: modgs.sas
 Description: Example program from SAS/ETS User's Guide,
              The MODEL Procedure
       Title: Getting Started Example for PROC MODEL
     Product: SAS/ETS Software
        Keys: nonlinear simultaneous equation models
        PROC: MODEL
       Notes:

--------------------------------------------------------------*/

proc model data=sashelp.citimon;
   lhur = 1/(a * ip + b) + c;
   fit lhur;
run;

title1 'Supply-Demand Model Using General-Form Equations';
proc model data=sashelp.citimon;
   endogenous eegp eec;
   exogenous exvus cciutc;
   parameters a1 a2 b1 b2 b3 ;
   label eegp   = 'Gasoline Retail Price'
         eec    = 'Energy Consumption'
         cciutc = 'Consumer Debt';

   /* -------- Supply equation ------------- */
   eq.supply = eec - (a1 + a2 * eegp);

   /* -------- Demand equation ------------- */
   eq.demand = eec - (b1 + b2 * eegp + b3 * cciutc);

   /* -------- Instrumental variables -------*/
   lageegp = lag(eegp); lag2eegp=lag2(eegp);

   /* -------- Estimate parameters --------- */
   fit supply demand / n3sls fsrsq;
   instruments _EXOG_ lageegp lag2eegp;
run;

title1 'Supply-Demand Model Using General-Form Equations';
proc model data=sashelp.citimon(where=(eec ne .));
   endogenous eegp eec;
   exogenous exvus cciutc;
   parameters a1 a2 a3 b1 b2 ;
   label eegp   = 'Gasoline Retail Price'
         eec    = 'Energy Consumption'
         cciutc = 'Consumer Debt';

   /* -------- Supply equation ------------- */
   eq.supply = eec - (a1 + a2 * eegp);

   /* -------- Demand equation ------------- */
   eq.demand = eec - (b1 + b2 * eegp  + b3 * cciutc);

   /* -------- Instrumental variables -------*/
   lageegp = lag(eegp); lag2eegp=lag2(eegp);

   /* -------- Estimate parameters --------- */
   instruments _EXOG_ lageegp lag2eegp;
   fit supply demand / n3sls ;
   solve eegp eec / out=equilib;
run;

   title1;

title1 'Solving a Simultaneous System';
data test;
   input a b @@;
datalines;
  0 1   1 1   1 2
;

proc model data=test;
   eq.sqrt      = sqrt(x) - y;
   eq.hyperbola = a + b / x - y;
   solve x y / solveprint;
   id a b;
run;

proc model outmodel=supdem;
   endogenous eegp eec;
   exogenous exvus cciutc;
   parameters a1 a2 b1 b2 b3 ;
   label eegp   = 'Gasoline Retail Price'
         eec    = 'Energy Consumption'
         cciutc = 'Consumer Debt';

   /* -------- Supply equation ------------- */
   eq.supply = eec - (a1 + a2 * eegp );

   /* -------- Demand equation ------------- */
   eq.demand = eec - (b1 + b2 * eegp + b3 * cciutc);
quit;

proc model data=sashelp.citimon model=supdem outmodel=supdem;
   /* -------- Instrumental variables ------ */
   lageegp = lag(eegp); lag2eegp=lag2(eegp);
   /* -------- Estimate parameters --------- */
   instruments _EXOG_ lageegp lag2eegp;
   fit supply demand / n3sls;
quit;

proc model data=sashelp.citimon(where=(eec ne .)) model=supdem;
   solve eegp eec / out=equilib;
quit;

title 'EXCHANGE Data';
data exchange ;
   input yr rate_jp rate_wg imn_jp imn_wg emp_us emp_jp emp_wg
            prod_us / prod_jp prod_wg cpi_us cpi_jp cpi_wg;
   im_jp = imn_jp/cpi_us;
   im_wg = imn_wg/cpi_us;
   ius = 100*(cpi_us-(lag(cpi_us)))/(lag(cpi_us));
   ijp = 100*(cpi_jp-(lag(cpi_jp)))/(lag(cpi_jp));
   iwg = 100*(cpi_wg-(lag(cpi_wg)))/(lag(cpi_wg));
   di_jp = ius - ijp;
   di_wg = ius - iwg;
datalines;
1974    .     .      .      .    .     .     .     .
        .     .   .493  .590  .672
1975 295.78 2.4613 11425  5410  93.0  99.8 103.3  93.5
      84.0  89.3  .538  .660  .712
1976 296.45 2.5184 15504  5592  96.4 100.8 100.8  97.1
      95.6  94.9  .569  .721  .742
1977 268.62 2.3236 18550  7238 100.0 100.0 100.0 100.0
     100.0 100.0  .606  .780  .769
1978 210.38 2.0096 24458  9962 104.2  98.9  99.4 100.9
     106.8 103.8  .652  .813  .790
1979 219.02 1.8342 26248 10955 107.1  98.1  99.8 101.5
     117.4 108.9  .726  .843  .823
1980 226.63 1.8175 30714 11693 103.3 101.3 100.4 101.7
     125.4 109.8  .824  .909  .868
1981 220.63 2.2631 37612 11379 102.8 102.2  97.9 104.6
     126.3 112.8  .909  .954  .922
1982 249.06 2.4280 37744 11975  95.8 101.4  95.0 107.1
     146.8 113.3  .965  .980  .970
1983 237.55 2.5539 41183 12695  94.4 103.4  91.1 111.6
     152.8 116.8  .996  .999 1.003
1984 237.45 2.8454 57135 16996  99.0 105.8  90.4 118.5
     152.2 124.7 1.039 1.021 1.027
1985 238.47 2.9419 68783 20239  98.1 107.6  91.3 124.2
     161.1 128.5 1.076 1.042 1.048
1986 168.35 2.1704 81911 25124  96.8 107.3  92.7 128.8
     163.8 130.7 1.096 1.049 1.047
1987 144.60 1.7981 84575 27069  97.1 106.1  92.8 132.0
     176.5 129.9 1.136 1.050 1.049
1988 128.17 1.7569 89802 26503  99.6 108.8  92.7 136.2
     190.0 135.9 1.183 1.057 1.063
;

          /* data for simulation */
data whatif;
   input yr rate_jp rate_wg imn_jp imn_wg emp_us emp_jp emp_wg
   prod_us / prod_jp prod_wg cpi_us cpi_jp cpi_wg;
   label cpi_us = 'US CPI 1982-1984 = 100'
         cpi_jp = 'JP CPI 1982-1984 = 100'
         cpi_wg = 'WG CPI 1982-1984 = 100';
   im_jp = imn_jp/cpi_us;
   im_wg = imn_wg/cpi_us;
   ius = 100*(cpi_us-(lag(cpi_us)))/(lag(cpi_us));
   ijp = 100*(cpi_jp-(lag(cpi_jp)))/(lag(cpi_jp));
   iwg = 100*(cpi_wg-(lag(cpi_wg)))/(lag(cpi_wg));
   di_jp = ius - ijp;
   di_wg = ius - iwg;
datalines;
1980 226.63 1.8175 30714 11693 103.3 101.3 100.4 101.7
     125.4 109.8  .824  .909  .868
1981 220.63 2.2631 35000 11000 102.8 102.2  97.9 104.6
     126.3 112.8  .909  .954  .922
1982 249.06 2.4280 40000 12000  95.8 101.4  95.0 107.1
     146.8 113.3  .965  .980  .970
1983 237.55 2.5539 45000 13100  94.4 103.4  91.1 111.6
     152.8 116.8  .996  .999 1.003
1984 237.45 2.8454 50000 14300  99.0 105.8  90.4 118.5
     152.2 124.7 1.039 1.021 1.027
1985 238.47 2.9419 55000 15600  98.1 107.6  91.3 124.2
     161.1 128.5 1.076 1.042 1.048
1986    .      .   60000 17000  96.8 107.3  92.7 128.8
     163.8 130.7 1.096 1.049 1.047
1987    .      .   65000 18500  97.1 106.1  92.8 132.0
     176.5 129.9 1.136 1.050 1.049
1988    .      .   70000 20000  99.6 108.8  92.7 136.2
     190.0 135.9 1.183 1.057 1.063
;

proc model data=exchange;
   endo im_jp im_wg;
   exo di_jp di_wg;
   parms a1 a2 b1 b2 c1 c2;
   label rate_jp = 'Exchange Rate of Yen/$'
         rate_wg = 'Exchange Rate of Gm/$'
         im_jp = 'Imports to US from Japan in 1984 $'
         im_wg = 'Imports to US from WG in 1984 $'
         di_jp = 'Difference in Inflation Rates US-JP'
         di_wg = 'Difference in Inflation Rates US-WG';

   rate_jp = a1 + b1*im_jp + c1*di_jp;
   rate_wg = a2 + b2*im_wg + c2*di_wg;

            /* Fit the EXCHANGE data */
   fit rate_jp rate_wg / sur outest=xch_est outcov outs=s;

            /* Solve using the WHATIF data set */
   solve rate_jp rate_wg / data=whatif estdata=xch_est sdata=s
          random=100 seed=123 out=monte forecast;
   id yr;
   range yr=1986;
run;

proc sort data=monte;
   by yr;
run;

proc univariate data=monte noprint;
   by yr;
   var rate_jp rate_wg;
   output out=bounds mean=mean p5=p5 p95=p95;
run;

title "Monte Carlo Generated Confidence Intervals on a Forecast";
proc sgplot data=bounds noautolegend;
  series x=yr y=mean / markers;
  series x=yr y=p5 / markers;
  series x=yr y=p95 / markers;
run;