topic SAS Enterprise Alpha Numeric Prompt Error in SAS Enterprise Guide

SAS Enterprise Alpha Numeric Prompt Error

ElJuancho — Thu, 19 May 2022 17:07:11 GMT

I'm getting the error below when trying to use a text defined prompt variable is SAS EG and Stored Process. I tried a few methods to make the value usable but no luck so far. Any suggestion on how to fix this issue?

Prompt/variable Assignment

%let STRUCTURE = 4451227E;

143              WHERE t1.OVRHD_STRCTUR_NO IN (&Structure)
NOTE: Line generated by the macro variable "STRUCTURE".                                                                                          The SAS System

143        4747487E
                  _
                  22
                  202
ERROR 22-322: Syntax error, expecting one of the following: a numeric constant, a datetime constant, a missing value, ), ',', -, :.  
ERROR 202-322: The option or parameter is not recognized and will be ignored.

Re: SAS Enterprise Alpha Numeric Prompt Error

ballardw — Thu, 19 May 2022 17:31:10 GMT

Since your use of &Structure is not enclosed in quotes then it is not treated as a character value.

Try

 WHERE t1.OVRHD_STRCTUR_NO IN ("&Structure")

so the prompt is treated as text.

Re: SAS Enterprise Alpha Numeric Prompt Error

ElJuancho — Thu, 19 May 2022 17:40:33 GMT

That was an easy fix.

Thanks a lot.