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!

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 2475 views
  • 4 likes
  • 4 in conversation