Tag Archives: sas

SAS Macro to Read through a Variable List

Posted on April 6, 2016 by huiyuqian

It is quite often to list different types of variables as strings/variable lists for modeling. For example, you fit your model and get: y_hat = intercept + parest1*var1 + parest2*var2 + … + parestk*vark where k could be as large … Continue reading →

Posted in SAS, Statistics | Tagged auto scan, independent variable list, macro, prediction, regression, sas | Leave a comment

Importing .CSV file to SAS

Posted on March 1, 2015 by huiyuqian

When your data is relatively big, you may save it as .CSV file instead of .XLS or .XLSX. The way to import a .CSV file to SAS is simple too. You may either use PROC IMPORT or a DATA step. … Continue reading →

Posted in SAS | Tagged data step, excel, field length, format variables, import, read in excel, sas | Leave a comment

Create Heatmap by State using SAS

Posted on February 25, 2015 by huiyuqian

Visualization is very powerful. One good way to visualize geographical summary is to show heatmap on the map. This article gives an example of creating a simple heatmap by USA state using SAS. 1. Data Sets maps.us: (sample records) maps.uscenter: … Continue reading →

Posted in SAS | Tagged example, heatmap, map by state, sample, sas, sas code | Leave a comment

A Simple SAS Macro to Create Deciles

Posted on February 18, 2015 by huiyuqian

We use deciles very often in marketing segmentation. When the data has no or a very small number of ties in ranking with the variable of interest, it is okay to use PROC RANK for grouping. However if there are … Continue reading →

Posted in SAS | Tagged code, data step, decile, macro, proc rank, program, rank, sample, sas, segmentation, simple | Leave a comment

INDEX in SAS

Posted on February 13, 2015 by huiyuqian

Using index to append additional columns (fields, variables) on a driver file could be a very good choice when dealing with frequently used large data set. Below are several tips I summarized based on my SAS coding experience so far: … Continue reading →

Posted in SAS | Tagged append, index, large data sets, merge without sorting, sas | Leave a comment

Import EXCEL .xlsx/.xls/.xlsm files to SAS through ODBC

Posted on October 23, 2014 by huiyuqian

Without access to SAS/ACCESS to PC Files, it is okay to import .CSV files to SAS using PROC IMPORT but not for .xlsx/.xls/.xlsm. One alternative way is to use LIBNAME statement through ODBC: http://support.sas.com/kb/32/455.html Example: Suppose we have an EXCEL .xlsx … Continue reading →

Posted in SAS | Tagged excel, import, import excel through odbc, import xls or xlsx without pc access, odbc, sas, xls, xlsx | Leave a comment

Automate Your SAS Code Execution

Posted on September 26, 2014 by huiyuqian

For routine SAS data ETL (Extract, Transform and Load) tasks or those need to be done while we are away from our desks (during late night or very early in the morning), it will save you a significant amount of … Continue reading →

Posted in SAS | Tagged automate, code, Execution, sas, Schedule, Task | Leave a comment

Retrieve Your Unsaved SAS Code

Posted on September 18, 2014 by huiyuqian

SAS automatically saves code every 10 minutes. If it happens that the window was abnormally closed and a significant portion of code was not saved, you may check the autosaved sas file by searching under C drive for “yoursasfilename.$AS” files, … Continue reading →

Posted in SAS | Tagged code, recover, sas, unsaved | Leave a comment

How to extract a sequence of numbers from a string in SAS

Posted on September 18, 2014 by huiyuqian

Sometime the raw data is messy and we have to extract the information we need. This post will talk about how to take out the numbers we need from a string: If use SAS, the following code may help to … Continue reading →

Posted in SAS | Tagged all numbers from a string, character, extract, numbers, sas, string, substr | Leave a comment