rescale between 0 and 1 using eviews

[hend elgamiel]

hi, i want rank firms into deciles based on cash balance and leverage and then ,i want rescale The two groups of ranked
to range between zero and one, respectively. how can do it step by step using eviews (how can rank firms into deciles based on cash and leverage and rescale between 0 and 1). my data in panel form.

[EViews Gareth]

Need a lot more information on the structure of your data and exactly how you want to do the ranking.

[hend elgamiel]

1) my data is panel data, time seies from 2000 to 2016 for firms 90 firms. unbalanced data number of observation almost 1200 .
2) first , i want rank firms into deciles based on their cash balance and their leverage .and re-scale them to range
between zero and one.then create a composite score measure, OverFirm, which is computed as the average of ranked values of the two partitions variables.
3) i want perform it using eviews . can help me step by step.
4) any information you need it ask me. thank you

[EViews Gareth]

How does time fit in to 2)?

[hend elgamiel]

plz explain more what did you mean How does time fit in to 2)?

[EViews Gareth]

To create a rank for a firm, you need 1 observation for that firm. You have 17 observations per firm. So you need to reduce those 17 years to a single observation, or you create 17 ranks for each firm.

[hend elgamiel]

i want create 17 ranks for each firm.

[EViews Gareth]

In a program:

Code: Select all

for !i=0 to 16 smpl @first+!i @first+!i series ranks = @ranks(x) next

[hend elgamiel]

i tried many times and syntex error . this my data plz learn me how rank into deciles and rescale between 0 and 1

[EViews Gareth]

Post your EViews file.

[hend elgamiel]

my workfile and data

[EViews Gareth]

Code: Select all

for !i=0 to 15 smpl @first+!i @first+!i series ranks = @ranks(CASH_IN_FUTURE) next

[hend elgamiel]

plz explain step by step how to perform these commands
smpl @first+!i @first+!i
series ranks = @ranks(CASH_IN_FUTURE)

[EViews Gareth]

File->New Program.

Copy and paste the code.

Click Run.

[hend elgamiel]

i tried many time and the programe say " Error in Sample: !I is not defined in "SMPL @FIRST+!I
@FIRST+!I".
plz give me steps with more explanations