topic Re: testing quoted code in SAS Programming

testing quoted code

reneeharper — Wed, 24 Nov 2010 16:54:03 GMT

dt << clear row states;
dt << select where( !(:PartNo == "81817" & :Month == "1/2010" & :JobID == "PROD" )) << Exclude( 1 ) << Hide( 1 );
dt << invert row selection;
result = dt << Get selected rows;
result = N Row (result);
// Code works fine up to this point

//Would like to run additional analysis only on selected rows,
// however, the following code carries our the calculation on the entire col
// instead of just the selected rows
result2 = dt << Select Where (:Name("Margin Col")<=5);
result2 = N Row (result2);

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas

Message was edited by: ForumAdmin@sas Message was edited by: ForumAdmin@sas

Re: testing quoted code

reneeharper — Wed, 24 Nov 2010 16:54:20 GMT

> dt << clear row states;
> dt << select where( !(:PartNo == "81817" & :Month ==
> "1/2010" & :JobID == "PROD" )) << Exclude( 1 ) <<
> Hide( 1 );
> dt << invert row selection;
> result = dt << Get selected rows;
> result = N Row (result);
> // Code works fine up to this point
>
>
> //Would like to run additional analysis only on
> selected rows,
> // however, the following code carries our the
> calculation on the entire col
> // instead of just the selected rows
> result2 = dt << Select Where (:Name("Margin
> Col")<=5);
> result2 = N Row (result2);

Re: testing quoted code

reneeharper — Wed, 24 Nov 2010 17:07:31 GMT

[newcode] dt << clear row states;
[newcode] dt << select where( !(:PartNo == &quote;81817" & :Month == "1/2010" [newcode] & :JobID == "PROD" )) << Exclude( 1 ) << Hide( 1 );
[newcode] dt << invert row selection;
[newcode] result = dt << Get selected rows;
[newcode] result = N Row (result);
[newcode] // Code works fine up to this point

//Would like to run additional analysis only on selected rows,
// however, the following code carries our the calculation on the entire col
// instead of just the selected rows
result2 = dt << Select Where (:Name("Margin Col")<=5);
result2 = N Row (result2); Message was edited by: ForumAdmin@sas

Re: testing quoted code

reneeharper — Wed, 24 Nov 2010 17:15:42 GMT

> [newcode] dt << clear row states;
> [newcode] dt << select where( !(:PartNo ==
> &quote;81817" & :Month == "1/2010" [newcode] &
> :JobID == "PROD" )) << Exclude( 1 ) << Hide( 1 );
> [newcode] dt << invert row selection;
> [newcode] result = dt << Get selected rows;
> [newcode] result = N Row (result);
> [newcode] // Code works fine up to this point
>
>
> //Would like to run additional analysis only on
> selected rows,
> // however, the following code carries our the
> calculation on the entire col
> // instead of just the selected rows
> result2 = dt << Select Where (:Name("Margin
> Col")<=5);
> result2 = N Row (result2);
>
> Message was edited by: ForumAdmin@sas