Formation of Portfolios Using Deciles

[MoeezQureshi]

Hello,
I have Data on stock lending fees and i want to form portfolios using Deciles. So i have a Multi-Series data on about 600 companies but i cant categorize data into deciles. can you please let me know how can i do that using Eviews 7 or 6. I have access to both of the versions.

Regards,
MoizQureshi

[EViews Glenn]

Can you be a bit more specific about the exact operation you are trying to do? Are the deciles computed across all firms or within each firm?

[MoeezQureshi]

Dear Glenn,
I want to compute the decile across all the firms for their Stock Lending Fees

[EViews Glenn]

Is the workfile structured as a panel or a flat file.

[MoeezQureshi]

Its a Panel Workfile

[EViews Glenn]

If you have a series you wish to categorize into deciles, you may use the Generate by classification proc to perform the desired operation. Select Proc/Generate by classification..., change the Method to Quantile Values, and enter 10 as the number of quantiles. EViews will create a new series with the classifications indicating which decile the series observation was in. Note that this routine works in this setting since you want to classify your observations on the basis of the series irrespective of the cross-section identifier. If you want to do this by cross section, it's a bit more difficult.

[MoeezQureshi]

Well i know this function but this doesn't help with my data. Ok i will try to explain a little more the problem that i have.

I have an Excel File with the First Column As Date, and from that onwards its the different companies with their respective SL Fees, say

DATE HONDA TOYOTA FORD DAIMLER VOLKSWAGEN
01/01 11 11 21 32 44
02/01 12 12 26 29 42
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .

This is how the data looks and i want to divide this into deciles, and i have been unable to do so..

[EViews Glenn]

So when you say that you have a panel workfile, what is the cross-section identifier?

[MoeezQureshi]

Well i am going to send you my excel file and maybe you can see how it can be done.
It's part of the data and I am sorry i can't be sending the whole data.

[EViews Glenn]

Given the Excel sheet (ands I suspected from your previous post), it looks as though your workfile is not panel structured. Instead, you are working with the data in unstacked (pool) form.

What you should do is to use the Proc/Reshape Current Page workfile procedure to stack the data into a panel structured page/workfile. Then my previous suggestion will compute the quantiles for you across all of the cross-sections.