Matrix Manipulation/Sorting

[Dave_the_Forecaster]

Hi,

I have a large matrix (at least 10k rows) which contains multiple rows populated with NAs. I want to export this matrix to Excel without the NAs (I'm working with file size restrictions).

My initial idea was to simply sort the matrix by any of the columns, thus gathering all the NAs at either the top or bottom, then it's a simple step to only copy the non-NA rows.

However! Matrix sorting is performed element-wise and so is not appropriate. I thought of freezing the matrix as a table but then remembered that tables cannot be sorted either. I don't want to convert the matrix to a group because of the large number of rows, and I'd like to avoid having to separate the matrix into individual columns, sorting individually then re-combining.

Can anyone offer a way to do this that results in me maintaining my sanity? Maybe there is a matrix funtion that was accidentally missed from the help manual?

Thanks,
Dave

P.S. I'm using Eviews 7.1 - would this problem be much easier to solve if I upgraded to Eviews 8?

[EViews Gareth]

I think converting to a group is the only way to go.