About Cynthia_sas

Cynthia_sas

Hi: I see at least one and maybe more than one issue with what you're showing. In your first post, you showed The most usual reasons for this message are these possibilities: --you did NOT create the EPG1V2 folder directly under Files (Home) top folder --you did NOT run the data creation program and you don't have a data subfolder under EPG1V2 main folder --you spelled the folder name in lower or mixed case. The data creation program is expecting to see EPG1V2 folder directly under Files (Home) top folder and ALWAYS in upper case: EPG1V2 -- not epg1v2 or Epg1V2 or mispelled as EGP1V2 any of those misspellings will cause the error you show Take a look at this video: https://youtu.be/piTtnbzODPs if you watch the video you'll see THIS structure for the EPG1V2 folder at approximately time stamp 4:53 Note how the EPG1V2 class folder is directly under the Files (Home) top folder. If EPG1V2 is in any other structure (like down under the sasuser folder, then the data setup program will NOT work correctly, the data subfolder will not get created correctly and the SAS datasets will not be created correctly. (Note that the video shows our older version of Programming 1 on the previous e-learning platform -- the class is the same, the container to play the videos is different. So the parts that show SAS Studio are the same.) Then in a later post, you are trying to import an XLSX file, but you said that you created the EPG1V2 folder under the sasuser.v94 folder. That is the WRONG location. It is likely that none of your programs are going to run even after you correct the error in the PROC IMPORT step (you have a semi-colon in the wrong place). I suggest you MOVE your EPG1V2 folder directly under the Files (Home) top folder and then re-run the data creation program. You can ALWAYS double check the physical path for any file or folder by clicking to bring the Server Files and Folders pane to the foreground, then navigate to the folder or file you're trying to get the path for. If you right click on the file or folder and then choose Properties you will next see a Location field in the Properties window. This location field will show you the EXACT location that you need to use in a PROC IMPORT or in a LIBNAME statement. Hope this helps, Cynthia

Cynthia_sas

Hi: Let's say I have 3 SAS datasets: students.sas7bdat teachers.sas7bdat courses.sas7bdat And that these 3 datasets are physically stored in these possible locations/operating systems: 1) SAS On Windows on my local machine: C:\Schools\K_12\Douglas Then the LIBNAME statement would be: libname Douglas 'c:\Schools\K_12\Douglas'; 2) SAS On Windows, but mapped to my Q:drive Q:\user111\Schools\K_12\Douglas Then the LIBNAME statement would be: libname Douglas 'q:\user111\Schools\K_12\Douglas'; 3) SAS on a Unix/Linux server on a local network: /home/usr/bin/usr111/Schools/K_12/Douglas Then the LIBNAME statement would be: libname Douglas '/home/usr/bin/usr111/Schools/K_12/Douglas'; 4) SAS used with SAS OnDemand for Academics under a users Files (Home) top folder: /home/u12345678/Schools/K_12/Douglas Then the LIBNAME statement would be: libname Douglas '/home/u12345678/Schools/K_12/Douglas'; Notice how each libname statement uses a "nickname" or library reference called Douglas in order to provide a reference that will point to that physical location on each operating system. Now, no matter which operating system my files are physically stored on, this code below would work the same if run on each operating system, assuming the correct LIBNAME statement had been issued prior to running the steps. In this case, since the files are permanently stored in a physical location on my operating system and since I now want to use SAS procedures with the SAS data, I can use a 2-level name in my SAS code to point to the specific SAS data table and SAS will know where to get the data from the folder location specified in the LIBNAME statement. proc contents data=douglas.students; title 'Show information about students at Douglas'; run; proc print data=douglas.teachers; title 'Display a list of teachers at Douglas Elementary'; run; proc freq data=douglas.courses; title 'Show how many courses in each grade_level at Douglas'; tables grade_level/ nocum nopercent; run; Hope this helps get you started. Our Programming 1 class goes into some detail about the LIBNAME statement to read SAS data and the XLSX Libname engine to read Excel files and helps you learn how to read CSV files and import them into SAS format. It's a free class and might be worth reviewing. Cynthia

Cynthia_sas

Hi, It's just that your path is wrong. You don't use the server name and Files (Home), just something more like this: /home/u12345678/EPG1V2/data/storm_summary.sas7bdat OR ~/EPG1V2/data/storm_summary.sas7bdat where instead of "u12345678", you use your own user ID or else you use the tilde (~) without a leading slash to indicate your Files (Home) folder. If you right click on Files (Home) and choose Properties, you'll see the correct userID that you need to use in your DATA= option for this activity. Using the tilde (~) is probably easier, but it's not a bad idea to know what your unique userID is on the SAS OnDemand platform. Cynthia

Cynthia_sas

Yes, That's correct. The multiple LINE statements are all writing into one big cell. So you cannot have a different background color for each line. That's why I only changed the foreground color. It is the same in PDF and RTF -- what is in one cell, no matter how many lines has one background color for the whole cell. Cynthia

Cynthia_sas

Hi, Another way to do this conditionally with multiple LINE statements, shown below using just 3 groups from SASHELP.CLASS: I didn't use page breaks or BY groups or put each age on a new sheet just so it would make all 3 groups visible in one screen shot. Here's the code I used: ods excel file='c:\temp\style_line.xlsx' options(embedded_titles='yes'); ods escapechar='^'; proc report data=sashelp.class style(lines)={just=l font_weight=bold vjust=m} style(column)={protectspecialchars=off}; title 'The title'; where age in (11,12,13); column age name sex height weight; define age / order; define name / order; define sex / display; define height / display; define weight / display; compute after age; length tline1 tline2 tline3 $100; if age = 11 then do; tline1 = "^{style[color=red]Line 1 in PROC REPORT} (*ESC*){NEWLINE}" ; lg1 = length(tline1); tline2 = "^{style[color=purple]Line 2 in PROC REPORT} (*ESC*){NEWLINE}" ; lg2 = length(tline2); tline3 = "^{style[color=turquoise]Line 3 in PROC REPORT} (*ESC*){NEWLINE}" ; lg3 = length(tline3); end; else if age = 12 then do; tline1 = "^{style[color=black]Line 1 in PROC REPORT} (*ESC*){NEWLINE}" ; lg1 = length(tline1); tline2 = "^{style[color=black]Have Line 2 but No Line 3}" ; lg2 = length(tline2); tline3 = ' '; lg3 = 0; end; else if age = 13 then do; tline1 = "^{style[color=purple]Line 1 in PROC REPORT} (*ESC*){NEWLINE}" ; lg1 = length(tline1); tline2 = " (*ESC*){NEWLINE}"; lg2 = length(tline2); tline3 = "^{style[color=red]Line 3 (blank for line 2)}" ; lg3 = length(tline3); end; line tline1 $varying. lg1; line tline2 $varying. lg2; line tline3 $varying. lg3; endcomp; run; ods excel close; Hope this helps, Cynthia

Cynthia_sas

Hi: If you're going to use ODS TEXT, and you want to change the style from the default placement I believe you need to change the style template used for the output. There's an example of doing this in the documentation https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/odsug/p14gx25pepks6dn1q9m7vkq3gfoi.htm#n0rx93bn3orev5n1ogar2yb813kra Cynthia

Cynthia_sas

Hi...sorry, it was moved. YOu'll find it here: https://support.sas.com/resources/papers/proceedings14/index.html scroll down to the S in the alpha list and there's a link to Download the zip file: Have fun with the code! Cynthia

Cynthia_sas

Hi, Yes, what you want to do IS possible. It is just sort of fiddly. Look at output 10 in this paper https://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf. Specifically, look at the adjusted code where I create a variable called "SVARn" and then use that variable in the Call Define. Cynthia

Cynthia_sas

Thanks, @ballardw for referencing my paper. The "sort of" example in that paper was Example 10 on pages 10 and 11. The difference between what I show in the paper and what I think you want to do is that in Example 10, I used the same color to apply traffic lighting to the other columns under the ACROSS item. But it seems like this example they want to apply the traffic-lighting to different single columns under an ACROSS item. The only way to do that is by figuring out the absolute column number as shown in the paper. It is sort of a pain, but here's a simple example using your data, but cutting down the number of columns, just to make it easier to figure out the absolute column numbers that will need to be referenced in the COMPUTE block: So notice that there's a pattern: I have 3 columns for GroupCol1 under each unique value of GroupCol2. Based on this and counting from left to right, the column for G1_A under G2_A will be referred to internally by PROC REPORT as _C3_ and likewise, the column for G1_B under G2_A will be referred to internally by PROC REPORT as _C4_ and the next column for G1_C under G2_A will be referred to as _C5_ and then we keep counting _C6_, _C7_, _C8_ as shown above. Using this code, now I know which column I need to test if I want G1_A under G2_A to be a different color than G1_A under G2_B: In the COMPUTE block, I MUST refer to the absolute columns under the ACROSS variable(s) by the absolute column name. For purposes of this example, since you wanted the ACROSS variable to play a role in the traffic lighting, there was no way around doing something like this in PROC REPORT. You could pre-summarize and create a helper variable to set the colors, that might seem easier. I may have misunderstood what it is you want to do. You didn't need to create NumCol_N, as far as I could tell, so I didn't use it. Hope this helps, Cynthia ** Another example: Change both format and style: And how to do trafficlighting and change the format for the entire column (changed _c6_, _c7_ and _c8_):

Cynthia_sas

Hi: I ran a quick test using SASHELP.PRDSALE using THIS code: options orientation=landscape topmargin=.25in bottommargin=.25in rightmargin=.25in leftmargin=.25in; ods graphics / width=10.5in height=7.5in; ods pdf(id=1) file='c:\temp\test_graf.pdf' style=htmlblue nogtitle nogfootnote; proc sgplot data=sashelp.prdsale; title 'Test difference HTML/PDF'; where product in ('DESK' 'CHAIR' 'SOFA' 'TABLE'); vbar product / response=actual group=region groupdisplay=cluster clusterwidth=.50; xaxis display=(nolabel); yaxis label='Level of Agreement' values=(0, 50000, 80000) valuesdisplay=("None (0)" "The Middle (50K)" "The Highest (80K)"); footnote "N: Institute = 10, National = 100"; run; ods pdf(id=1) close; ods html(id=2) path='c:\temp\' file='test_graf.html' style=htmlblue nogtitle nogfootnote; proc sgplot data=sashelp.prdsale; title 'Test difference HTML/PDF'; where product in ('DESK' 'CHAIR' 'SOFA' 'TABLE'); vbar product / response=actual group=region groupdisplay=cluster clusterwidth=.50; xaxis display=(nolabel); yaxis label='Level of Agreement' values=(0, 50000, 80000) valuesdisplay=("None (0)" "The Middle (50K)" "The Highest (80K)"); footnote "N: Institute = 10, National = 100"; run; ods html(id=2) close; I didn't mess with fonts or DPI, all I did was generate 2 different files, one HTML and one PDF that sort of copied your general VBAR. Here's the PDF file viewed in Acrobat Reader: And here's the HTML file viewed in Chrome: They look fairly similar to me as far as fonts and readability. (and yes, I know that 50K isn't the middle...my bad) Of course, it's not an apples-to-apples comparison because I can resize the browser window and the graph resizes and same with the PDF file in Acrobat. So I did my best to have them both at 100%. All I did was use the same ODS options as far as STYLE, and NOGTITLE, NOGFOOTNOTE and then for ODS PDF, I made sure to change the margins and the orientation before ODS PDF started. I also changed the WIDTH and HEIGHT for ODS GRAPHICS, just to be sure that the image filled the entire PDF "page". As you can see I have the date turned off, but page numbering turned on in the other options. Since HTML ignores date/number options, I wanted to leave the page number in so you could see it placed on the top of the output, with the TITLE. When I am making 2 files for comparison purposes, I like to use the ID= suboption to make sure that I am opening the right output file for comparison. In this case, ID= wasn't absolutely necessary, but I also didn't want to clobber any of the automatic HTML files that SAS creates by default (or default PDF files if you have that turned on in EG or SAS Studio). If you try using the ODS example and options that I've used and you are still seeing big differences in the 2 different output files, then I would recommend that you open a case with SAS Tech Support so they can help you zero in on what is happening to make your PDF file so different from your HTML file. You should be able to run my example and only need to change the path from c:\temp to your path to be able to run the code as a test. Hope this helps, Cynthia

Cynthia_sas

Hi: You have several choices for how to practice. As already recommended, you can use SAS OnDemand for Academics with SAS Studio as your interface. OR, you can use your own local installation of SAS. However, please keep in mind that you need to have SAS 9.4 Maintenance level 3 or higher in your local version of SAS in order to run the class and practice everything on your own system. Most of our programming courses have explicit instructions for different methods of practicing. If you look in the Course Overview section of the class, you should see a topic about any required setup and in that topic, we will have instructions for each separate method of practicing. So you can choose which method you want to use. So you don't really need to make a decision with every practice, you decide one time, up front, how you are going to practice. If you want to use the Hands-On Lab, we have instructions for that method. If you want to use SAS OnDemand for Academics, we have instructions for that method. If you want to use your own license for SAS at work, with Enterprise guide, we have instructions for that method. Etc, etc. I believe that in the Programming 1 class set up, we show 5 possible methods of practicing with explicit instructions for each different method. You choose one time which method you're going to use. The demos are performed using SAS Studio on the instructors lab machine. What you see in the demos will most look like the configuration in the Hands-On Lab image. However, as an example, where the instructor shows a data folder location on her Windows machine in a LIBNAME statement on SAS Studio of: s:\workshop\EPG1V2\data you would use /home/u12345678/EPG1V2/data if you were using SAS OnDemand for Academics on a Linux server as your method (where you see u12345678 you'd substitute your own userID for SAS OnDemand). -- note how the class folders -- EPG1V2 and data are the same using both methods and how the part of the folder path that's different is the part that is specific to the operating system that you're working on. Hope this helps minimize the confusion. Cynthia

Cynthia_sas

Hi: Run a simple test without any graphs: ods excel file='c:\temp\class.xlsx'; proc report data=sashelp.class; run; ods excel close; Note that the color-coding in SAS is not always updated for every version. When I use SAS Display Manager, the token "excel" in "ods excel file=..." does not get color coded, but my code works. Without a graph, does the above code created a class.xlsx file in the c:\temp location? If so, then move on and try this code: ods excel file='c:\temp\class_graf.xlsx'; proc report data=sashelp.class; run; proc sgplot data=sashelp.class; scatter x=height y=weight / group=age; run; ods excel close; When I run that code, I get the PROC REPORT output on one sheet and the graph from SGPLOT on a second sheet? If the above code works for you, but your code does not work, then either post your code and some data here or else open a case with SAS Tech Support so they can look at all of your code and your data to try to figure out why your code is not working. Assuming you have the right version of SAS and that you also have the SAS/Access for PC Files component, ODS EXCEL should work with versions of SAS from 9.4 M3 and higher. Cynthia

Cynthia_sas

Hi: HTML and PDF are inherently different types of destinations. PDF is designed as a "measured" destination, with a definite "page" concept, with margins that reduce the available display space on the page and the concept of page breaks. However, HTML is NOT a "measured" destination. There are not any real "margins" in an HTML page because an HTML web page is not intended to be printed. If you do have an HTML page visible in your browser and you print the HTML page, sending the text on the page to a printer is handled by the browser interface to the printer. Any page breaks that are inserted are only there because of the browser's interface to the printer, not because of any instructions that came from SAS or from ODS. By comparison, when you use ODS PDF, to create output, you need to be aware of the margin and orientation options in place before you start to create your output and you also need to be aware of the fact that using tiny font sizes will change where the output inserts the page breaks into the final PDF document. My suggestion is slightly different -- it looks to me as though your title is being handled by ODS, which means that ODS HTML has NOGTITLE set as an option, but your PDF looks like the TITLE is inside the graph image, which means that GTITLE is set as an option for ODS PDF. Having the title inside the graph will take away from the real estate available for the graph image. Your fonts in the PDF file also look a bit fuzzy, so I'd suspect that you need to change the DPI setting and probably the font settings if you want the font to look better. Cynthia

Cynthia_sas

Hi: My memory is that sometimes when both ODS RTF and ODS TAGSETS.RTF are finished writing the RTF file and the file from ODS is handed off to Word, it is possible for Word to mis-measure the page breaking and insert a blank page. I thought I remembered a Tech Support note about this, but I can't find it. I think it might be better for the OP to work with Tech Support on this question because TS can look at ALL their code and at their actual data and see if they can replicate the problem. Cynthia

Cynthia_sas · ‎08-03-2024

Hi: Well, first, since the options available in the TITLE and FOOTNOTE statements work, as shown in your first SGPLOT, there's really no need to use inline formatting. However if you had used ODS HTML NOGTITLE; Before your TITLE statement using the ^S style format, then the TITLE would have been rendered by the active ODS destination, in this case, the default ODS HTML destination. But the simple way to do what you want is to just stick with the first example. Cynthia

Online Status	Offline
Date Last Visited	Wednesday