Repost under Analytics -> Statistical Procedures ... View more

This may help explain: Using Denominator Definitions to Display Basic Frequency Counts and Percentages   ... View more

Try reposting under Programming --> ODS and Base Reporting ... View more

Let me know if the attached meets your needs. It was created with the Table Analysis task. ... View more

Try reposting under: Solutions -> SAS Viya ... View more

It appears only one blank sheet can be added before your data sheet, but here's a work around you can try, add an extra ods options statement.   ods excel file="c:\temp\file.xlsx" options (sheet_name="A" blank_sheet="Information_A"); proc print data = sashelp.class; run; ods excel options (blank_sheet="Information"); ods excel close; ... View more

Slightly different approach /* create sample test */ data test; set sashelp.class; run; %macro createtable(tab); %if %sysfunc(exist(&tab))=1 %then /* check if table exists */ %do; data &tab; set &tab; run; %end; %else %do; /*if table does not exist create a generic table, adjust to your needs*/ data new; length var1 - var5 $ 10; length var6 - var10 8; do i = 1 to 5; output; end; drop i; run; %end; %mend createtable; options mprint; %createtable(test) %createtable(test2) ... View more

Repost under Analytics -> Statistical Procedures ... View more

No.  See documentation  https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/casfun/n1i11h5hggxv65n1m5i4nw9s5cli.htm   ... View more

For the columns you want a total average calculated add MEAN.  The default is SUM. define varname / mean ; ... View more

Have your tried transposing the data into a wide structured table as starting point? Based on sample data provided: /* Sort data by id first, so by can be used in PROC Transpose */ PROC SORT DATA=WORK.BOOK1 OUT=SORT_BOOK1; BY ID; RUN;   /* Transpose data so date form the new columns, added a prefix of D_ to create valid column names */ PROC TRANSPOSE DATA=SORT_BOOK1 OUT=WORK.TRNS_BOOK1(DROP=_NAME_) PREFIX=D_; BY ID; ID StartDate; VAR dx_1; RUN;   /* Use the Data Step to convert numeric columns to character  and concatenate*/ DATA NEW; SET WORK.TRNS_BOOK1; ARRAY D{8} _NUMERIC_; ARRAY CDATE{8} $; DO I = 1 TO 8; CDATE(I) = PUT(D(I),3.); IF CDATE(I)=. THEN CDATE(I)=''; END; PATTERN = CATX(',', OF CDATE1-CDATE8); KEEP CDATE1-CDATE8 PATTERN; RUN;   /* Create list report */ PROC PRINT DATA=NEW; RUN;   Result     ... View more

Try reposting under Programming -> Developers ... View more

Try applying PROC SORT before doing your PROC REPORT.  PROC SORT is great for eliminating duplicate rows.  Here is generalized code based of the report you provided, fill in actual table and column names.  Be careful and name a new output table with OUT= so your original table is not over written.   proc sort data=source_table out=new_table nodupkey dupout=table_with_duplicates; by lesiontype timepoint totalsum dateofexam lesioneval overalleval; run;     ... View more

Have you tried converting the variable type and a full join?  It would help if you could send a sample of the data sources.   PROC SQL; CREATE TABLE tablename AS SELECT COLLATERAL_TYPE_CODE, INPUT(COLLATERAL_SUB_TYPE_CODE, COMMA20.) as COLLATERAL_SUB_TYPE_CODE /* The input function is used to convert character to numeric */ FROM prcr.TB_IFRS9_COLLATERAL_TYPE_MAS as T1 FULL JOIN prcr.TB_IFRS9_COLLATERAL as t2 ON (t1.COLLATERAL_TYPE_CODE = t2.COLLATERAL_SUB_TYPE_CODE); QUIT;     ... View more