BookmarkSubscribeRSS Feed
s_manoj
Quartz | Level 8

Hi all,

I have been working on a dataset, in process of finding no of values of all variables falling outside of interquartile ranges, I ended up with two datasets one is mother dataset and other limits dataset(it contains a name, Q1, Q2, QRANGE, LOWER, UPPER VALUES).

please help me with the error generated by this code.

 Here' the code:

 

pic.JPG

 

after running above code am getting an error as;

 

ERROR: IN where clause, name column is not found in contributing tables

 

 

Please help me out with this error

 

actually, my mother dataset contains 15 variables (pressure 1 to pressure 15), for all those variables I have to find no of records falling out of interquartile range values, can someone suggest a code to check for all 15 variables.

 

Thanks 

s Manoj

4 REPLIES 4
s_manoj
Quartz | Level 8

Okay sure, thank you very much

Kurt_Bremser
Super User

@s_manoj wrote:

Hi all,

I have been working on a dataset, in process of finding no of values of all variables falling outside of interquartile ranges, I ended up with two datasets one is mother dataset and other limits dataset(it contains a name, Q1, Q2, QRANGE, LOWER, UPPER VALUES).

please help me with the error generated by this code.

 Here' the code:

 

pic.JPG 

after running above code am getting an error as;

 

pic.JPG

Please help me out with this error

 

actually, my mother dataset contains 15 variables (pressure 1 to pressure 15), for all those variables I have to find no of records falling out of interquartile range values, can someone suggest a code to check for all 15 variables.

 

Thanks 

s Manoj


And this log does not correspond to the code in any way.

SuryaKiran
Meteorite | Level 14

Your error is clear. It says your mother table doesn't contain the column "name" and your your using it in the where clause.

Please provide sample data and your desired output.

Thanks,
Suryakiran

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 4 replies
  • 1276 views
  • 1 like
  • 3 in conversation