@Tom,    Thanks for the esthetic commentary.  🙂  Yes, both pieces of code do essentially the same thing.   Jim ... View more

Hi, @ChrisHemedinger    That makes sense.  Thanks for taking the time to respond. Jim ... View more

OK, so here's some code.  The results are below the code.  Is this what you need?  In the results I have two tables.  The first is not categorized into ranges.  I just put the first table there so you can see the difference that the Proc Format makes when I assign the ranges.  The TITLE function that I used should be replaced by a TITLE (without a %) that is suitable for your SAS environment.   Jim TITLE; FOOTNOTE; OPTIONS VALIDVARNAME = ANY; DATA Client; INPUT pid County $ Disease $; DATALINES; 123 ABC Chlam 124 DEF Chlam 134 EFG Syph 135 HIJ Gon 209 KLM Chlam 103 ABC Chlam 120 DEF Chlam 131 EFG Syph 133 HIJ Gon 201 KLM Chlam 123 ABC Chlam 101 ABC Chlam 129 ABC Chlam ; RUN; %TITLE(Data - Client); PROC FREQ DATA=Client NOPRINT; TABLE County / Out=Client_Freqs; WHERE Disease='Chlam'; RUN; %TITLE(Data - Client_Freqs); PROC PRINT DATA=Client_Freqs NOOBS; VAR County Count; RUN; PROC FORMAT; VALUE Chlam_Range 0 = '0' 1 - 3 = '1-3' 4 - 19 = '4-19' 20 - 49 = '20-49' 50 - 300 = '50-300' 301 - HIGH = '>300' . = 'Missing' OTHER = 'Invalid' ; RUN; %TITLE(Data - Client_Freqs); OPTIONS LABEL; PROC PRINT DATA=Client_Freqs (RENAME=COUNT='# of Case Range'n) NOOBS; FORMAT '# of Case Range'n Chlam_Range6.; VAR County '# of Case Range'n; RUN; Results:   ... View more

@richardmgb,   If you have an issue, let's please open a new topic.  This topic from 2017 is dead, dead, dead.  🙂   thanks,   Jim ... View more

Hi, @George12,   May I ask which SAS product you are using? I am using SAS 9.4 M6.   In SAS, in just about every context I can think of, &C would invoke the macro language processor.  What if you were to try just "color" without the preceding ampersand?   This code: ODS Excel CLOSE; OPTION Device=ACTXIMG; TITLE "Test Report"; FOOTNOTE color=red "Red " color=green " Green " color=blue "Blue"; ODS Excel OPTIONS( Frozen_Headers="1" Frozen_RowHeaders="1" Sheet_Name="Test" Embedded_Titles="YES" Embedded_Footnotes="YES" Embed_Footnotes_Once="YES" Gridlines="YES" ); PROC PRINT DATA=SASHELP.Cars (OBS=15); RUN; ODS Excel CLOSE; The color in the footnotes appears to match what I coded; see below. Note that I just used a regular footnote rather than PRINT_FOOTER.     Jim       ... View more

@ChrisHemedinger wrote: Use free cloud-based SAS in your web browser With the continued enhancements of SAS Studio and given Viya's integration with SAS studio, one must wonder whether Display Manager and Enterprise Guide's day's are numbered.  It would seem to make sense to maintain only one interface (Jupyter notebooks being a possible exception), particularly as SAS Studio comes up to speed in comparison to the other interfaces.  Has the SAS Institute any guidance in this direction?  We may be moving to a grid environment soon.  I'd rather not recommend learning Enterprise Guide if it is going to be deprecated and Studio is really the direction things are heading.   Jim ... View more

@alepage wrote: one of the field : client_email value are converted to the second value instead of the first value.  @ is converted into à   Is there a simple way to avoid that?   66 || IRDENNIS@ICLOUD.COM IRDENNISàICLOUD.COM Is the same issue as on your other post?  Is this from EBCDIC?   As a quick work-around, you could do the below, but if there are other à characters in the data, this will not work.  For example, and email address of Thomas_à_Kempisàemail.com would not work with this quick work-around.  You would have to examine your data.   Jim     DATA Have; INPUT Email_Address : $64.; DATALINES; IRDENNISàICLOUD.COM ; RUN; DATA Want; SET Have; Email_Address = TRANSLATE(Email_Address,'@','à'); RUN;     ... View more

@alepage,   Would it be possible for you to run the below SAS code?  I don't need to know all the output, but I do want to know what the hexadecimal codes are for à, À, and @.   On my system, they are as follows:   Hex=40, Character=@ Hex=C0, Character=À Hex=E0, Character=à What are they in your environment?     Jim   Please run this code:   %LET Null = ; %LET sQuote = %STR(%'); %LET dQuote = %STR(%"); %LET Semi = %BQUOTE(;); %LET Nte2 = NOTE-; *%PUT NOTE: >%BQUOTE(&Semi)<; DATA _NULL_; ARRAY Digits {16} $1 _TEMPORARY_ ('0' '1' '2' '3' '4' '5' '6' '7' '8' '9' 'A' 'B' 'C' 'D' 'E' 'F'); DO _i = 1 TO 16; CALL SYMPUTX(CATS('Digit', STRIP(PUT(_i,2.))), Digits{_i}, 'G'); END; STOP; RUN; &NULL %MACRO Generate_Hex_Displays; %LOCAL i j; %DO i = 1 %TO 16; %DO j = 1 %TO 16; Character = &sQuote.&&Digit&i&&Digit&j&sQuote.x&Semi PUTLOG &dQuote&Nte2 Hex=&&Digit&i&&Digit&j, &dQuote Character=&Semi %END; %END; %STR(PUTLOG "&Nte2 ";); %MEND Generate_Hex_Displays; %LET PS_Save = %SYSFUNc(GETOPTION(PS)); OPTIONS PS = MAX; DATA _NULL_; %UNQUOTE(%BQUOTE(%Generate_Hex_Displays)); STOP; RUN; OPTIONS PS = &PS_Save;     ... View more

This doesn't sound like a SAS issue per se.  It sounds like an encoding issue.  The $EBCDIC format is translating whatever the hexadecimal code is for an @ sign on the mainframe to what it thinks should be an @ sign in ASCII.  However, it looks like your Windows environment is translating that hexadecimal code to an à.     The hexadecimal value for an @ sign is x'7C' in EBCDIC.  In your particular Windows environment, do you know what x'7C' is?  What is the hexadecimal code for an @ sign in your environment?   Jim ... View more

Below is an example of how to do something very close to what you want.  I'm using calendar year in this example, but I believe you want a 365 day period not just calendar year.  You would need to modify my example if calendar year is not what you want, but the solution should be along the lines of what I have coded.   Jim   data WORK.docs_have(label='Surgery Data'); input rcpt_id:32. service_date:date9. physician_id:32.; format service_date date9.; datalines; 1356 22NOV2008 3354 1123 13OCT2010 3354 1267 18JAN2011 3354 1123 15AUG2011 3354 1145 30NOV2009 2234 1323 24JAN2010 2234 1122 29JAN2010 2234 1122 13SEP2010 2234 ;;;; run; PROC SQL; CREATE TABLE WORK.Surgery_Volume AS SELECT Physician_ID , YEAR(Service_Date) AS Year ,COUNT(YEAR(Service_Date)) AS Total_Vol FROM WORK.Docs_Have GROUP BY Physician_ID, Year ; QUIT; PROC SQL; CREATE TABLE WORK.Docs_Vol AS SELECT Rcpt_ID ,Service_Date ,Docs.Physician_ID ,Year ,Total_Vol FROM WORK.Docs_Have Docs INNER JOIN WORK.Surgery_Volume Surg ON Docs.Physician_ID = Surg.Physician_ID AND YEAR(Service_Date) = Year ; QUIT; PROC SORT DATA=WORK.Docs_Vol; BY Physician_ID Year Total_Vol; QUIT; DATA WORK.Docs_Want; DROP Year Total_Vol ; SET WORK.Docs_Vol; BY Physician_ID Year Total_Vol; IF Total_Vol > 1 THEN DO; IF FIRST.Total_Vol THEN Surg_Vol = 1; ELSE Surg_Vol + 1; END; ELSE DO; Surg_Vol = 0; END; RUN; Results:   ... View more