In addition to @PaigeMiller's very good suggestion, if you find yourself needing a date, time or datetime value to appear in a specific way and none of the very many SAS supplied formats do not quite get you there you can use Proc Format to create your own.  One caveat with custom date/time/datetime formats is that they may not work as axis labels in graphs. ... View more

This is one of the cases where it may be a good idea to include all of the code involved. For example, do you close the connection completely after after reading the data? If not then there might be a locking issue.   Do you or your organization control the website? It is quite likely that displayed html is generated from another source for display as html and that source may well be what needs to be changed. If your organization controls the site then you may be able to work with the site developers/maintenance staff to determine what access and files are needed.  ... View more

Suggest not clearing log when you are having issues like this. It is very likely that the log may have included one or more notes or warnings about why output was not written to the results window.  Did any of the code in the section you call Submit more code with outputs to Results - doesn't update Results include any ODS <destination> CLOSE; statements?    Rerun the code without the Clear log and if the same behavior occurs then you can share the LOG. Best would be to copy the log starting at the procedure that successfully creates results window output and ending with the first procedure that should send output to results window. On the forum past the text copied from the log into a text box opened on the forum with the </> icon that appears above the message window. ... View more

Best practice on this forum when discussing error messages is to copy from the LOG the text of the code submitted and all the notes, messages, warnings and/or errors. Then on the forum open a text box using the </> icon that appears above the message window and paste all of the copied text.   The text box will maintain formatting and  many of these error messages will provide diagnostic information such as column and statement that SAS determines the error appears which gives us more clues as to likely solutions.   Generically this error could come from a statement a procedure doesn't use or something such as a missing semicolon. Another possibility incompatible options.    With that, did the this line show the error? model infection (ref='0')/n=group /s dist=binomila link=logit; Most of the statements that use a / to indicate the start of options only allow a single slash. So if that line threw the error try deleting the / before the S before Dist=. Might want to use Dist=Binomial as well. ... View more

SAS is set up with the Output Delivery System to allow sending one output stream to multiple destinations. By default typically the default is either ODS HTML or possibly the HTML5 destination. This is what is displayed in the results window.    When you add another ODS destination such as ODS EXCEL, RTF or PDF the output is still sent to results unless you close it. The ODS _ALL_ CLOSE recommended will close all ODS destinations and until you direct output to a destination explicitly then any output would tend to generate a warning about no ODS destination open to receive the output.     Knowing the timing of the destination open/close is one of the things you have to look out for.  If you haven't run into it yet, most of the ODS destinations will want an ODS <destination> CLOSE; to actually  write the content to the file and a missing close is a common cause of "by output file is blank/corrupted/locked by a process" depending on what you do to access the file before closing. ... View more

Best would be to show the LOG. Copy the code and all of the other messages from the log. Suggest starting a new session and only running the code to assign the library/data set and the steps you show. If you get the same results then show that log. The new session means there will be less stuff to wade through that might be involved.   That sort of error is a bit odd and may relate to something else you had done earlier, possibly related to which ODS destination(s) are open.   Your question about the Title statement I would say is not likely to be the issue. The use of Title as the same as Title1 goes back about 40 years so I doubt very strongly that it has any effect.  ... View more

Why sgplot?   I would tend to use SGPANEL such as proc sgpanel data=_temp; panelby grp1 grp2/layout=lattice; series x=ind y=y/ lineattrs=( color=red thickness=2 pattern=solid); run;quit; Which, barring many values of grp1 and grp2 automatically creates the correct number of rows and columns. Note that Layout=lattice is for exactly 2 Panelby variables. ... View more

Why do you think that is a storage full error? It states a permissions issue which likely means a configuration issue or your admin doesn't want you accessing the location. ... View more

How good is the documentation of the  file you want to read? As in do you know the variable type, length and possibly the needed Informat such as for dates, times or currency and matching display Format? ... View more

I have a silly (?) question: why do you only have one comma in 345,123456  and several other of your example values? Normally when I see a single comma in a value with that many digits I have to assume comma is from one of the languages that uses a comma for separating the decimal and a . for the thousands separator.   Another approach would be use a custom format with differing digit selectors based on range of values but that would normally have multiple commas in those values. ... View more

Don't forget the DIF function: new_days = review_date - lag(review_date); is the same as new_days = dif(review_date); Same concern as LAG for conditional operation.     ... View more

You show some values with one decimal point displayed. What is the FORMAT currently assigned to the values? By default the displayed values are actually rounded by the format and so an actual value of 254.41 and 254.400338 would both display as 254.4.   See if this yields more of what you expect. The round function will round the values to the tenths decimal before the comparisons. data check1; set example; where round(hours1, 0.1)^= round(hours3,0.1) or round(hours2,0.1) ^= round(hours3,0.1); keep id hours1 hours2 hours3 ; run; ... View more

Looking at the data how do we know which is the "latest" entry? Proc SQL in general doesn't normally do anything in the order of the data set so values of variables need to be defined to determine what "latest" might be.   If you need to process data in the order it appears in a data set then the DATA step does that.   Hint: code that does not do what you need is not sufficient description of the process. You need to include a bit more narrative as to what is required referencing variables and values. ... View more

For graphics related questions it is a very good idea to include some example data in the form of working data step code so we can test your plot.  When macro values are included, if they are at all critical, then you should provide a definition of the macro variables so they will resolve to expected values when testing.   What does your LOG look like? Copy your log text and on the forum open a text box using the </> icon that appears above the message window and paste the text. I suspect there may be error messages related to the LEGENDITEM statement.   ... View more

Example data in the form of a working data step and the code used to create the plot you have is a good way to ask a question. Without your code we don't know the options that may be available in the procedure to add stuff.   Where would the purple flag go?  ... View more