03-24-2013 09:46 PM
I need to find the median of the size variable for each country in my panel dataset and create a dummy variable:1 for values >median and 0 otherwise.
I read and also realised while doing,that the median function does not work using Proc SQL.So,I tried the simple Proc Panel command:
Having sorted the data by country,firm and year,I used the following steps:
proc panel data=have;
The error that comes up is: Statement is not valid or it is used out of proper order.
Can anybody advise about the median?
03-24-2013 10:13 PM
Although I have not used PROC PANEL, I do not believe that that it supports programming statements.
You can calculate the median of a variable using other procedures. Most likely for your needs will be either MEANS or SUMMARY.
proc summary data=have;
output out=want median= /autoname;