comp.soft-sys.sas - The SAS statistics package.
Hi All, I am working on a listing. I though to use the data _null_ and ods pdf as this listing have lot of indentations and formatting. Everything is fine but i just want to increase the font size of the body. I did for titles and footers. I don't want to use the proc template. Is there any way that just a simple option/statement which can change the font size. I used the FONT = option but it didn't work properly. I just need to increase the font size of all the text which i am displaying using put statement in Data _null_. Thank you for your time.
Hi, I have an old report that uses the data _null_ step to create a text report. I would like to create a pdf report. When I add an ods statement to create a pfd report, I see some misalignment and the cause of the misalignment is funny rectangles with x in them. Has anyone seen this before? This doesn't occur when I create a html file. Renu
Hi, The NULL and NOT NULL are terms used to define a table in a database and is not a SAS-specific term. If I understand it right, NULL is a spesific data value, the '00'x. That is: '00' is the hexadecimal value of NULL. When using NULL when you define a table in a database, you tell the DBMS that "this field is allowed to contain the data value '00'x, right ? Similarly, when defining a database with NOT NULL, you tell the DBMS that "this field is not allowed to contain the data value '00'x, right again ? Or is it right to say that NOT NULL means that "this field must contain a value, but the value cannot be '00'x ? Then to the point: How does SAS test for the occurence of the data value NULL ? What does the following piece of code do ?: proc sql; create table mytable as select var1, var2, var3 from mytable_2 where var2 is not null or var3 is not null ; quit; What exactly does 'is not null' and 'is null' test for in SAS ? Does it test just for occurences of SPACE ('20'x) ? If 'IS NOT NULL' does not test the absence of '00'x, how shold the PROC SQL above be written to take that into account ? When extracting a flat file from a database table, will a value of '00'x in the table field be transferred to the file ? And when reading that file into a SAS dataset, will the '00'x value also be transferred from the file to the dataset ? Regards, Rune
Hi, guys. I installed the latest Hot Fix for ODS. But it seems that there's one more bug. I'm trying to customize PDF TOC (table of contents). I got 21 datasets and want to display a link to each of them in the PDF TOC when I display them with PROC REPORT. For some reason I see links only to the last 7 of them. I wonder if anyone encountered it before. Any suggestions are welcomed Here's my code: Macro variable ALLDSNAME resolves to AE APO CHEM COAG CONMED CRIT_EP CVHX CVPE DEMOG DISP DOSE ECG EXCRIT HEMA HX INCRIT PE RAND RISK URIN VITALS SYMBOLGEN: ods pdf file="E:\Therapeutic Area\compound &comp\&num\sas\external files\&study._metadata.pdf"; ..................................... ods proclabel='Table of Contents' ; proc print contents=''; title1 "&study Dataset Contents"; run; ............................................ %macro allreport; %do i=1 %to 21; %do; ods proclabel="%SCAN(&alldsname.,&i.)" ; proc report data=temp ls=170 split='|' nowindows contents='' ; columns DSNAME variable varlabel type informat format length comment ; define DSNAME/display width=8 flow 'Library|Member|Name' noprint ; define variable/display width=10 flow 'Variable|Name' ; define varlabel/display width=10 flow ; define type/display width=10 flow ; define informat/display width=10 flow 'Variable|Informat' ; define format/display width=10 flow 'Varibale|Format' ; define length/display width=8 flow 'Variable|Length' ; define comment/display width=30 flow ; title "%SCAN(&alldsname.,&i.)"; where dsname eq "%SCAN(&alldsname.,&i.)"; run; %end; %end; %mend; %allreport; ods pdf close; run; Igor Kurbeko Clinical Programmer Analyst 678 336 4328 XXXX@XXXXX.COM <mailto: XXXX@XXXXX.COM > <mailto: XXXX@XXXXX.COM > If you torture data sufficiently, it will confess to almost anything.