Thanks @Reezaand @Cynthia_sas ! After i take the exam i will post my own experiences here.   b.t.w. groupformat is an option you can use in reports to group by the formatted values.   Update 20-7-2017: Passed my exam with a good score. The examples i mentioned did not appear at the exam. I suspect they were present in the previous version of the prep guide and are no longer exam material. Btw. The exam was hard and all questions were new to me.   ... View more

I managed to do this in this manner: 1) put the comments in a dataset 2) export the comments to an Excel worksheet   I used the code below (dequote and resolve are used to properly handle macro variables). What is your opinion on this method?   data explanation (drop=text); format contents $1000.; input text $80.; contents=dequote(resolve(quote(text))); datalines; 　 Description of the contents --------------------------------------------------------------------- file created by &sysuserid. this xlsx file contains data about important stuff ; run; proc export data= work.explanation outfile="c:\myexcelfile.xlsx" dbms=xlsx replace; putnames=no; sheet=explanation; run;     29-3-2016 addition: I discovered some improvements. I might be better to use sql and insert to generate the dataset.  ... View more