Solved: how to delete zero and negative value from a column

Jahanzaib · Posted 06-17-2016 01:00 AM

how i can delete zero values and negative values from a column in a data. Thanks.

user24feb · Posted 06-17-2016 01:35 AM

For example:

Data A (Where=(X gt 0));
  Do i=1 To 100;
    X=Round(Rannor(1)-0.5,0.1);
	Output; 
  End;
Run;

user24feb · Posted 06-17-2016 01:35 AM

For example:

Data A (Where=(X gt 0));
  Do i=1 To 100;
    X=Round(Rannor(1)-0.5,0.1);
	Output; 
  End;
Run;

drb4511 · Posted 06-18-2016 11:00 AM

Wouldn't this just delete those observations instead of just the values for that observation in the column? Why not something like:

if var1 <= 0 then var1 = .;

Can you explain the difference for answering the original post?

how to delete zero and negative value from a column