topic Re: Help me with error in this code symget, sympute for interquartile ranges in SAS Programming

Help me with error in this code symget, sympute for interquartile ranges

s_manoj — Mon, 05 Mar 2018 15:17:07 GMT

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:

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

Re: Help me with error in this code symget, sympute for interquartile ranges

Kurt_Bremser — Mon, 05 Mar 2018 14:49:32 GMT

Please, do NEVER post pictures of code or log, which are both pure text. Post code and logs in the appropriate subwindows, as described in https://communities.sas.com/t5/help/faqpage/faq-category-id/posting?nobounce

Re: Help me with error in this code symget, sympute for interquartile ranges

Kurt_Bremser — Mon, 05 Mar 2018 14:50:32 GMT

@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:

after running above code am getting an error as;

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.

Re: Help me with error in this code symget, sympute for interquartile ranges

s_manoj — Mon, 05 Mar 2018 15:18:04 GMT

Okay sure, thank you very much

Re: Help me with error in this code symget, sympute for interquartile ranges

SuryaKiran — Mon, 05 Mar 2018 16:22:45 GMT

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.