topic Re: Removing Zero Lines in SAS Programming

Removing Zero Lines

Doddli — Sat, 11 May 2019 13:07:52 GMT

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 — Sat, 11 May 2019 13:09:58 GMT

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 — Sat, 11 May 2019 13:14:26 GMT

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 — Sat, 11 May 2019 13:22:52 GMT

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

Doddli — Sat, 11 May 2019 13:24:52 GMT

Hello,

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

Thanks

Linda

PeterClemmensen — Sat, 11 May 2019 13:29:08 GMT

Ok. Have you read the data into SAS then?

Doddli — Sat, 11 May 2019 13:35:53 GMT

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 — Sat, 11 May 2019 13:40:54 GMT

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 — Sat, 11 May 2019 14:33:34 GMT

Thanks!