I'm new to this concept and I was wondering if you could help me. I have successfully used PROC HTTP to call data from a website. the problem is that I'm only able to call single Portfolio id each time (this is how the API is set up). I was wondering if you could help me change this code to use hypothetical Table A column B values (all 150+ values) to feed into the below code as portfolio ids and eventually create a table with results from using these portfolio ids. %let AccessKey =/*Enter Token id Here*/; %let Portfoli_id =/*Enter Portfolio id Here*/; proc http url="url/&Portfoli_id" method="GET" out=FS; headers "Authorization"="Bearer &AccessKey."; run; libname PP Json fileref=FS; proc contents data=PP._all_; run; Really appreciate your help!
... View more