@kmusa wrote:
I finally got this to work using your suggestion. Here it is - thanks so much!
data _null_;
set Listid_viewid;
ha_data=cats('ha_data',Form_number,'.xml');
HA=cats('HA',Form_number,'.map');
sp_list_data=cats('sp_list_data',Form_number);
call execute('%Let xmlfile = '||ha_data||';');
call execute('filename listout "&dir\&xmlfile";');
call execute('proc http out = listout
url="&url?Cmd=Display&List='||ListID||'&View='||ViewID||'&XMLDATA=TRUE"
METHOD = "GET"; RUN;');
call execute('filename HAabsent "&dir\&xmlfile";');
call execute('filename sxlemap "&dir\'||HA||'";');
call execute('libname HAabsent xmlv2 xmlmap=sxlemap access=readonly;');
call execute('data '||sp_list_data||';');
call execute('set HAabsent.row;');
call execute('run;');
call execute('quit;');
run;
quit;
Good!
I quite often have a long string variable that I can use the various the SAS string functions to build and then use
Call execute(string);
That way I can use a Put statement to check the resolution of the functions before actually having the call execute statement execute.
... View more
