Tag: Tech

Creating a Microsoft Excel report using SAS, Python and SQL!

The addition of the PYTHON procedure and Python editor in SAS Viya enables users to execute Python code in SAS Studio. This new capability in SAS Viya adds another tool to SAS’s existing collection. With this addition I thought, how can I utilize this new found power? In this example, […]

Creating a Microsoft Excel report using SAS, Python and SQL! was published on SAS Users.

ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya

Change is hard and can be a bit scary. We tend to resist change as we get comfortable with our routines and how things work. However, many times we fail to see the benefits of that something new. Imagine if we didn’t move from MS DOS to Windows? If we’d […]

ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya was published on SAS Users.

CAS-Action! Advanced Frequency Tables – Part 4

Welcome back to my SAS Users blog series CAS Action! – a series on fundamentals. The previous posts show how to use the simple.freq CAS action to generate, save and group simple frequency tables. In this post I will show you how to use the freqTab.freqTab CAS action to generate more advanced […]

CAS-Action! Advanced Frequency Tables – Part 4 was published on SAS Users.

CAS-Action! Grouping Frequency Tables – Part 3

Welcome back to my SAS Users blog series CAS Action! – a series on fundamentals. In my previous part 1 and part 2 posts I reviewed how to use the simple.freq CAS action to generate frequency distributions for one or more columns and how to save the results. In this post I […]

CAS-Action! Grouping Frequency Tables – Part 3 was published on SAS Users.

Using SAS to score a test

If you have ever needed to score a multiple-choice test, this blog is for you. Even if you are not planning to score a test, the techniques used in this example are useful for many other programming tasks. The example I am going to present assumes the answer key and […]

Using SAS to score a test was published on SAS Users.

CAS-Action! Saving Frequency Tables – Part 2

Welcome back to my SAS Users blog series CAS Action! – a series on fundamentals. In my previous post CAS-Action! Simple Frequency Tables – Part 1, I reviewed how to use the simple.freq CAS action to generate frequency distributions for one or more columns using the distributed CAS server. In this post […]

CAS-Action! Saving Frequency Tables – Part 2 was published on SAS Users.