Median with panel data

namrata — Mon, 25 Mar 2013 01:46:03 GMT

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;

by country;

new=median(size);

run;

The error that comes up is: Statement is not valid or it is used out of proper order.

Can anybody advise about the median?

Re: Median with panel data

ArtC — Mon, 25 Mar 2013 02:13:54 GMT

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;

class country;

var size;

output out=want median= /autoname;

run;