Thanks @Reeza. I always forget to mention HTML5 and SVG as a possibility. Cynthia ... View more

Hi: I suspect you may also need a GPATH= option to direct ODS where the image will be stored. But a lot depends on your PATH= option too. You are using a relative path reference in the PATH= option. I would normally expect to see a fully qualified path location in the path= option something like: ods html gpath='c:\temp' (url=none) path='c:\temp' (url=none) file='myhistogram.html'; The way you have it coded now, the path will be relative to your working directory unless you have edited the actual code to remove the fully qualified path. Hard to tell. Cynthia ... View more

Hi:   INDENT= is a style override and in my program, I have a helper variable called INDENT that I use to determine which INDENT= value to use. In the DATA step program at the top of my screen shot. So I see that you seem to have created a helper variable called INDENT. But you have it at the end of the report row in your COLUMN statement.   Notice in my program, how my "helper" variables are all placed to the left side of the TEXT variable. This is because of the left-to-right rule of how PROC REPORT processes the items on the report row. I see you have an INDENT variable listed on your COLUMN statement, but if you want to test INDENT in order to change the style for the NAME variable, then you have to use the same left-to-right ordering that I used. Your INDENT variable will need to be placed on the COLUMN statement before the NAME variable. Since you did not provide any data to work with, it's impossible to run your program without making.   Also, your code does not use the INDENT= style option. I only see  ASIS=ON. I am not sure that will be respected by Excel when it opens the file. Cynthia ... View more

@ballardw is correct. If the server or rendering system does not have Calibri, then another font is substituted. My understanding was that fonts like Calibri are Windows TrueType fonts and if, for example, your system server is a Linux or Unix server, they may not have any Windows fonts loaded. Do fonts that are "common" fonts like Courier or Times New Roman work? Can you check with your system administrator that Calibri is available? Cynthia ... View more

Hi:   Take a look at this paper https://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf especially at the examples on for Output 12, 13 and 14. The discussion starts at the bottom of page 11. Cynthia ... View more

Hi:   I don't think the RTF control strings will work for you. However, the simple style overrides should work, as shown in these 3 examples. Note that I made example 3 quite extreme and did the Header cells and the Data cells all with different justifications:   Hope this helps, Cynthia ... View more

Hi: There are multiple sets of instructions in the Programming 1 class. The SAS OnDemand for Academics instructions are written specifically for students who are working on the SAS OnDemand server and the zip file is stored on a location that should not issue that error message. However, if you run the SAS OnDemand instructions on your University-issued copy of local SAS or on a computer lab copy of SAS, the SAS OnDemand instructions will not work. You have several choices: 1) use the Virtual Lab that is inside the Programming 1 class. This is a Citrix-based lab that already has the data pre-loaded; or 2) try a different set of instructions, such as the SAS for local Windows instructions or the SAS for Enterprise Guide instructions (only if you are using SAS Enterprise Guide). Each of those method of practicing in the course will have a separate set of instructions and a separate zip file for you to use. If that does not work for you, then send your question about the data to elearn@sas.com and let us know exactly how you are practicing (SAS OnDemand, SAS on local Windows, SAS on EG, SAS on university or company server) and we can help you find the right set of instructions to follow. Cynthia ... View more

Hi:   The path that starts /folders/myfolders is an older path so you are looking at code that is an example of solving this problem on our old SAS University Edition product, which has now been retired.   If you are using SAS OnDemand for Academics, then the path to your output folder should be something like %let outpath=/home/userID/EPG1V2/output; So if your userID was u1234567, then your path location for the output file would be something like: %let outpath=/home/u1234567/EPG1V2/output; To find the correct path, as explained many times before Lesson 6, open the Server Files and Folders panel and right click on the output subfolder under the EPG1V2 class folder. In the popup window when you right click, choose Properties and the path that you see in the Properties window for the output folder is the path you should use WITHOUT quotes (as already noted) in the %LET statement to make the &outpath helper macro variable. Cynthia ... View more

Hi: If you're using the default HTML results and you are asking about the horizontal rule between procedures for some ODS destinations, there is an ODS HTML example here: https://support.sas.com/resources/papers/proceedings/proceedings/sugi31/091-31.pdf with a PROC TEMPLATE method shown on page 2. Cynthia ... View more

Hi: The Base Programmer certification is NOT required. However, the recommended preparation for the Statistical Business Analyst exam is Statistics 1 (which recommends the level of knowledge you'd have learned from taking Programming 1) and Predictive Modeling using Logistic Regression (which recommends the level of knowledge from Statistics 1 and Programming 2). Most of the candidates for this exam will have studied Programming 1 and Programming 2 before attempting these classes. They may not hold the Base Programmer Certification, but they will have studied Programming 1 and Programming 2 at some point. But to answer your original question, there is no requirement that you hold the Base Programmer certification credential. But we would expect you to have Programming 1 and Programming 2 level of knowledge and SAS usage before you attempt Statistics 1 and Predictive Modeling using Logistic Regression to prepare for the Statistical Business Analyst exam. Cynthia ... View more

Hi:   By SAS Drive, it sounds like you might be using SAS Drive on  SAS Viya for Learners as an academic user. Some features of SAS Viya, such as autotuning and sharing files are disabled on the Viya for Learners server. These features will be available in a full SAS Viya install. Every student on the Viya for Learners server is assigned to a unique tenant or server because this helps improve performance and response time for all the students in a class -- when they're all on the same server, there can be performance issues. If each student gets assigned to a different server, the load is distributed across multiple servers for a class.   In order to share files, the best thing that we recommend is that you create and do a Print to PDF for your report and then share the PDF with your professor or fellow student. Cynthia ... View more

That's cool! I did not realize that mergeacross would work on Data cells as well as Header cells. That's really using an EXCEL format/style as a TAGATTR style override for ODS, which would only work for an ODS EXCEL file. Would not work for PDF or RTF or other destinations. Cynthia ... View more

Hi: DISPNAME has to be wide enough to display ALL the characters in BABYDATE (8 characters) and the 5 characters in the word Total. I would expect that you are NOT seeing the entire word BABYDATE when you do this report. (Sorry, your PDF wouldn't open for me so that is just a guess.) Without data to experiment with or seeing all of your report in a screen shot, I'm not sure what you mean by your statement that " Instead it created a new column with total at the bottom. " That is exactly what dispname is supposed to do. Here's a modified version of my program and the output: In my example see how NAME is the first item on the COLUMN statement. If I want the value of NAME on every row to be assigned to the DISPNAME column, then NAME has to be to the left of DISPNAME on the COLUMN statement. You will see this in both Example 2 and Example 3. Also note in #2 how you don't see NAME on the report because the DEFINE for NAME uses the NOPRINT option. But, in both #2 and #3 example, in the COMPUTE block for DISPNAME, I assign the value of NAME on THAT row to be the value of DISPNAME on that row. In your recent example, you assign the fixed string "BABYDATE" to the DISPNAME column -- that's going to give you a fixed string with a length of 6 on every row, which probably is NOT what you want.   In Example #3, notice how I have removed the NOPRINT option from the DEFINE for NAME and I have put DispName as the column header label for the DISPNAME column. So in #3, you should see the same value for student name in the first 2 columns. What NOPRINT does in #2 is allow me to use the value of NAME, but hide it on the report. Cynthia ... View more