Help using Base SAS procedures

Median with panel data

Reply
Contributor
Posts: 52

Median with panel data

Hi

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?

Valued Guide
Posts: 634

Re: Median with panel data

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;

Ask a Question
Discussion stats
  • 1 reply
  • 214 views
  • 0 likes
  • 2 in conversation