Is there a SAS function which returns the month based on the week identifier?   Ex.: Week 26 => 06 or    Week 26 => JUNE ... View more

dear SAS experts,   I used the following code and get a bunch of errors:   %let Auswertungstag=%sysfunc(today()); *%let Auswertungstag = %sysevalf('01JAN2021'd); %put &Auswertungstag.; %let Jahr = %year(&Auswertungstag.); %put &Jahr. ; %let Monat = %month(&Auswertungstag.); %put &Monat.; data KW_DrK; format VKW_DrK best2.; Tag = %eval(&Auswertungstag.); %kwdrk(&Auswertungstag.); if KW_DrK = 1 then VKW_DrK = 52; else VKW_DrK = KW_DrK - 1; if VKW_DrK = 52 then Jahr = &Jahr.-1; else Jahr = &Jahr.; VKW_DrK = compress(VKW_DrK); call symput('VKW_DrK',VKW_DrK); %put &VKW_DrK.; call symputx ('Dateiname',cats('Dr_Klein_KW_Reporting_',Jahr,'_KW',&VKW_DrK.)); call symputx('Zeitraum', cats(Jahr,'_KW',&VKW_DrK.)); run; %put &Dateiname. &Zeitraum.; here the logfile:   592 %let Auswertungstag=%sysfunc(today()); 593 *%let Auswertungstag = %sysevalf('01JAN2021'd); 594 %put &Auswertungstag.; 22442 595 596 %let Jahr = %year(&Auswertungstag.); 597 %put &Jahr. ; 2021 598 599 %let Monat = %month(&Auswertungstag.); 600 %put &Monat.; 6 601 602 data KW_DrK; 603 format VKW_DrK best2.; 604 Tag = %eval(&Auswertungstag.); 605 %kwdrk(&Auswertungstag.); 606 if KW_DrK = 1 then VKW_DrK = 52; 5 The SAS System 14:11 Friday, June 11, 2021 607 else VKW_DrK = KW_DrK - 1; 608 if VKW_DrK = 52 then Jahr = &Jahr.-1; 609 else Jahr = &Jahr.; 610 VKW_DrK = compress(VKW_DrK); 611 call symput('VKW_DrK',VKW_DrK); 612 %put &VKW_DrK.; WARNING: Apparent symbolic reference VKW_DRK not resolved. &VKW_DrK. 613 call symputx ('Dateiname',cats('Dr_Klein_KW_Reporting_',Jahr,'_KW',&VKW_DrK.)); _ 386 200 76 WARNING: Apparent symbolic reference VKW_DRK not resolved. 614 call symputx('Zeitraum', cats(Jahr,'_KW',&VKW_DrK.)); _ 386 200 76 WARNING: Apparent symbolic reference VKW_DRK not resolved. ERROR 386-185: Expecting an arithmetic expression. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 615 run; NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 610:20 611:23 NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 610:11 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.KW_DRK may be incomplete. When this step was stopped there were 0 observations and 9 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: Apparent symbolic reference DATEINAME not resolved. WARNING: Apparent symbolic reference ZEITRAUM not resolved. 616 %put &Dateiname. &Zeitraum.; &Dateiname. &Zeitraum. how can I correct this?   regards PY ... View more

dear SAS experts,   I have numeric variables for YEAR (ex: 2021) and MONTH (ex: 5) and I want to get a new variable like: YYYYMM in NUMERIC, where the month Always on 2 Digits is ; for instance: 202105.   How can I get this?   thanks in Advance, regards PY ... View more

dear SAS experts,   I typed:   proc report data=class; column name age; define name / display; define age / display; compute age; if age < 65 then call define (_row_,'style' compute,'style=[background=lightblue]'); endcomp; run; and got the following error message: 1 if age < 65 then call define (_row_,'style' compute,'style=[background=lightblue]'); _______ 22 ______ 2 The SAS System 16:33 Wednesday, April 28, 2021 253 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. ERROR 253-185: The DEFINE subroutine call has too many arguments. how should I correct the error?   thx, regards PY ... View more