Hi,

The variable (acc) in my data is the Pearson correlation coefficients. However, I would like to convert it into fractional rankings first before running the regression.

Any idea on how to do this? Thanks for your help in advance!


----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long(datadate gvkey) float acc
19930531 1004 -.99796
19940531 1004 -.95547
19950531 1004 -.95281
19960531 1004 -.94955
19970531 1004 -.97768
19980531 1004 -.96598
19990531 1004 -.98946
20000531 1004 -.98602
20010531 1004 -.97624
20020531 1004 -.93123
20030531 1004 -.92821
20040531 1004 -.91344
20050531 1004 -.94238
20060531 1004 -.91909
20070531 1004 -.98228
20080531 1004 -.99848
20090531 1004 -.99066
20100531 1004 -.98199
20110531 1004 -.95365
20120531 1004 -.98807
20130531 1004  -.9868
20140531 1004  -.9899
20150531 1004 -.78608
20160531 1004 -.68137
20170531 1004 -.79858
19931031 1009 -.95734
19941031 1009 -.95719
19931231 1010  .94513
19941231 1010  .93538
19951231 1010  .83761
19961231 1010  .67099
19971231 1010  .16011
19981231 1010  .23028
19991231 1010  .10039
20001231 1010 -.17454
20011231 1010 -.09625
20021231 1010 -.95842
20031231 1010 -.99766
19931031 1013 -.95824
19941031 1013 -.95132
19951031 1013 -.84534
19961031 1013 -.92933
19971031 1013 -.97716
19981031 1013 -.99013
19991031 1013 -.91973
20001031 1013 -.85348
20011031 1013 -.86472
20021031 1013 -.97408
20031031 1013 -.75249
20041031 1013 -.72238
20051031 1013 -.45377
20061031 1013  .54297
20071031 1013 -.06464
20081031 1013 -.73175
20090930 1013 -.75436
20100930 1013 -.12667
19930228 1017 -.68844
19940228 1017 -.54713
19950228 1017 -.57304
19931231 1019 -.99765
19941231 1019 -.99898
19951231 1019 -.99859
19961231 1019 -.99886
19971231 1019 -.99944
19981231 1019 -.99846
19991231 1019 -.99338
20001231 1019 -.99887
20011231 1019  -.9994
19930630 1021 -.98667
19940630 1021 -.72577
19950630 1021 -.07526
19960630 1021 -.31636
19970630 1021 -.55368
19980630 1021  -.5896
19990630 1021 -.67546
20000630 1021 -.93412
20010630 1021 -.96584
20020630 1021 -.95801
20030630 1021 -.97561
20040630 1021 -.97936
20050630 1021 -.98395
20060630 1021 -.96434
20070630 1021 -.95539
20080630 1021 -.94336
19930228 1025 -.99679
19940228 1025 -.99718
19950228 1025 -.98847
19960229 1025   -.979
19930930 1033 -.62743
19931231 1034 -.98435
19941231 1034 -.96998
19951231 1034 -.94169
19961231 1034 -.63826
19971231 1034 -.88514
19981231 1034 -.90947
19991231 1034 -.96136
20001231 1034 -.97173
20011231 1034 -.94989
20021231 1034 -.96868
20031231 1034  -.9825
end
------------------ copy up to and including the previous line ------------------