Hello, I have created a variable that will be a prompt/filter for a user to enter a value into.  I am testing that variable to see if the length is > than 0 to tell me if a value was entered and based on that, write some output.   My problem is that if I set the prompt/filter to have a value (below), the code runs fine. %LET FROM_AMT = 1; %LET TO_AMT = 500;   %LET FROM_AMT = ; %LET TO_AMT =; data FILTERS; if length(&From_Amt) > 0 AND length(&To_Amt) > 0 then do; filter_name = "Gross Receipts"; filter_from = "&from_amt"; filter_to = "&to_amt"; output; end; run;When I leave the variable blank which indicates the user has not entered a value and then test the length, I get the following error:      When I leave the variable blank which indicates the user has not entered a value and then test the length, I get the following error:  291       data FILTERS; 292            if length(&DISTRICT) > 0 then do; 293               length filter_name filter_from filter_to $50; 294               filter_name = "District"; 295               filter_from = "&DISTRICT"; 296               output; 297           end; 298           if length(&From_Amt) > 0 AND length(&To_Amt) > 0 then do;                   ______                        ______                   71                            71 ERROR 71-185: The LENGTH function call does not have enough arguments. ... View more

I am working on reports where the users may enter up to 20+ prompt filters.   What I need to do is create a work table that would included column names for 'Prompt1_ColName',  'Prompt1_Value', 'Prompt2_ColName',  'Prompt2_Value'... and so on.   I am testing the length of the prompts to check if a value has been entered.  I would like to create a work table that contains these values so I can use it for reporting.  Not sure about best way to create the work table.  I have only created tables using select queries.  In looking at using a data step, it looks like tthis is only for creating datasets.   Any direction would be greatly appreciated!!   Thanks  ... View more

I am reading a user input variable for the 2 digit abbreviation of a state.  I am testing the length of the variable to see if it is > 0 then I know the user entered a value, for example 'MD'. The variable in my title line in the report would show 'MD'.   If the user does not enter a value and it is blank, in my code I am trying to set it to the value of 'ALL'.  If this prompt is left blank then the user wants to get results for all states.   %macro BuildWhereClause; %global where_clause; %let where_clause = ; /* check prompt STATE for user entered values */ %if %length(&STATE) > 0 %then %do ; /* value entered in prompt */ %let NEW_STATE = "&STATE"; /* wrap quotes around macro variable */ %let where_clause = &where_clause AND UPCASE(t1.STATE) = UPCASE(&NEW_STATE); /* build where clause*/ %end; %else %do; %let NEW_STATE = call %symput("&STATE","ALL "); %mend; %BuildWhereClause; The code runs, however my variables have these values when I do %put to display.  It is not executing the symput to resolve the variable with correct value STATE = WARNING: Apparent invocation of macro SYMPUT not resolved. NEW_STATE = call %symput("","ALL ")  ... View more

I am trying to assign the variable of 'NEW_STATE' to the prompt value the user has entered and wrap the value in quotes to use in building my where clause.   When I try to run it, I get no results because the assignment of the variable 'NEW_STATE' is not correct.  Here is my code: %macro BuildWhereClause; %global where_clause; %let where_clause = ; /* check prompt STATE for user entered values */ %if %length(&STATE) > 0 %then %do ; %let NEW_STATE = '&STATE'; %let where_clause = &where_clause AND UPCASE(t1.STATE) = UPCASE(&NEW_STATE); %end; /* display values of demograpic prompts */ %put &STATE; %put &NEW_STATE; %put ******** where_clause is = &where_clause; %mend; %BuildWhereClause; Value of the variables from the %put statements: NC -- value of &STATE, user entered prompt. '&STATE' -- value of &NEW_STATE I need this to have the value of UPCASE('NC') ******** where_clause is = AND UPCASE(t1.STATE) = UPCASE('&STATE') This needs to be UPCASE('NC')     ... View more