How to Remove Blank Space at end of a Page Created by ODS Tagsets.RTF
Suppose that one page can contain up to 35 lines of data besides table title, table header and table footnote. And you set value of a page number variable to
Category: SAS
Introduction on SAS programming in pharmaceutical industry.
Use Hex value to create Carriage Return, Line Feed, CRLF in SAS
It is well known that RTF code ‘\line’ can be used to create a new line in ODS RTF or ODS TAGSETS.RTF destination. But few people know how to create
Generate Special Excel File Using ODS EXCEL
Besides RTF file, SAS programmer also need to produce excel file. Today’s post will present several special examples including how to create empty worksheet, how to highlight worksheet cells or
SAS Functions UNICODE and UNICODEC for DBCS language (Chinese, Japanese, Korean) Transcoding
Perhaps you already noticed that a single Chinese character is displayed using a sequence of characters (like \u34920; for 表) When generating TFL in Chinese. This kind of sequence of
Examples using Perl Regular Expression in DATA Step
Perl regular expressions (PRX） consists of metacharacters which are characters and special characters in essence. SAS searches a source string for substring that matches the Perl regular expression. For example,
How to enable PROC REPORT use full width of page
SAS technical support confirms that PROC REPORT can not use the full width of page. It is a known bug and still has not been addressed. This post will describe
Three Ways (PROC FORMAT or Dynamic BY Variable or SG ANNOTATION) to Display Axis Values
It is well known that detailed visit information is usually displayed as X axis values in graphics. This leads to a problem of how to display character values in axes.
An Example Showing How to customize your GTL graph using annotation
GTL can enable you to add graphics elements to a graph using ODS Statistical Graphics (SG) annotation instructions which are stored in a SAS dataset. It enables you to separate
A simple approach to calculate most recent dosing date before start date of an AE
Sometimes, we have to calculate most recent dosing date before start of a specified adverse event. This post will introduce how to fulfill the task by applying Do-While loop. Sample
Sample SAS code covering all required knowledge of PROC REPORT
In clinical industry, almost every companied would like to use PROC REPORT procedure to develop rtf output. This post will show you tricks that will be used in PROC REPORT.