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
Featured
Move items up and down in a QListView
I have been trying to develop a GUI application which can be used for batch run this week. One expected feature is to extract name of all SAS program files
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
Common Manipulation of QTreeview using PyQT5
When developing a GUI (graphical user interface) application, I found that lot of people posted questions in Stack Overflow to seek help on how to manipulate QTreeview Widget. However, few
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
Programmatically Create New Workbook and Insert a Worksheet Change Event Using VBA
It is not difficult to generate a new workbook using Excel VBA. And there are tons of materials in internet that can teach you how to achieve it. Today I
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,
Extract System Organ Class of various MedDRA versions from PDF files using Python
EUTCTID for MedDRA system organ class is required when developing XML file for EMA version. Previously, MedDRA terminology was available free of charge through EUTCT system website. However, EUTCT has
Python Installation by using Anaconda
Machine learning becomes more and more popular in Pharmaceutical industry to fulfill task like ADaM development or CSR translation. Python is used widely in machine learning area. One way to