This structure is quite simple to replicate with a proc report inside an ods excel structure. imcluding multisheet reports.  You can also create any printer ourtput such as html, pdf, etc. You could strart with this link, and also read up on the papers available on this topic on the SAS Global Forum   https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p09n5pw9ol0897n1qe04zeur27rv.htm#n0bmw0v2sv7lepn17aovz1217r9k Do have a specific requirement?     ... View more

I would suggest design an ods layout absolute page where each obs will print in its own pdf file by cycling through the dataset.  You could then combine all the files into one document with Adobe Acrobat  or a free utility. Alternatively an ods layout gridded design will produce just one file, but you may have less control in triggering a new page. ... View more

One approach would be to read your data into a matrix using proc iml.  then you can reshape it into the dimension you want for your Excel sheet.     Below is a rough code to display 32 vars into a 4x8 table.  if you need to add another row say with just one var, you could append another matrix using the "//" operator (vertical concatenation).   Hope this helps /* Create a dummy dataset that represents your PAMR_CERT */ proc iml; mydat=(1:32); create PAMR_CERT from mydat; append from mydat; close; quit; /* Your code starts here */ /* reshape the data into 4 x 8 */ proc iml; use PAMR_CERT; /* Here use your actual dataset */ read all var _NUM_ into x[colname=NumNames]; print x; close PAMR_CERT; z=shape(x,8,4); print z; create PAMR_CERT2 from z[colname={'A' 'B' 'C' 'D'}]; append from z; close; quit; filename xlout '~/test/reshaped.xlsx'; ods excel file=xlout; proc print; run; ods excel close;   ... View more

%macro prnt; %if %sysfunc(exist(work.mydata)) %then %do; proc print data = work.mydata; run; %end; %else %put dataset does not exist; %mend prnt; %prnt; ... View more

This icon on the message editor is for pasting code   ... View more

I find your code hard to read, you should use the running man icon to paste it.   I have always found this paper quite helpful in formatting my TOC   https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4265-2020.pdf ... View more

Could you explain the logic of how the data is stored? What I have observed is Q1 is always the first.caseid which you will save as QuestionText and A1 as the Answertext Then you remove the first.caseid record, in the next iteration Q2 is the first.caseid. and so on for Q3 Will this iterative process work with your survey data structre? ... View more

If you just need individual csv files and not generate individual datasets, the following will do it. Note, names with embedded spaces will have the blanks removed   proc sql noprint; select distinct make into :carlist separated by '|' from sashelp.cars where make is not null; ; quit; %macro each; %local i next_car; %let i=1; %do %while (%scan(&carlist, &i) ne ); %let next_car=%scan(&carlist,&i, |); proc export data=sashelp.cars(where=(make="&next_car")) outfile="~/csv/%sysfunc(compress(&next_car)).csv" dbms=csv replace; run; %let i = %eval(&i + 1); %end; %mend; %each;   ... View more

proc sql noprint; select distinct make into :carlist separated by '|' from sashelp.cars where make is not null; ; quit; %put &carlist .; %macro each; %local i next_car; %let i=1; %do %while (%scan(&carlist, &i) ne ); %let next_car=%scan(&carlist,&i, |); data %sysfunc(compress(&next_car)); /* Removes space from Land Rover */ set sashelp.cars; where make eq "&next_car"; run; proc export outfile="~/csv/%sysfunc(compress(&next_car)).csv" dbms=csv replace; run; %let i = %eval(&i + 1); %end; %mend; %each;   ... View more

Try ods graphics on / scale=off; if this does not work specify size ods graphics on / width=4.5in height=3.5in;   ... View more

Yes, with this approach you could break up the list. How may "words" do you have in your lookup list. Frankly if I were you I would try the proc format approach shown by @SASKiwi It's also described in this paper, see p.2 https://support.sas.com/resources/papers/proceedings/proceedings/sugi26/p102-26.pdf ... View more