SAS Fundamentals
4 Functions for fuzzy matching in SAS
Fuzzy matching in SAS is deciding programmatically if one word is identical to the other. For example, deciding if ‘John Doe’ is identical to ‘Johnny Doe’. In SAS, there are […]
Read More
SAS Fundamentals
Using the Compare function in SAS for comparing strings
The COMPARE function in SAS lets you compare two character values and with optionally available modifiers, you’ll be able to ignore case and truncate a longer value to the length of a shorter value before making the comparison.
SAS Fundamentals
Comparison operator in SAS – The =: Operator
Most people who find themselves acquainted with programming SAS are aware of the colon operator ( =: ). There are a couple of different colon operators in SAS, however, on […]
SAS Fundamentals
3 Little Tricks To Achieve The Best Results In PROC PRINT SAS.
PROC PRINT is a type of procedures that are used by every SAS programmer frequently. Most of you must be using it to just to display your data but you […]
SAS Fundamentals
Automatic variables in sas
What are automatic variables in SAS? Within a data step, SAS automatically create a couple of reserved variables. Automatic variables in SAS are created automatically by the DATA step or […]
Proc SQL
Everything You Need To Know About SQL SET Operators
SQL Set operators are conceptually derived from the mathematical set principle. The three fundamental set operators are UNION, INTERSECT, and EXCEPT. All three, with variations (in particular, OUTER UNION) and […]
Base Sas
SAS Loops Explained
Loops allow you to execute SAS statements repeatedly thereby reducing the number of code lines.
The flow in loops can be classified as entry controlled or exit controlled. If the programming compiler checks for all conditions associated with the beginning of the loops executions are validated and true, then it is called as Entry controlled loops.
Statistics
How to choose a statistical test?
If you are from a non-statistical background it is essentially the most complicated aspect of statistics, are always the basic statistical tests, and how to choose statistical test? In this […]
Advanced SAS
Using PROC RANK for ranking variables
Ranking of variables is often necessary to analyze the performance or gain an insight on which are the values are on top or at the bottom and by using PROC RANK procedure, there is no need to write complex code using PROC SORT, MACRO calls and DATA STEPS to rank or decile these scores or values.