DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 50

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

[ Edited ]

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

Super User
Posts: 10,530

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

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Contributor
Posts: 50

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

Posted in reply to KurtBremser

Okay sure, thank you very much

Super User
Posts: 10,530

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


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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
PROC Star
Posts: 618

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

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
Ask a Question
Discussion stats
  • 4 replies
  • 135 views
  • 1 like
  • 3 in conversation