Selecting N rows from a dataset or K-th element from a macro variable is a common data manipulation process. This post is listing the ways how to resolve these questions.
Handling Duplicates and Missing values - SASlearner
Handling the duplicates and missing values in data manipulation is a very common process. This post is taking a few examples to list how to accomplish it from a datasets in SAS.
Displaying Descriptive Statistics for Variables - SASlearner
This post is talking about how to display descriptive statistics for variables quickly. In the sense that we would like to know an usual and agile way to accomplish it in SAS.
Listing Column Names in SAS - SASlearner
Sometimes we would want to list column names of a SAS dataset, which can be useful in other programs, such as
Output Log to Text file in SAS - SASlearner
Standing up a flag here, I'm planning to keep a series of notes to minute my questions met in sas learning. Practice is the best teacher, practice makes perfect!
R package development - as a beginner
Date Format (SAS & R)
Assume that you
input a character string
20211109 with a sas format like
yymmdd8. that specifies how sas must interpret the character string, you will get a numeric number
Graphical displays of data (SAS & R)
This is reference to the "Chapter 8 A graphical compendium" in <SAS and R: Data Management, Statistical Analysis, and Graphics (second edition)>.
I believe that the capability of data science is more than just building predictive models, data visualization is also an integral part, especially in a convincing way.
Statistical functions and procedures (SAS & R)
This is reference to the "Chapter 3 Statistical and mathematical functions", "Chapter 4 Programming and operating system interface" and "Chapter 5 Common statistical procedures" in <SAS and R: Data Management, Statistical Analysis, and Graphics (second edition)>.
Dataset manipulation (SAS & R)
This is reference to the 2.3 section of Data management and 2.4 Date and time variables in <SAS and R: Data Management, Statistical Analysis, and Graphics (second edition)>.
处理数据，常见的不外乎combination, collation, and subsetting
Derived variables and string manipulation (SAS & R)
This is reference to the 2.1 to 2.2 section of Data management in <SAS and R: Data Management, Statistical Analysis, and Graphics (second edition)>.
Data input and output (SAS & R)
我一直想找一个合适的方法来记录SAS的学习笔记，最好能结合以往的编程经验（如R or Python）；我想到了当初学习Python的时候是根据实际需要，结合R/Perl的既往经验来互补学习，那么SAS也是可以这样。
How to connect to Gitlab Repository
What is Git?
Git is a version control system used to track changes in computer files. Git's primary purpose is to manage any changes made in one or more projects over a given period of time. It helps coordinate work among members of a project team and tracks progress over time. Git also helps both programming professionals and non-technical users by monitoring their project files.
What is Gitlab?
GitLab is a web-based Git repository that provides free open and private repositories, issue-following capabilities, and wikis. It is a complete DevOps platform that enables professionals to perform all the tasks in a project—from project planning and source code management to monitoring and security. Furthermore, it allows teams to collaborate and build better software.
RStudio Shiny Publish - 中文编码
Reading notes for SAS Programming in the Pharmaceutical Industry book
This post is the reading notes for the e-book “SAS Programming in the Pharmaceutical Industry” to keep recording some knowledge points about pharma programming.
Alluvial plot and Sankey diagram in R
I have a strong interest in data visualization. For me, the purpose to learn this skill is driven by having a good understanding and examination for the question one wants to solve.
Programming in pharma using SAS
It is not to be denied that sas is an essential skill for statistical programmers in the pharma field. Of course sas is a programming language which can be derived to different using requirements in different fields. So I think we should follow the actual requirements in the pharmaceutical industry to learn SAS if you want to be a qualified statistical programmer. Therefore the purpose of this post is to record some actual applications by sas so that I can understand and remember sas syntax clearly.
Embed R images into RTF in SAS
We all know that IML/SAS make us use R code in SAS by
submit /R statement. A few months ago, I consulted with SAS support for how to import plots by R in IML into RTF templates directly as I could not find any useful information in google. Unfortunately SAS support told me if the plot was created in R, it would need to be saved within the submit block as well using R code. It means if you want to directly import R graphics to RTF, maybe you should use some R function to achieve it.
Logistic Regression in SAS
I have kept a note about logistic regression for biomarkers using R, and mentioned that I’d like to compare the code of R and SAS. Therefore how to use SAS to estimate a logistic regression model?