Using SAS Data Integration studio, when you create a summary transformation in the table options advanced tab you can add a where statement to your code automatically. Unfortunately it adds some code that makes this resolve incorrectly. Putting the following in the where statement text box: TESTFIELD = "TESTVALUE" Auto generates: %let _INPUT_options = %nrquote(WHERE = %(TESTFIELD = %"TESTVALUE%"%)); In the code, used proc tabulate data = &_INPUT (&_INPUT_options) But resolves to WHERE = (TESTFIELD = "TESTVALUE") _ 22 ERROR: Syntax error while parsing WHERE clause. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, (, *, +, -, :, INPUT, NOT, PUT, ^, ~. (Sorry if the spacing doesn't work out in the actual post, the error is under the first double qoutes mark) My question is this: Is there a way to add a function to the where statement box that would allow this quotation mark to be properly added here? Note that all functions get the preceding % when added to the where statement automatically and I have no control over that. This seems like something that should be relatively easy to fix but I haven't found a simple way yet.
... View more
