Hello All, I need help with the similar situation. Thanks to you all for your postings. It was very informative. I was wondering on how to handle the proc http, if my URL is a variable in a data set called HTTP. I have used the url access method, but I was getting an error saying invalid server response. I need to run all the url links one by one and get the values stored on the server (some name), and send those values to the name variable back to my work data set. I was thinking to export the file to the temp folder on unix, and then use the filename in temp; filename out temp; Please advise. I have used your method here: My environment is UNIX: proc sql noprint; select count(*) into :httpcnt from work.URL_Test where substr(http,1,5)='http:'; quit; %put &httpcnt; data _null_; set Test; call symput("cpe",trim(variable)); call symput("date_time",trim(variable)); run; %let url = "http://host:80abcdetcetc%nrstr(&cpe)%nrstr(%&)incidentDate=%nrstr(&date_time)"; filename http_get "/test/test/http.csv"; %macro get_http; /*%do i=1 %to &httpcnt;*/ proc http out=http_get url=&url method="get" ; run; /*%end;*/ %mend; %get_http; Btw, This method worked for me when I took just a single link from the variable to test its out. It worked great, and created forllowing valuesin the out=http_get.csv file. Please let me know if its possible to get only "name I am looking for"? are there any options to remove the tags?? I need to run all the links, and include the results to my data set (in name variable). Thanks a lot in advance. *****http_get.csv file. <html> <head> <title>adcdef</title> </head> <body> <h1>name I am looking for</h1> </body> </html>
... View more