cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Amalik
Calcite | Level 5 Amalik
Calcite | Level 5

REMOVING PANELS WITH MISSING DATA TO CREATE BALANCED DATA

Posted 10-25-2017 08:43 PM (832 views)

Hi,

I want to covert my data into balanced panel by removing id's with missing values. Can someone guide me with this?

 

datasheet is attached for reference.

 

0 Likes
Reply
1 REPLY 1
ChrisNZ
Tourmaline | Level 20 ChrisNZ
Tourmaline | Level 20

Re: REMOVING PANELS WITH MISSING DATA TO CREATE BALANCED DATA

Posted 10-26-2017 12:39 AM (799 views)  |   In reply to Amalik

No MS Office files please. Many people are reluctant or forbidden to download them due to the nasty payloads they can carry.

 

Describe your problem better. Why can't you use  where not missing(ID) ?

0 Likes
Reply

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • ‎10-25-2017 08:43 PM
  • 833 views
  • 0 likes
  • 2 in conversation