how i can delete zero values and negative values from a column in a data. Thanks.
For example:
Data A (Where=(X gt 0));
Do i=1 To 100;
X=Round(Rannor(1)-0.5,0.1);
Output;
End;
Run;
For example:
Data A (Where=(X gt 0));
Do i=1 To 100;
X=Round(Rannor(1)-0.5,0.1);
Output;
End;
Run;
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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.