Blogs

Blogs

Learn SAS

Learn about the latest tips, tutorials, upcoming events and certifications

Learn SAS
Jim Simon 0
Reading Hierarchical Data - Part 3

This post is the third and final in a series that illustrates three different solutions to "flattening" hierarchical data.  Don't forget to catch up with Part 1 and Part 2. Solution 2, from my previous post, created one observation per header record, with detail data in a wide format, like

Read More
English
Learn SAS
Jim Simon 0
Reading hierarchical data - Part 2

This post is the second in a series that illustrates three different solutions to "flattening" hierarchical data. Solution 1, from my previous post, created one observation per header record, summarizing the detail data with a COUNT variable, like this: Summary Approach: One observation per header record   Obs Family Count

Read More
English
Learn SAS
Jim Simon 0
Reading hierarchical data - Part 1

A family and its members represent a simple hierarchy.  For example, the Jones family has four members: A text file might represent this hierarchy with family records followed by family members' records, like this:   The PROC FORMAT step below defines the codes in Column 1: proc format; value $type

Read More
English
Learn SAS
Anuja Nagpal 0
Flexibility of SAS Enterprise Miner

Do you use an array of tools to perform predictive analytics on your data? Is your current tool not flexible enough to accommodate some of your requirements? SAS Enterprise Miner may be your solution. With growing number of data mining applications, having a tool which can do variety of analysis

Read More
English
Learn SAS
Rick Wicklin 0
Those tricky PERCENT formats

When using SAS to format a number as a percentage, there is a little trick that you need to remember: the width of the formatted value must include room for the decimal point, the percent sign, and the possibility of two parentheses that indicate negative values. The field width must

Read More
English
Learn SAS
Rick Wicklin 0
Convert a vector to a string

Base SAS contains many functions for processing strings, and you can call these functions from within a SAS/IML program. However, sometimes a SAS/IML programmer needs to process a vector of strings. No problem! You can call most Base SAS functions with a vector of parameters. I have previously written about

Read More
English
Learn SAS
Beverly Brown 0
Saint Peter’s University introduces Master’s degree in data science and business analytics

In December, Saint Peter’s University grants Master’s degrees to its inaugural class of data scientists.  36 students are enrolled in this program, and eight are set to graduate.   As reported this year by Bloomberg, career opportunities for analytics talent are excellent. Saint Peter’s is the latest to collaborate with SAS to offer such a program.

Read More
English
Learn SAS
Jim Simon 0
DATA STEP text file tricks

When reading a text file (common extensions: TXT, DAT; or, for the adventurous: HTML) with the DATA STEP, you should always view several lines from the text file, and compare to the record layout, before completing the INPUT statement.  There are many ways to view a text file.  I use

Read More
English
Learn SAS
Jim Simon 0
Weird PROC FREQ trick

Default PROC FREQ output looks like this: Suppose you don't want the two cumulative statistic columns above.  No problem.  Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run;

Read More
English
1 … 30 31 32 33 34 … 47

Back to Top