Hello, I have a program below, and I would like to output an Excel file name appending with the program's starting running time.  I found the format is not recognized by the macro.  Please help, thanks. %let StartTime1 = %sysfunc(datetime(), datetime20.); ods excel file="Pathway\Test_&starttime1..xlsx"; And the log shows  SYMBOLGEN: Macro variable STARTFMT resolves to . 53 %let StartTime1 = %sysfunc(datetime(), datetime20.); 54 55 ods excel 55 ! file="Pathway\test_&starttime1..xlsx"; SYMBOLGEN: Macro variable STARTTIME1 resolves to 30JAN2024:17:30:44 ERROR: Physical file does not exist, Pathway\test_30JAN2024:17:30:\05.xlsx.   ... View more

Hello,  Is there a way to output two tabs with two different names and two different table titles in Excel format?  I could my output by assigning one tab with " NESS_Pos " and the other one was automatically changed to " NESS_Pos2" How can I assign to a specific name in the second table and tab? Thanks.   ods excel file="Test_&tdate..xlsx"; ods excel options(sheet_name="NESS_Pos"); title "new NESS tests with positive results only"; proc freq data=test; table updated_timestamp; table epi_message*erv_rslt / list missing; run; title; ods excel close; ... View more

Hello, I'm wondering if there is a way to output a table in color by Proc Tabulate.  For example, I would like to have the "year" in different colors in the following code.  Is it doable?   proc tabulate data=&Pathogen.; Class year state Quarter/ missing; var Test ; table State*(test*f=10.0),year; where Test__groups_ in ('>= 1'); Label State="State" Test="Test Group >=1 counts"; Title '&Pathogen._TestGrpLt1_count'; run; ... View more

Hello,  I'm looking for each state's first week and last week in the sample dataset.  Please help.  Thanks. data Have; length State $5 Week 3; infile datalines delimiter=','; input State Week; datalines; GA,2101, GA,2102, GA,2104, GA,2105, GA,2106, GA,2109, GA,2110, GA,2115, GA,2117, GA,2118, GA,2120, GA,2123, GA,2124, NV,2201, NV,2202, NV,2204, NV,2205, NV,2206, NV,2209, NV,2210, NV,2213, ; data want_week_1st_last; length State $5 Week_start 3 Week_end 3; infile datalines delimiter=','; input State Week_start Week_end; datalines; GA, 2101,2124, NV, 2201,2213, ; ... View more

Hello, The sample macro do loop coding didn't work.  Please help.   %let X1=21; %let X2=22; %let X3=23; %Macro aaa (Pathogen); data Want; set Have; %do i = 1 %to 3; If &&X&i..01 <=WeekCode<= &&X&i..13 then Quarter=1; else if If &&X&i..14 <=WeekCode<= &&X&i..26 then Quarter=2; else if If &&X&i..27 <=WeekCode<= &&X&i..39 then Quarter=3; else if If &&X&i..40 <=WeekCode<= &&X&i..52 then Quarter=4; %end;; run; %mend; %aaa (RSV); The error message was partially shown in the log window below. SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable X3 resolves to 23 MPRINT(AAA): else if If 2327 <=WeekCode <= 2339 then Quarter=3; SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable X3 resolves to 23 NOTE: Line generated by the macro variable "X3". 1 2340 ---- 22 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 3 SYMBOLGEN: Macro variable X3 resolves to 23 MPRINT(AAA): else if If 2340 <=WeekCode <= 2352 then Quarter=4; MLOGIC(AAA): %DO loop index variable I is now 4; loop will not iterate again. MPRINT(AAA): ; MPRINT(AAA): run; ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.RSV may be incomplete. When this step was stopped there were 0 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.99 seconds cpu time 0.06 seconds ... View more

Hello,  I have a sample data set "Have".  I would like to do the following steps:   1. Total Count the week gap greater than 3 based on the state; the result is shown similarly to dataset "want_count". 2. List the start week and end week number based on the state, the result is shown similarly to dataset "want_weekgap_seach". 3. List the start week and end week number based on the following rules, the result is shown similarly to dataset "want_week_gap".     a. the week gap number is the largest in the gap     b. when the week gap number is the same, list the latest week start and end.   data Have; length State $5 Week 3; infile datalines delimiter=','; input State Week; datalines; GA,2101, GA,2102, GA,2104, GA,2105, GA,2106, GA,2109, GA,2110, GA,2115, GA,2117, GA,2118, GA,2120, GA,2123, GA,2124, NV,2201, NV,2202, NV,2204, NV,2205, NV,2206, NV,2209, NV,2210, NV,2213, ; data want_count; length state $5 count_total 3; infile datalines delimiter=','; input state Count_total; datalines; GA, 3, NV, 2, ; data want_weekgap_seach; length State $5 Week_start 3 Week_end 3; infile datalines delimiter=','; input State Week_start Week_end; datalines; GA, 2106,2109, GA, 2110,2115, GA, 2120,2123, NV, 2206,2209, NV, 2210,2213, ; data want_week_gap; length State $5 Week_start 3 Week_end 3; infile datalines delimiter=','; input State Week_start Week_end; datalines; GA, 2110,2115, NV, 2210,2213, ;   ... View more