order .freq by count

[CharlieEVIEWS]

Dear All,

Is it possible to order the series.freq (one way tabulation) by count rather than alphabetically by alpha name?

Thanks!

Charlie

[EViews Gareth]

No :(

[CharlieEVIEWS]

now it is possible:

Code: Select all

subroutine frequencytab(alpha inputalpha) freeze(inputalpha_tab) inputalpha.freq(nocum,nolimit) !numberunique=@rows(@uniquevals(inputalpha)) wfcreate(wf=frequencytabulated) u !numberunique copy alldatasets::inputalpha_tab frequencytabulated::inputalpha_tab alpha uniquevalues = "" genr uniquevaluefreq = NA for !y = 1 to !numberunique uniquevalues(!y) = inputalpha_tab(7+!y,1) uniquevaluefreq(!y) =@val(inputalpha_tab(7+!y,2)) next group tabber uniquevaluefreq uniquevalues tabber.sort(-1) freeze(freqtab) tabber copy frequencytabulated::freqtab alldatasets::freqtab freqtab.deletecol(a) 1 wfclose frequencytabulated d inputalpha_tab endsub

[CharlieEVIEWS]

Better to endogenously pull out the wf name - cleaner:

Code: Select all

subroutine frequencytab(alpha inputalpha) %wfnameholder = @wfname freeze(inputalpha_tab) inputalpha.freq(nocum,nolimit) !numberunique=@rows(@uniquevals(inputalpha)) wfcreate(wf=frequencytabulated) u !numberunique copy {%wfnameholder}::inputalpha_tab frequencytabulated::inputalpha_tab alpha uniquevalues = "" genr uniquevaluefreq = NA for !y = 1 to !numberunique uniquevalues(!y) = inputalpha_tab(7+!y,1) uniquevaluefreq(!y) =@val(inputalpha_tab(7+!y,2)) next group tabber uniquevaluefreq uniquevalues tabber.sort(-1) freeze(freqtab) tabber copy frequencytabulated::freqtab {%wfnameholder}::freqtab wfclose frequencytabulated d inputalpha_tab endsub