Hi: Without any data or the full code, nobody can play with your example because they either have to guess at the structure of your data or they have to guess what the rest of your program is. You could be trying to get either HTML, RTF or PDF output, so knowing your ODS statements would be useful too. In just a quick look, it's going to be hard to split the column headers the way you show using PROC REPORT. Spanning headers such as you show are more like the type of thing you can do with the Report Writing Interface (RWI) and the DATA step. However, that brings us back to what destination you want because the RWI Interface is not supported in all destinations. Cynthia ... View more

Hi, Same suggestion as @ballardw -- you can make fake data to test with the posted code. My sense from your description is that your data structure may not work without restructuring. Cynthia ... View more

Hi: Jan 1, 1960 is the 0 date in SAS dates in SAS are stored as numbers internally with 0 as the "middle" of a timeline, like this:   So a negative number in the data column represents a date BEFORE Jan 1, 1960 and a positive number represents a date AFTER Jan 1, 1960. Time values are numbers of seconds from midnight. From the doc: "A SAS time value is the number of seconds since midnight of the current day. SAS time values are between 0 and 86400. A SAS datetime value is the number of seconds between January 1, 1960 and a specific hour, minute, and second of a specific date." So, I suspect that something is wrong with your date variable in YOUR data. The information you've posted implies that if your date was NOT supposed to represent Jan 1, 1960, then something is wrong in the data. As you can see in my example, when the data is created correctly as numeric time and datetime variables, the internal SAS values ARE displayed correctly. Cynthia ... View more

Hi:   When I tried to read your file, the issue I ran into was the tabs generated missing values with your type of input. This worked better for me. data test; length serv $5 table $5 comp $8; infile datalines dlm=',' dsd; input serv $ table $ comp $ numb ; dataord = _n_; datalines; Boy,2796,Active,41043 Boy,2796,Reserve,7024 Boy,2796,missing,72 Boy,PHA,Active,274220 Boy,PHA,Reserve,95291 Girl,2796,Active,3200 Girl,2796,Reserve,1231 Girl,2796,missing,5 Girl,PHA,Active,121634 Girl,PHA,Reserve,36043 Dad,2796,Active,9915 Dad,2796,Reserve,310 TOTAL,2796,Active,77283 ; run;   I added a "DATAORD" variable to capture the original order of the variables, thinking it might help, but your input data is not in the order shown in your desired results, so I'm not sure it is useful.   However, without some direction or a helper variable, to assure the desired ordering, PROC REPORT would not be able to do the type of ordering you show. What PROC REPORT code have you tried? Cynthia ... View more

Hi:   When I test with some fake data, both ODS TAGSETS.EXCELXP and ODS EXCEL create output files that show the correct time and date/time formats when opened in Excel, as shown below:   I took all the style defaults for both ODS EXCEL and ODS TAGSETS.EXCELXP, so that is the reason for the different styles being used. But the numbers in the cells in each sheet are correct.   So I am wondering whether there is something in your data that is not defined correctly when the data is created. Since you did not provide data, it's hard to make a constructive suggestion.   But since you said that your delay_hrs variable was formatted with HHMM in the data, that implies to me that the variable is a numeric time variable. Just to double check that the formats were used in Excel, I also created a date/time variable in my test that also worked, so there must be something else happening with your data. Cynthia ... View more

Hi:   Please start from your My Training page at https://learn.sas.com/my and after you sign into your Profile, click on the button that says "View Licensed Learning" on the left side of the screen. Next you should see a popup window with a link to the SAS Viya for Learners main portal page as shown below:     The sample screen shot only shows SAS Viya for Learners and the SAS Skill Builder Portal, but your view in the popup window may be different.   On the main portal page, there are instructions, as highlighted below:   Click to open the PDF of instructions:   There is a limit to the size of file you can upload, but I expect your Kaggle data won't bump into that limit. Cynthia   ... View more

Hi:   Programming 1 and Programming 2 ARE the 2 classes that will prepare you for this exam. I'm not sure I understand whether you are asking whether there a prep classes for Programming 1 and Programming 2 or whether there is other additional preparation for the Base Specialist exam.   Please review all the preparation on the certification web site: https://www.sas.com/en_us/certification/credentials/foundation-tools/base-programming-specialist.html   You will want to download the exam content guide from the above site and review the additional resources that they outline.   We also offer a Certification review class that is intended for someone who has already taken Programming 1 and Programming 2 and wants to have some extra study before they attempt the exam. In addition, we have published a Certification Prep Guide for this exam. All of these resources are included inside the SAS Programming Learning Subscription, which you will find on this web page: https://support.sas.com/edu/cip.html?program=28&ctry=US .  Cynthia   ... View more

Hi:   The SAS Fundamentals exam does not have a hands-on component. The Exam with the hands-on component is the A00-231 Base Programmer Specialist exam. You only need to take and pass the A00-231 exam to earn the credential. Some candidates may take the Fundamentals exam first, however, it is NOT a requirement. The class preparation for both exams is the same: Programming 1 and Programming 2 classes. The main differences are what credential you earn and whether there is a hands-on component.   If you want to earn the Base Programmer Specialist certification, then the only exam you need to take is the A00-231 exam with the hands-on programming component. Cynthia ... View more

Hi:   As others have stated, getting a sample of your input data file would be good. As it stands, now, the structure of your original data is going to determine how you generate the report you want. Here's why:   With your current usage of GROUP for the PLANT variable, I would expect to see only 1 row for each unique value of PLANT, and this is what we see. In your desired output, you show multiple rows for PLANT B, C and N -- this is the type of report I would expect either if the usage of PLANT was ORDER or DISPLAY. Without seeing the input data for your WORK.TEST file, there's no way to "guess" the structure. I do not see any statistic or COMPUTE block for the REVENUE variable, so I uncertain whether you are calculating a value for REVENUE or just altering a value that is already in the data. At any rate, without data to test with your code, it is hard to make a constructive suggestion. Cynthia   ... View more

Hi: In the Programming 2 class, we have a SAS dataset called weather_japan.sas7bdat, so if you are working in that class, and with the demo program p203d03.sas, you would not need to create weather_japan because it already exists. Can you clarify where in the Programming 2 class you are working and provide the title of the practice or demo you're trying to do? Thanks, Cynthia ... View more

Hi: Well, think of ODS statements as acting like the 2 pieces of bread in a sandwich. The top piece of bread starts the creation of an output file and names the file to be created (as appropriate for the destination -- which means ODS RTF creates an RTF file, ODS PDF creates a PDF file, ODS HTML creates an HTML file, ODS EXCEL creates an XLSX file, etc, etc). Then you have the filling in the sandwich -- the procedures that are going to send output to the ODS destination file -- This could be one procedure or it could be more than one procedure. Whatever the procedure creates will be sent to the ODS destination file, unless you apply some limits to ODS (like ODS SELECT or ODS EXCLUDE statements). Finally, the bottom piece of bread in the ODS "sandwich" is the ODS <destination> close. So if you open, ODS RTF, then you must close ODS RTF. If you open ODS HTML, you must close ODS HTML, etc, etc. In your code, the ONLY output that will be sent to the ODS RTF file is the PROC PRINT output because of where your ODS RTF CLOSE; statement is located. Your 2 plots will probably show up in the default ODS HTML results window in SAS Studio. However, a bigger issue that I see is that you have a %macro statement at the very top of your code and there's no matching %mend statement. So given that this code is within a Macro Program definition, until you call or invoke the macro program, no files will be created. The only thing that happens when you submit code in a %MACRO/%MEND block of code is that the code is compiled and stored in a SAS Macro catalog. This catalog can be temporary or permanent. I don't see where you actually call the %halfnorm macro program or supply it with parameters. This is quite different code from the code you initially posted with the incorrect ODS RTF syntax. You say that you want an output file that you can edit. Assuming that you run the macro program and that the ODS RTF file is created, only your PROC PRINT results will be in the RTF file at the present time. That's assuming that everything works. If you want the graphs and the PROC PRINT output to be in the RTF file, you'll need to move the ODS RTF close to the end, after the second GPLOT step. If you ONLY want the PROC PRINT results, then in your folder, if the program runs successfully, you should see the ODS RTF output file with the name you provided in the FILE= option. You will need to download that file to your own machine, so you can open the file with Microsoft Word or some other word processing program. Cynthia ... View more

Hi: Just fyi, these options spacing=1 headskip headline are all ignored by ODS RTF -- they are all ODS LISTING options that ODS RTF, PDF, HTML, etc. does NOT use. Cynthia ... View more

Hi:   When you use ODS RTF, you should be creating an RTF file in the FILE= option. Instead, your code shows a .SAS file extension, and shows the use of a FILENAME statement used as an option, both of which would be incorrect. I'm not entirely sure what you're trying to do, however, assuming that you are using a SAS OnDemand for Academics server account and your home folder location path is /home/u50158717, then something like THIS should make an ODS RTF file for you: data newclass; set sashelp.class; if age ge 14 then output; run; ods rtf file= '/home/u50158717/class_report.rtf'; proc print data=newclass; title 'Eligible for Driver Training Class Now and within 2 years'; var name age sex; run; ods rtf close; title; The SASHELP library is loaded on the SAS OnDemand server, so you should be able to run this code. Note that the syntax for the ODS RTF statement uses a FILE= option and the result file and path are specified in the FILE= option. The DATA step that creates the file WORK.NEWCLASS is created OUTSIDE of the ODS RTF statements because 1) The DATA step is only creating a subset of rows from the SASHELP.CLASS file and so 2) does not produce any output that can be routed to the ODS RTF destination.   In your code snippet, your code has many syntax errors. It looks more like pseudo code or some kind of mash-up of several different program examples.   The purpose of the FILENAME statement is to point to an external file (such as a .CSV file or a .TXT file) for either INPUT or OUTPUT.   You use the constructs FILENAME IN and FILENAME OUT in your code snippet. First of all, FILENAME is a separate statement and does NOT belong as part of an ODS RTF statement. The correct option for ODS RTF is FILE=, not FILENAME.   Next, it looks like you're trying to read some data into a SAS format using code like this: data NuclearPilotPlant; input A B C D conv tc $ random; A=A; ...   I'm not sure what the ... is for, but typically, I would expect to see more statements or a RUN; or a DATALINES or CARDS statement there. Not sure what your A=A; is needed for since, assuming your have a CARDS statement or a DATALINES statement followed by data, then your program should end with a RUN statement.   If you are trying to READ data from an external file you could use either a FILENAME statement or an INFILE statement. Let's say you have a file called "nukes.txt" in your /home/u50158717 SAS OnDemand account then something like this would work: data NuclearPilotPlant; infile '/home/u50158717/nukes.txt'; input A B C D conv tc $ random; run; OR filename nukein '/home/u50158717/nukes.txt'; data NuclearPilotPlant; infile nukein; input A B C D conv tc $ random; run;   Without any reference to a DLM option, the assumption for this code would be that all of your variables were separated by blanks and that the only character variable in the data file was the TC variable.   In either of the above programs, the unstructured data file, nukes.txt would be read into SAS using either the INFILE statement with the full path name or the FILENAME/INFILE statement and then the INPUT statement would parse the input lines and create 7 variables from each input line. Then each line or row would be output to the WORK.NuclearPilotPlant SAS data file.   If you want to see the contents of this data file in an RTF file, then you would use PROC PRINT, as the simplest way to show you a report so you could review the data that you had just read into SAS format.   We cover many of these basics of using SAS and PROC PRINT and ODS in our beginning Programming 1 class. This class is free to any independent learner.   If you are using a data file and sample code provided by your professor, then you could ask your professor teaching assistant for working code examples that will work on the SAS OnDemand server. Cynthia   ... View more

Hi:   WRDS is supported by the Univ of Penn help team. If the issue is with a server, then it would be a UPenn server that has issues. The WRDS team has a page that outlines how they support WRDS: https://wrds-www.wharton.upenn.edu/pages/grid-items/accessing-wrds-support/ which may be a better place to start, since they would be in control of the UPenn servers. Cynthia ... View more

Hi: If you mean that the Virtual Lab opens a "Citrix" window, then you are NOT using SAS OnDemand for Academics, instead, you are using the internal Citrix-based Virtual Lab that is accessible from INSIDE the course. The benefit of using this Virtual Lab is that the data is already made for you. However, you are correct, that in the Citrix-based Virtual Lab, you CANNOT upload files from your personal machine. This is by design. You do NOT need to upload any files because in the Citrix Virtual Lab, the date files and all the folders are already created for you. Look in your Virtual Lab session for the "S:" drive, and under S:\workshop\EPG1V2, you should find the Programming 1 folders and files.   There are explicit instructions inside the Course Overview section, that explain the data is already created for you inside the Citrix-based Virtual Lab.   If you want to switch to SAS OnDemand for Academics, you would need to start from https://welcome.oda.sas.com which is a separate, stand-alone link that you have to start in a separate browser section. In looking at your screen shots, it appears to me that you are using the Citrix-based internal Virtual Lab, which has restriction on uploads from your machine because the data is already made for you on this Virtual Lab. Cynthia ... View more