I would like to set a variable so that proc format always subtracts 3 years from today (). Date_old should be substract todaty_date - 3 years and given 2019 for example This is my code: %let date_old=%sysfunc(YEAR(Today()-3), yymmd7.); proc format; value date_less low-'date_old' = 'Exp' other=[yymmd7.]; run; But i see error on log : NOTE: Writing HTML5(EGHTML) Body file: EGHTML ERROR: Required operator not found in expression: Today()-4 ERROR: Argument 1 to function YEAR referenced by the %SYSFUNC or %QSYSFUNC macro function is not a number. ERROR: Invalid arguments detected in %SYSCALL, %SYSFUNC, or %QSYSFUNC argument list. Execution of %SYSCALL statement or %SYSFUNC or %QSYSFUNC function reference is terminated. 27 ... View more

i have a problem i chose data already and i would like to show them using a simple bar chart however. I totally don't do it. my data: Customer1 Customer2 23771 27636 my code : proc sql; create table graphbar as select ak.CUSTOMER1, wy.CUSTOMER2, from(select sum(product) as CUSTOMER1, from sold ak cross join (select sum(product) as CUSTOMER2 from buy wy ; quit; proc SGPLOT data = graphbar; vbar CUSTOMER1; vbar CUSTOMER2 ; run; quit; ... View more

Is it possible to save the result of proc print in excel format as export and not in html? proc print data=diff n noobs sumlabel='Titak' grandtotal_label='Grand Total'; sum Custmer Price Sold ; ... View more

This is my first time here, I hope that you will help me. I would like to add SUM / MEANS as a summary using Proc Reports. ?The following code does not help me if there is any possibility   proc report data=customer; column date customer ,number_sold define date / group; define customer / across; define number_sold/ mean; define number_sold/ sum; run;   DATE Customer 1 Customer 2 2021-08 1 95 2021-08 2 77 SUM 3 172 Mean 1,5 86 ... View more