@ybz12003 wrote: What is the altlog option? If using the code to put copy back in the end, I won't see anything until completing running a batch. Is there a way to monitor the log at the same time? As Tom and Yabwon have showed, you can use PROC PRINTTO to send the log to a file, and then at the end of your code you can read that file to send the text back to your log window.  That is how I do stuff like this when I'm using Enterprise Guide.   If you're using PC SAS (Display manager) in an interactive SAS session, another option is to let your log be written to the default log window, and then you can save the contents of the log file to a text file.  And you can do it with code, using a DM statement with the FILE command to write the log window contents to a file: dm "log; file ""Q:\junk\__mylog.log"" replace;"; But if you want the log messages to be written to your log window and a file at the same time, I think altlog is your best solution.  I've actually never used altlog for that purpose, because I'm happy waiting for the submission to be complete before I can see the log.   I did submit a SAS ballot question years ago to recommend that SAS make it possible to turn on ALTLOG during a session, using an OPTIONS statement, but that suggestion was never implemented, and was not carried over into the new submission system. So I don't think there's much hope for that. ... View more

You can use TRANSLATE() to replace the characters you don't want with something else.    But don't use date values in the style produced by the DATE format.  Strings like that will not sort properly    Also decide whether you want the time the program started, like you said.  Or the time when you ran the DATETIME() function call, like the code you shared.   1 * When SAS started ; 2 %let ts = %sysfunc(translate(%sysfunc(putn("&sysdate9:&systime"dt,e8601dt19.)),___,T:-)); 3 %put &=ts; TS=2024_01_30_18_56_00 4 5 * NOW ; 6 %let ts = %sysfunc(translate(%sysfunc(datetime(),e8601dt19.),___,T:-)); 7 %put &=ts; TS=2024_01_30_19_03_09   ... View more

Hi:   You might also want to search in the documentation and on the support web site. For example, in this example contained in this Tech Support note: https://support.sas.com/kb/25/401.html   You can see that the color for each column inherits the color of the header under which the column is nested. This is known as using style=<parent> which is a style override feature of PROC TABULATE. This feature allows you to do either horizontal or vertical "banding" based on the style characteristics that you associate usually with a CLASSLEV header variable. Cynthia   ... View more

@A_Kh you can get the result with less coding: data want; retain state first_week end_week; set have (rename=(week=end_week9); by state; if first.state then first_week = end_week; if last.state; run; ... View more

could you post your dataset?  ... View more

If instead of something odd like "weekcode" you had an actual DATE value then the QTR function would return the value from the date and this macro wouldn't be needed.   Or whatever need is served by this 'quarter' (and week) value could likely be accomplished with a proper format in analysis or reporting. ... View more

The NV state week gap would use Rule #3b; when the week gap number is equal, choose the start week with the largest number, 2210. ... View more

It is a mistake to think that PROC SQL does not need sorting. It just does the sorting "under the hood", and often in a less efficient way than PROC SORT. TAGSORT only makes sense when you are running out of space in WORK (or UTILLOC), or when you need to sort heavily compressed datasets. Maxim 3: Know Your Data. Decide which variables are needed for your final result, and keep only those by using dataset options for the input datasets in PROC SORT. Which means you may also need the OUT= option in your sort of test1. ... View more

Thank you so much for your help.  I got it. ... View more

Yes, you are right. ... View more

@ybz12003 wrote: Not just display, need to use calculation. Might be interesting to show the calculation involving a year value. Many such might be better done with the Intck or Intnx functions if the calculation involves intervals around dates in any way. ... View more