I am attempting to create a multiple value text prompt with user input values. My code so far is: proc report data=FS_STG.STG_PROMOTION nowd; column PROD_ID PROMO_EFF_DATE cv1 PROMO_END_DATE cv2 VEHICLE_NM PROMO_NAME FOCUS_PAGE PROMO_PRICE, MEAN=PROMO_PRICE_MEAN RETAIL_PRICE, MEAN=RETAIL_PRICE_MEAN PROMO_NO, MODE=PROMO_NO_MODE; WHERE PROD_ID = "&prod_id" ; define PROD_ID / group 'PROD_ID' missing; compute PROD_ID; if PROD_ID ne ' ' then hold1=PROD_ID; if PROD_ID eq ' ' then PROD_ID=hold1; endcomp; The log displays: %LET PROD_ID1 = 5550123; %LET PROD_ID0 = 2; %LET PROD_ID_count = 2; %LET PROD_ID2 = 1100255; %LET PROD_ID = 5550123; With my current code the results only display PROD_ID 5550123. What do I need to change to have it also recognize PROD_ID2, etc (for the number of values the user inputs)? Thanks
... View more