SAS Support Communities

I have not used this but have some suggestions.   This documentation states that you should not specify the SSLCALISTLOC option:   CAUTION Do not change the SSLCALISTLOC= system option.  Starting SAS 9.4M3, the SSLCALISTLOC= system option should not be overridden or changed unless directed by technical support or PSD. https://go.documentation.sas.com/?docsetId=secref&docsetTarget=p0pul4j64w0mg0n1h1k6z8zhfvaf.htm&docsetVersion=9.4   The LIBNAME statement is in error because the FRED enviroment variable is not defined, causing the path specified to be invalid. You might be able to specify any valid path in the LIBNAME statement.   For example, in SAS University Edition I have a mapped folder My Folders > Data referring to the /folders/myfolders/Data location (view the properties of the folder to see the location).  This LIBNAME statement should work if you specify the correct location for the PATH variable and your API key:     options validvarname=any; %let PATH=/folders/myfolders/Data; libname fred sasefred "&PATH" OUTXML=exportgs XMLMAP="&PATH/exportgs.map" APIKEY='XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' IDLIST='bopxgsa';   After you get the LIBNAME statement working, then try submitting the DATA step code to read the data:     data work.export_gsa; set fred.exportgs ; run;   Vince DelGobbo SAS R&D     ... View more

What @FredrikE said about removing the extra STPBEGIN/END calls is correct, but it's a lot more complicated than that.   Try this slightly reworked version of your code to see if it gives you the result that you need.   %global MAKE TYPE REQTYPE; %macro first_prompt; %* 1. Get list of distinct vehicle types; proc sql; create table work.vehicle_types as select distinct type from sashelp.cars order by type; quit; %* 2. Create the first prompt; data _null_; set work.vehicle_types end=eof; file _webout encoding='utf-8'; if (_n_ eq 1) then do; thissrv = "&_URL"; thispgm = "&_PROGRAM"; put '<br>'; put '<h1> List of Vehicle Types </h1>'; put '<form action="' thissrv +(-1) '" method="get">'; put '<input type="hidden" name="_program" value="' thispgm +(-1) '">'; put '<input type="hidden" name=reqtype value="print">'; put '<br>'; put '<b>Select Vehicle Type: </b>'; put '<select name="type">'; end; if type ne '' then do; put '<option value="' type '">' type; end; if (eof) then do; put '</select>'; put '<br><br>'; put '<input type="submit" value="Submit Request">'; put '</form>'; end; run; %mend first_prompt; %macro second_prompt; %* 3. Get list of vehicle make for the selected vehicle type; %put Vehicle Type previously selected was: &TYPE; proc sql; create table work.vehicle_makes as select distinct make from sashelp.cars where (type eq "&TYPE") order by make; quit; %* 4. Create the second prompt; data _NULL_; set work.vehicle_makes end=eof; file _webout encoding='utf-8'; if _n_ = 1 then do; thissrv = "&_URL"; thispgm = "&_PROGRAM"; put '<br>'; put "<h1> List of Vehicle Makes for &TYPE Vehicles </h1>"; put '<form action="' thissrv +(-1) '" method="get" target="_blank">'; put '<input type="hidden" name="_program" value="' thispgm +(-1) '">'; put '<input type="hidden" name="reqtype" value="print2">'; put '<input type="hidden" name="type" value="' "&TYPE" '">'; put '<br>'; put '<b>Select Vehicle Make: </b>'; put '<select name="make">'; end; if make ne '' then do; put '<option value="' make '">' make; end; if eof then do; put '</select>'; put '<br><br>'; put '<input type="submit" value="Submit Request">'; put '</form>'; end; run; %mend second_prompt; %macro report; %stpbegin; %* 5. Create the report based on prompt selections; title 'List of Vehicles Based on Prompt Selections'; proc sql; select * from sashelp.cars where (type eq "&TYPE") and (make eq "&MAKE"); quit; %stpend; %mend report; %if (&REQTYPE eq ) %then %do; %FIRST_PROMPT %end; %if (&REQTYPE eq print) %then %do; %SECOND_PROMPT %end; %if (&REQTYPE eq print2) %then %do; %REPORT %end;   Vince DelGobbo SAS R&D   ... View more