BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
jdr1
Obsidian | Level 7
Can't get it to work, what am I doing wrong:
ods output Estimates = estimate20 (where= MeanEstimate ne .); * (where label not like 'Exp%');
*ods exclude where = (_Label_ = "Exp(Beta T3hot_mod") ;
Reeza
Super User
Do you get an error message of any kind?

Your WHERE statement should be formatted as follows, note the additional brackets which may be the problem. The log would likely indicate that though. You could also have a variable mismatch issue, . is for numeric missing which is why I recommend using the MISSING() function which is the same for either character or numeric variables not checking for the a period.

(where= (label not like 'Exp%'));
jdr1
Obsidian | Level 7

My format for the where statement wasn't correct, I went back and used your suggestion "(where= (label not like 'Exp%'));" and it worked perfectly. THANK YOU again for your help. I really didn't want to still cut and paste my output. Really grateful for your help!

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 17 replies
  • 2703 views
  • 4 likes
  • 4 in conversation