Hello,    I would like to update the "ED_charge / INP_charge / ICU_charge" in the sample dataset below (1st SAS code) based on the different timelines and IF factors (2nd SAS code).  For example, the new "ED_charge_ / INP_charge_ / ICU_charge_" columns will all multiply by 1.25 because the test date is in the range between 01JAN2016'<= TestDate <= '31MAR2016'.  Please help me to approach it; thanks.   data charge; input ID $ TestDate:ddmmyy10. ED_charge INP_charge ICU_charge; format TestDate ddmmyy10.; datalines; LLL 01/04/2016 1780 1200 4000 UUU 03/09/2017 3000 5000 8000 OOO 09/08/2018 5900 2400 5000 ; run; if '01JAN2016'd <= TestDate <= '31MAR2016'd then IF= 1.25; if '01MAR2017'd <= TestDate <= '31MAY2017'd then IF= 1.24; if '01SEP2018'd <= TestDate <= '31DEC2018'd then IF= 1.23; ... View more

Hello,  There was an error massage on the Log window.  Please help, thank you. %macro covdate(regpronum,regprodate1); %let i=(&rr + 1); %let rr=%eval(&i); proc sql; create table cov&rr as select studysite, scrdate, caseid, c_ageyears, c_agemonths, covidsource, &regpronum, &regprodate1 from ds2cov where covidsource in(1,2,3) and &regpronum>=1 and &regpronum ^= 888 and &regprodate1 ^= '08aug8888'd and ((&regprodate1>"&bdate1."d or &regprodate1=.) or (c_ageyears>15 and &regprodate1<'12DEC2020'd) or (12<=c_ageyears<=15 and &regprodate1<'12MAY2021'd) or (5<=c_ageyears<=11 and &regprodate1<'02NOV2021'd) or (c_ageyears<5 and &regprodate1<'18JUN2022'd)) order by studysite,caseid; %let cov_&rr=%str(&regpronum. >=1 and not 888 while &regprodate1 may not be valid, please confirm); ods proclabel "Check &rr:&&&cov_&rr"; data cov&rr; length var1 $150; set cov&rr; var1="scrdate="||trim(left(put(scrdate,mmddyy10.)))||','|| "dataset date="||trim(left(put("&bdate1"d,mmddyy10.)))||','|| "c_ageyears="||trim(left(put(c_ageyears,3.)))||','|| "c_agemonths="||trim(left(put(c_agemonths,3.)))||','|| "covidsource="||trim(left(put(covidsource,3.)))||','|| "&regpronum.="||trim(left(put(&regpronum,3.)))||','|| "&regprodate1.="||trim(left(put(&regprodate1.,mmddyy10.))); run; %createcov; %mend covdate; %covdate(covnum,covdt1);   MPRINT(ARICOV): ; MLOGIC(COVDATE): Beginning execution. MLOGIC(COVDATE): Parameter REGPRONUM has value covnum MLOGIC(COVDATE): Parameter REGPRODATE1 has value covdt1 MLOGIC(COVDATE): Parameter REGPRODATE2 has value covdt2 MLOGIC(COVDATE): %LET (variable name is I) SYMBOLGEN: Macro variable RR resolves to 7 MLOGIC(COVDATE): %LET (variable name is RR) SYMBOLGEN: Macro variable I resolves to (7 + 1) MPRINT(COVDATE): proc sql; SYMBOLGEN: Macro variable RR resolves to 8 SYMBOLGEN: Macro variable REGPRONUM resolves to covnum SYMBOLGEN: Macro variable REGPRODATE1 resolves to covdt1 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRONUM resolves to covnum SYMBOLGEN: Macro variable REGPRONUM resolves to covnum SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 NOTE: Line generated by the invoked macro "COVDATE". 2 ((&regprodate2 - 22 76 SYMBOLGEN: Macro variable BDATE1 resolves to 28FEB2023 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 MPRINT(COVDATE): create table cov8 as select studysite,caseid,scrdate,c_ageyears, c_agemonths, covidsource,covnum, covdt1, covdt2 from ds2cov where covidsource in(1,2,3) and covnum>=2 and covnum ne 888 and covdt2 ^= '08aug8888'd ((covdt2>"28FEB2023"d or covdt2=.) or (c_ageyears>15 and covdt2<'12DEC2020'd) or (12<=c_ageyears<=15 and covdt2<'12MAY2021'd) or (5<=c_ageyears<=11 and covdt2<'02NOV2021'd) or (c_ageyears<5 and covdt2<'18JUN2022'd))) order by studysite,caseid; ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, <, <=, <>, =, >, >=, AND, EQ, EQT, GE, GET, GROUP, GT, GTT, HAVING, LE, LET, LT, LTT, NE, NET, OR, ORDER, ^=, |, ||, ~=. ERROR 76-322: Syntax error, statement will be ignored. SYMBOLGEN: Macro variable RR resolves to 8 MLOGIC(COVDATE): %LET (variable name is COV_8) SYMBOLGEN: Macro variable REGPRONUM resolves to covnum SYMBOLGEN: Macro variable REGPRODATE2 resolves to covdt2 SYMBOLGEN: Macro variable RR resolves to 8 SYMBOLGEN: && resolves to &. SYMBOLGEN: Unable to resolve the macro variable reference &cov_ SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable RR resolves to 8 SYMBOLGEN: Macro variable COV_8 resolves to covnum >=2 not 888 while covdt2 may not be valid, please confirm SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing. MPRINT(COVDATE): ods proclabel "check 8:covnum >=2 not 888 while covdt2 may not be valid, please confirm"; SYMBOLGEN: Macro variable RR resolves to 8 NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

Hello, I have error messages shown in the log window when I try to do an array.  Please help; thanks.   data ds2; set ds1; array Var_Num{i} hcsfpcrothresult rapidrsvothersp ; array Var_Cha{i} hcsfpcroth_result rapidrsvother_sp ; do i = 1 to dim(Var_Cha); Var_Num{i}=put(Var_Cha{i}, 3.); drop Var_Num{i}; end; run; 1883 array Var_Num{i} hcsfpcrothresult rapidrsvothersp ; - 22 202 ERROR: Too many variables defined for the dimension(s) specified for the array Var_Num. 1884 array Var_Cha{i} hcsfpcroth_result rapidrsvother_sp ; - 22 202 ERROR: Too many variables defined for the dimension(s) specified for the array Var_Cha. ERROR 22-322: Syntax error, expecting one of the following: an integer constant, *. ERROR 202-322: The option or parameter is not recognized and will be ignored. 1885 do i = 1 to dim(Var_Cha); 1886 Var_Num{i}=put(Var_Cha{i}, 3.); 1887 drop Var_Num{i}; - 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, -, :, ;, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_. ERROR 76-322: Syntax error, statement will be ignored. 1888 end; ... View more

Hello, How to extract a Month and Year from the format, 11/12/2018?  Thank you. ... View more

Hello, I ran over one thousand lines of macro codes.  In the end, there was an error message shown in the log window.  I could not get my PDF file exported. Please help.   ERROR: Undetermined I/O failure. ... View more

Hello, I have a sample code below; I would like to calculate the age and ICU column percent of Sum_cost.  Is there a way to approach it? Thanks. proc tabulate data=DataIn; var Cost_Sum; class age ICU; table (age ICU),(Cost_Sum) *(N mean std median p25 p75 sum); run; ... View more

Hello, I created a sum variable to calculate the sum of three columns; I found out that the function didn't work in the missing value.  Please help; thanks.  data Cost; Format IDs $10. ED DOLLAR15.2 ICU DOLLAR15.2 Lab DOLLAR15.2; inFormat IDs $10. ED ICU Lab comma15.; infile datalines delimiter='/'; input IDs ED ICU Lab; datalines; EC1R00002/ 899.28/ / 256.31/ KC1Y00012/ / 11,080.82/ 619.91/ WC1G00013/ 332.34/ 929.71/ 2,066.98/ ; data Cost_Sum; set Cost; sum=ED+ICU+Lab; run; .     ... View more