topic how to delete zero and negative value from a column in SAS Programming

how to delete zero and negative value from a column

Jahanzaib — Fri, 17 Jun 2016 05:00:49 GMT

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

user24feb — Fri, 17 Jun 2016 05:35:05 GMT

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 — Sat, 18 Jun 2016 15:00:03 GMT

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?