@ThierryHerrie wrote: I appreciate your concern, but I will 🙂 It is like a report where you have a column per month, except I would like the data in a table. Cheers! Hello, @ThierryHerrie this is a common mistake. You want a report with columns like 2021 and 2022 so you think you have to create a data set with calendar information in the variable names. Not true at all, and even though you CAN do it with calendar information in the variable names, it is not a good approach. The better approach is to have a long data set, with a variable named YEAR containing the actual year, and then use PROC REPORT to create the report.   If you can show us a portion of your data as SAS data step code, and show us the desired report, we can show you better ways to go about this. ... View more

@ThierryHerrie wrote: Hi,   In SAS EG 8.2 is it posible to show only project files (*.egp) in the Recent Items list? I don't want to see the datasets I've opened and used in my projects.   Kind regards, Thierry Yes, such an option would be great. ... View more

Postprocessing the file was my plan B  Think I will just do that, thanks! ... View more

Thanks all for replying to my question. Great community!! I think, for now, I will call a macro in a User Written transformation and try to do this only with the most risk full external files.   Cheers! Thierry ... View more

@ThierryHerrie Now I understand what you're asking for. Yes, there is certainly required information missing when selecting "Generate column mapping macros". If one would really want to use this then we'd also need the Libref and Table per source column. This is missing even when using these columns in an expression so you can't implement dynamic code with this insufficient information.   Besides of creating a SASWare Ballot idea, I'd also raise this with SAS TechSupport so it gets fed back to SAS R&D. ... View more

I don't think that FOOTNOTE is the right place in a report to list all names with missing salary, unless you are sure there are less than 10 names. You better create two reports:   title ' Salary given to'; proc print data=have (where=(salary ne .));  /* optiona NOOBS */ var name date salary; sumvar salary; run;   title "Nmaes with missing salary"; proc print data=have(where=(salary is missing)); var name date; run;   ... View more