Hey folks, I am interested in writing a do loop, that uses information out of a SAS Table and puts that information together with a .jpg into a pdf. The data I am working with looks more or less like this: Now, I would like to extract all rows one by one in the table and merge it together with a .jpg. So the outcome should look like the attached pdf. I also attached some example data in an xlsx file. The code I have got so far looks like this: %let i = 1;
%do i = 1 to 3;
%let as = Var1 Var2 Var3;
data reduced;
set ExEXc;
if item = "&as";
run;
ods pdf file="J:\Learning SAS\Test.pdf";
ods layout start width = 19cm height = 28cm ;
ods region y=3cm x=0.4cm;
proc report data=reduced;
run;
ods region y=6cm x=3cm width=13cm height=8cm style={backgroundimage="J:/Variables/&as.jpg" };
ods text= " ";
ods layout end;
ods pdf close;
%let i = &i + 1;
%end; As you can see in the second ods region statement, I am refering to a folder that contains the .jpg files thats looks like this: Ideally, my &as macro Variable contains the Variables and the .jpg files altogether so the code is a as simple as possible. I am not able to attach .jpg files, but it really doesnt matter which pictures are used as long as they got the same name as the Variables. To conclude: As I am just getting used to macro coding, I was wondering if any of you knows how to specify the DO Loop, so that it reads the first line of my data and merges it together with the matching first .jpg file, puts it together on page one of the pdf and continues with selecting the next line of the data, the next .jpg file, puts it on the second page of the pdf and so on. Kind regards, Jakob
... View more