I have a list of 39 IDs (Var) in a dataset (Table1) that I want to use in my proc http query. The code below works and the procedure is submitted 39 times (evident in the log), but the only data I see is from the last ID. I assume its overwriting the out file each time? I'd like a separate file for each record or a combined file. proc sql;
select count(distinct Var) into :varCount trimmed from Table1;
select distinct Var into :varVal1- :varVal&varCount from Table1;
quit;
filename out "C:\file.json";
%macro APILoop();
%do index = 1 %to &varCount;
%let token = 1a2b3c;
proc http
url="url"
method="get"
out=out
query=("api_key"="&token" "id"="&&varVal&index.");
run;
%end;
%mend;
%APILoop();
... View more