turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- Analytics
- /
- Stat Procs
- /
- proc panel

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

04-18-2012 04:38 PM

Hi,

I am using proc panel to do some analysis.

(

proc panel outest=parms data = comgasfinal2 ;

id pa year;

model cngc_fs = time1 gasprice gsp1 hddcon scgc sdgec pgep1 scgp1 sdgep1/ rantwo parks;

output out=panelout p=forecast;

run;

)

I am not sure if its me or it's the procedure but I am not able to forecast the future values of the dependent variable. Procedures like proc reg allow automatic calculation of the future values of the dependent variable. Is this a limitation of proc panel? If so, is there a macro that I can use to automatically generate the final equation for the parameters estimated by proc panel?

Ravi

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to ravi101

04-18-2012 04:54 PM

Says in the doc :

If there are observations in the input data set with missing dependent

variable values but with nonmissing regressors, PROC PANEL can compute predicted

values and store them in an output data set by using the OUTPUT statement. Note

that the presence of such observations with missing dependent variable values

does not affect the model fit because these observations are excluded from the

calculation.

So, all you need is some observations with the independent variable values for which you want predictions.

PG

PG

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to PGStats

04-18-2012 05:00 PM

I have tried that but I get a error message saying you can't have any missing values in the dependent variable. Where did you read that it is ok to have missing values in the dependent variable?

Ravi

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to ravi101

04-18-2012 05:12 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

Posted in reply to PGStats

04-18-2012 05:22 PM

Yes, wow it does say that but I get this is error when I include the missing values for the dependent variable and non missing values for the independent variables.

ERROR: Each observation for time point year=2011 has a missing value for at

least one variable in MODEL statement .

NOTE: The SAS System stopped processing this step because of errors.