Hi,
I wonder if there is a quick way to create a missingness percentage table for each of the series (alpha and numeric) in a workfile? If it can be presented as a table, it is even better.
For missingness percentage, I mean, for alpha series, the blank cell number/total sample; and for numeric, the NA cell number/total sample.
Thanks in advance!
Best,
BC
HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES
You'd need to write a program that does it.
@wlookup to find the names of all the series in the workfile.
Loop through them calculating series.@obs/@obsrange and storing in a table.
@wlookup to find the names of all the series in the workfile.
Loop through them calculating series.@obs/@obsrange and storing in a table.
Follow us on Twitter @IHSEViews
Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES
thanks for the quick response Gareth!
Can you give more detail on the codes on how to store each number in a table?
Thanks!
Can you give more detail on the codes on how to store each number in a table?
Thanks!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13319
- Joined: Tue Sep 16, 2008 5:38 pm
Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES
Code: Select all
Table a
A(1,1)=x.@obs/obsrange
Follow us on Twitter @IHSEViews
Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES
Thank you Gareth!
Who is online
Users browsing this forum: No registered users and 25 guests