https://communities.sas.com/t5/SAS-Programming/REMOVING-PANELS-WITH-MISSING-DATA-TO-CREATE-BALANCED-DATA/m-p/407537#M99332 <P>No MS Office files please. Many people are reluctant or forbidden to download them due to the&nbsp;nasty payloads they can carry.</P> <P>&nbsp;</P> <P>Describe your problem better. Why can't you use&nbsp; <FONT face="courier new,courier">where not missing(ID)&nbsp;</FONT>?</P> Thu, 26 Oct 2017 04:39:13 GMT ChrisNZ 2017-10-26T04:39:13Z https://communities.sas.com/t5/SAS-Programming/REMOVING-PANELS-WITH-MISSING-DATA-TO-CREATE-BALANCED-DATA/m-p/407511#M99325 <P>Hi,</P><P>I want to covert my data into balanced panel by removing id's with missing values. Can someone guide me with this?</P><P>&nbsp;</P><P>datasheet is attached for reference.</P><P>&nbsp;</P> Thu, 26 Oct 2017 00:43:23 GMT https://communities.sas.com/t5/SAS-Programming/REMOVING-PANELS-WITH-MISSING-DATA-TO-CREATE-BALANCED-DATA/m-p/407511#M99325 Amalik 2017-10-26T00:43:23Z https://communities.sas.com/t5/SAS-Programming/REMOVING-PANELS-WITH-MISSING-DATA-TO-CREATE-BALANCED-DATA/m-p/407537#M99332 <P>No MS Office files please. Many people are reluctant or forbidden to download them due to the&nbsp;nasty payloads they can carry.</P> <P>&nbsp;</P> <P>Describe your problem better. Why can't you use&nbsp; <FONT face="courier new,courier">where not missing(ID)&nbsp;</FONT>?</P> Thu, 26 Oct 2017 04:39:13 GMT https://communities.sas.com/t5/SAS-Programming/REMOVING-PANELS-WITH-MISSING-DATA-TO-CREATE-BALANCED-DATA/m-p/407537#M99332 ChrisNZ 2017-10-26T04:39:13Z