BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jahanzaib
Quartz | Level 8

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

1 ACCEPTED SOLUTION

Accepted Solutions
user24feb
Barite | Level 11

For example:

 

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

View solution in original post

2 REPLIES 2
user24feb
Barite | Level 11

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
Obsidian | Level 7

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 Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2710 views
  • 1 like
  • 3 in conversation