HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator

bcchen
Posts: 31
Joined: Tue May 02, 2017 8:34 am

HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

Postby bcchen » Thu Jun 01, 2017 4:26 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

Postby EViews Gareth » Thu Jun 01, 2017 4:31 pm

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.
Follow us on Twitter @IHSEViews

bcchen
Posts: 31
Joined: Tue May 02, 2017 8:34 am

Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

Postby bcchen » Thu Jun 01, 2017 4:52 pm

thanks for the quick response Gareth!

Can you give more detail on the codes on how to store each number in a table?

Thanks!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13305
Joined: Tue Sep 16, 2008 5:38 pm

Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

Postby EViews Gareth » Thu Jun 01, 2017 9:05 pm

Code: Select all

Table a
A(1,1)=x.@obs/obsrange
Follow us on Twitter @IHSEViews

bcchen
Posts: 31
Joined: Tue May 02, 2017 8:34 am

Re: HOW TO GET MISSINGNESS PERCENTAGE OF EACH SERIES

Postby bcchen » Fri Jun 02, 2017 7:56 am

Thank you Gareth!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 20 guests