Hi, Unfortunately, your screen shot is too small to see. Even using the Zoom function, the headers become all pixellated and not readable. Also, the white font on the current background is also unreadable. It looks like the suggestion posted was for an HTML/CSS solution and I'm not sure that would work for ODS WORD or ODS RTF. Microsoft designed their own version of CSS that was different than the CSS used with HTML, so that might now work. You might have to move to the Report Writing Interface to get the type of headers you want. But without your code AND your data or some dummy data to test with, it's hard to do more than make a comment. Cynthia ... View more

Hi: If you followed the setup instructions for Programming 1, when you expand the EPG194 folder (older name) or the EPG1V2 folder (newest name), then you should see a subfolder named output. If you right click on the output subfolder under your main class folder and in the popup menu on the right click, choose Properties, you should next see the Properties window which will contain the FULL path to the output subfolder. The libname could be: libname out "s:\workshop\EPG1V2\output"; or libname out "/home/<yourUserID>/EPG1V2/output"; or libname out "/home/<yourUserID>/EPG194/output"; or you may want to make an entirely NEW folder for your output under the class main folder. Let's say you do make a NEW folder under the EPG1V2 (or EPG194) class folder and you call the NEW folder mystuff, so when you want to write to the mystuff folder, your LIBNAME statement would change to something like: libname out "/home/<yourUserID>/EPG1V2/mystuff"; Using the right-click and Properties method will ALWAYS show you the correct folder path you need to use. Cynthia ... View more

Hi:   I'm not entirely clear what you mean by grouping and colorizing. As you show them now, your test1 and test2 are just spanning headers so without some advanced technique, you only have one way to alter the style attributes of those header cells, as shown in #2 and #3.: But if you want the headers for test1 and test2 to be the SAME as the other headers and columns, then you have to either use dummy variables (#4) or a technique like the user defined format in #5:   Since it is not entirely clear to me what you are trying to do, this is all I can envision at this point. Cynthia   ... View more

Thanks, @Tom, that looks like a much easier solution. I had not experimented at all with that feature. Cynthia ... View more

Hi: That is going to be a challenge. The SAS Program file (a .SAS file) and the SAS log, can typically be saved as separate files, with the extensions of .SAS and .LOG, but they will be in 2 separate files. Once saved on SAS Studio, they could download the separate files to their system and then combine the files in Notepad or Wordpad or Word and resave. The challenge with the results is that typically, the results in SAS Studio are created as HTML files, by default, which is not going to be easily combined with the other text files unless your students use a Word Processing program to combine the .SAS file and the .LOG file and the downloaded HTML results together. Another alternative would be to just require that each student send you 3 separate files as: student_name.sas, student_name.log and student_name.html -- where you would get 3 files from each student. They could write SAS programs to combine the .SAS program and the .LOG results into one file or you could use PROC PRINTTO to sent LOG output and a TEXT version of the results to a .LST file. The challenge with this last approach is that if your assignment included creating any type of graphics, then that output might not appear correctly in the .LST file, which is just n ASCII text file of the tabular output from your SAS code. What you are envisioning -- getting all the output in one file would be a burden to students who are new users of SAS. Are these students more experienced and comfortable with writing DATA step code? Cynthia   ps another option might be that they use Jupyter Notebook. I seem to remember a demo where the SAS code in Jupyter could save the code and results in the Notebook. I am not sure about the Log. However, that would require that your students stop using SAS Studio and switch to Jupyter Notebook so before you ask them to do that, you'd need to find out from other Jupyter users whether what you envision is possible. ... View more

Hi: You may have to write the surveymeans output to a dataset and then use PROC PRINT to control the width. Cynthia ... View more

Yes, @ballardw is correct. It would be better to address the issue of GENDER in the code that creates &&var_&j and &&fmt_&j. But without the data and ALL the code and some idea of the desired results, it is hard to determine whether you really need multiple PROC TABULATE steps or whether it would be better to have one PROC TABULATE with multiple TABLE statements. Cynthia ... View more

Hi: My guess is that your variable list also contains GENDER, which is a problem because you have GENDER hard-coded in the TABLE statement, so if GENDER is in your list of variables that you're looping through, when it's crossed with itself, it will generate an error. You don't show how your list &&var_&j is generated, but my guess is that you'll need to verify that GENDER is NOT in the list or else modify the macro program to skip the loop when the value of &&var_&j is equal to GENDER. Cynthia ... View more

Hi: It depends. Some companies want their SAS Admin to open tracks with SAS Tech Support. Other companies allow their employees to contact Tech Support directly. To open a track with Tech Support, fill out the form at this link: http://support.sas.com/ctx/supportform/createForm and be sure to provide them with your site license number, a sample of your data and the code that they can test. Cynthia ... View more

Hi: I think that would be a question for Tech Support. I have never tried to supply a link to a specific page in a PDF document from an Excel file. In my example, the link worked because all of the files being referenced were located on the same physical file system. What if the Excel file is down on a local machine but the PDF file is on a different server. I'm not confident that the HTML technique would work. So it's worth checking with Tech Support. Cynthia ... View more

Hi: Your screen shot of desired results is the type of report typically called a demographic report. There is not any SAS procedure that will generate that type of report for you by default. You have to do more manipulation of the summarized data in order to generate the type of report you show. For example, your XX (XX%) for the values for the Active vs the Placebo is usually the concatenation of 2 numeric variables (N and PCTN) in order to make a character string that can be displayed under each major column. Typically, to get the results for GENDER, you run PROC FREQ for each of your groups (ACTIVE/PLACEBO) and then for your AGE values, you run PROC MEANS. Generally, you need to post process the data from both of these procedures to get the data in a form that's ready for PROC REPORT. There are several macro programs floating around that do it. I have several examples using PROC REPORT with some helper variables in my Creating Complex Reports paper and Lisa Fine has some examples of this type of report in her book on using PROC REPORT and I'm sure I remember several PharmaSUG papers that had different ways to use PROC REPORT or the DATA step to generate this type of report. Cynthia ... View more