Removing Zero Lines

[Doddli]

Hello!

I am a basic user of SAS and I have just worked out how to append two tables, however the data is too large to export.

I am now trying to remove and zero lines (positive and negative) using the query builder.

Can any one help??

Thanks

Linda

[PeterClemmensen]

Hi and welcome to the SAS communities 🙂 

Please define what you mean by 'zero lines'? Are these observations where some variables sum to zero or?

[Doddli]

Hello,

So effectively I need one large pivot with out the below zero lines as I am hoping by removing them, it will bring back all of my data

I have attached something to help explan

Thanks

Linda

[PeterClemmensen]

Ok. Just being curious.. Why do you want to do this in SAS? Should be fairly easy to add that filter in Excel?

[Doddli]

Hello,

The data that I am trying to manipulate is too large for Excel.  I don't have enough lines available 😞

Thanks

Linda

[PeterClemmensen]

Ok. Have you read the data into SAS then?

[Doddli]

I have yes.  Apologies if this a stupid question, I am new to SAS and I didn't know if it was possible or not

Thanks

[PeterClemmensen · Accepted solution]

No problem 🙂 Everything has a start. Use the code below and insert the appropriate data set name and variable name

data want;  
   set Yourdatasethere;
   where YourVariableHere ne 0;
run;

[Doddli]

Thanks!