Hello,   I am trying to write a program on Viya to save all in-memory tables in a particular set of caslibs. I have written code that can identify the caslibs and iterate through them to do something (for now, just print the names of the tables).   proc cas; table.caslibinfo result=caslibs / active=false srcType="PATH" showHidden=true; caslibNames = caslibs.caslibinfo.where(Name LIKE 'text%')[,'Name']; do name over caslibNames; print name; /* show current caslib name */ table.tableInfo result=tables / caslib=name; if tables[1] ne . then do; /* if statement skips caslibs that have no tables */ tableNames = tables.tableInfo[,'Table Name']; do name over tableNames; print name; /* show table name, replace with code to save table */ end; end; end; run; I've been looking at the table.save action, but I can't figure out how to programatically specify the caslib and table names based on where the program currently is in the do loops.   Any advice would be welcomed! Thank you! ... View more

Hello, I am trying to use PROC REPORT and ODS PDF to generate a stylized report with alternate row highlighting. There is a gap or white border appearing between columns on the rows and the summary border that I cannot figure out how to get rid of, despite playing with various BORDERWIDTH and BORDERSPACING options. The spacing does not appear when I run only the PROC REPORT code and view the output in the Results Viewer, but it does appear in the PDF (see attached file). Any thoughts on what I'm doing wrong? Thanks in advance. OPTIONS NODATE NONUMBER NOCENTER NOBYLINE TOPMARGIN="1IN" BOTTOMMARGIN="1IN" LEFTMARGIN="1IN" RIGHTMARGIN="1IN" MISSING=' '; ODS ESCAPECHAR='^'; ODS PDF FILE="&MPGDRIVE\TEST DOC.PDF" UNIFORM NOTOC; ODS PDF STARTPAGE=NO; PROC REPORT DATA=SASHELP.COMPANY NOWINDOWS HEADLINE MISSING     style(report)={outputwidth=100% rules=none frame=void borderspacing=0}     style(header)={borderwidth=0 borderspacing=0 backgroundcolor=cx990000 color=white font_size=16pt font_face='Franklin Gothic Demi Cond'}     style(column)={borderwidth=0 borderspacing=0 font_size=12pt font_face='Franklin Gothic Medium Cond'}     style(summary)={borderspacing=0 bordertopwidth=2 bordertopcolor=black font_size=16pt font_face='Franklin Gothic Demi Cond'}; COLUMN ('Level 3' LEVEL3) LEVEL2,N; DEFINE LEVEL3 / GROUP '' STYLE(COLUMN)=[CELLWIDTH=3.4IN borderspacing=0]; COMPUTE LEVEL3;     COUNT+1;     IF (MOD(COUNT,2)) THEN CALL DEFINE(_ROW_, 'STYLE','STYLE=[BACKGROUND=#FFCCCC borderspacing=0]');     IF _BREAK_='_RBREAK_' THEN CALL DEFINE('LEVEL3','style','style=[pretext="Total"]');     IF _BREAK_='_RBREAK_' THEN CALL DEFINE(_ROW_, 'STYLE','STYLE=[BACKGROUND=#FFFFFF]'); ENDCOMP; DEFINE LEVEL2 / ACROSS '' STYLE(COLUMN)=[borderspacing=0]; DEFINE N / '' FORMAT=COMMA8.0 STYLE(COLUMN)=[CELLWIDTH=1IN borderspacing=0]; RBREAK AFTER / SUMMARIZE; RUN; ODS PDF CLOSE; ... View more