BookmarkSubscribeRSS Feed
fred777
Calcite | Level 5

blah is a character variable mostly populated with numbers in dataset fred.

 

if I do this ...

   data fred2;

      set fred;

      if sum(blah) ^= .;

   run;

 

... SAS will give me just those records which don't have just numbers in blah.

However, if I try something like this ...

   proc tabulate data=fred;

      where sum(blah) ^=.;
      .

      .

      .

   run;

... SAS complains with the error:
ERROR: Function SUM requires a numeric expression as argument 1.

Is there any way I can avoid that additional data step above and still filter on sum(blah) ^=. directly in the PROC?

1 REPLY 1
Kurt_Bremser
Super User

The DATA step code is actually compiled, and not just run from a precompiled module as in PROC steps.

Therefore the SAS datastep compiler can recognize variable type inconsistencies and compile a typecast into the code. This is what causes the NOTE: messages about type conversion in the log.

This is, of course, not possible for dataset options (the where condition in the PROC is working like a dataset option) that don't have the luxury of compilation.

So you won't get around the character-to-numeric conversion, be it explicit or implicit.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 1 reply
  • 1038 views
  • 2 likes
  • 2 in conversation