A missing value is smaller than anything (by definition), so these values are included in the lowchol dataset also. You need to do a semantic change with your statements. ... View more

You don't seem to have followed the instructions for SAS UE that you posted. You made the CERT libref, but not the RESULTS libref. The instructions also seem a little wrong.  Instead of saying "\SASUniversityEdition\myfolders"  it should say that you saved the data into the folder on your real machine that you linked to the virtual machine that is running SAS UE.  The actual path on your machine is probably going to be different than what is listed.  If you are running on Windows it should include at a minimum a drive letter and might have other folders before those listed.  And if you are running on a Unix machine (MACos is a Unix environmnet) then the path is going to use / instead of \ between the folders and will probably have other folders between the root node (/) and your myfolders name. ... View more

You don't seem to have followed the instructions for SAS UE that you posted. You made the CERT libref, but not the RESULTS libref. The instructions also seem a little wrong.  Instead of saying "\SASUniversityEdition\myfolders"  it should say that you saved the data into the folder on your real machine that you linked to the virtual machine that is running SAS UE.  The actual path on your machine is probably going to be different than what is listed.  If you are running on Windows it should include at a minimum a drive letter and might have other folders before those listed.  And if you are running on a Unix machine (MACos is a Unix environmnet) then the path is going to use / instead of \ between the folders and will probably have other folders between the root node (/) and your myfolders name. ... View more

Please consider the following possible value of Parkname Yellowstone NP ^ 13 ^ 11 Pasting into a box opened on the forum with </> uses a fixed width font so it is easy to see where characters are by count. The Find for 'NP' will return 13, the value under the first ^ character. Note that the end of Yellowstone, the second ^ character is in column 11. So to get to the last position (or character or column depending on how you want to think of it) you subtract 2 from 13 to get 11. We suspect that 2 is the correct value because most times we place a single character between words. Note that this will also work if the character between the NP and the ending "E" of Yellowstone is any single character.   This is very common sort of parsing of words. We might not use the simpler Scan function that would work for Yellowstone because of names like "Monument Valley" "Crater Lake" or "Black Canyon of the Gunnison" to name some National Parks in the US. ... View more

Below example shows you when first.<variable> and last.<variable> gets a value of 1 (TRUE) or value of 0 (FALSE). If you want to select rows from a sorted source table where there is only a single row in a by group then you need to use IF first.<variable> AND last.<variable>. That's the logic which will select the row where ParkName is BBB in above sample.  ... View more

It means that  monthmax & locationmax   are retained too, but with no initial value (i.e. set to missing). ... View more

You already have your answer, but I want to add this: Bookmark this link in all your browsers: SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation  so you can make full use of Maxim 1 when it comes to SAS programming. The documentation for your particular question is found here: TITLE Statement  ... View more

You could try it yourself and find out. ... View more

Usually, when referring to variable names the case is not important. ... View more

Options, such as Orientation are like car doors. If you open a car door then it stays open until you close it. So options once set remain in effect until until you change them.   The ODS statement sets options related to ODS destinations. The ODS Graphics sets options related to ODS graphics. The Options statement sets options for the system.   Simple concept.   If you need to know more about options in effect at a given part of your program Proc Options can tell you that (read the log). ... View more

The question illustrates a common mistake: defining a library, but then missing to use it in the following code.   Defining a library with the XLSX engine does not create anything; only when data is written to this library, the Excel file will be created if it did not yet exist. ... View more

For #1 no.  For #2, not sure, try that one. ... View more