Blogs

Blogs

Programming Tips

Strengthen your programming skills with tips and techniques from the experts

Data Visualization | Programming Tips

Dan HeathSeptember 10, 2022 0

Complex Layouts using the SG Procedures

The Graph Template Language (GTL) is a powerful tool for creating a wide range of graphic displays. One feature GTL has is the ability to combine independent plots together into one paneled display. The SG procedures have some limited capabilities in this area; but in this post, I am going

Read More

Analytics | Learn SAS | Programming Tips

Rick WicklinSeptember 7, 2022 0

A test for monotonic sequences and functions

Monotonic transformations occur frequently in math and statistics. Analysts use monotonic transformations to transform variable values, with Tukey's ladder of transformations and the Box-Cox transformations being familiar examples. Monotonic distributions figure prominently in probability theory because the cumulative distribution is a monotonic increasing function. For a continuous distribution that is

Read More

Learn SAS | Programming Tips

Rick WicklinAugust 31, 2022 0

Two types of syntax for the SELECT-WHEN statement in SAS

The SELECT-WHEN statement in the SAS DATA step is an alternative to using a long sequence of IF-THEN/ELSE statements. Although logically equivalent to IF-THEN/ELSE statements, the SELECT-WHEN statement can be easier to read. This article discusses the two distinct ways to specify the SELECT-WHEN statement. You can use the first

Read More

Programming Tips

Ursula PoloAugust 29, 2022 0

SAS Viya Workload Orchestrator CLI Plug-in

A key tool for SAS Viya admins and many users is the command line interface (CLI). You can think of it in terms of other CLIs, but with direct access to SAS Viya. The CLI facilitates automation of tasks as well as other administrative functions. You can find information about

Read More

Data Visualization | Programming Tips

Rick WicklinAugust 29, 2022 0

Order the bars in a bar chart with PROC SGPLOT

A SAS programmer was trying to understand how PROC SGPLOT orders categories and segments in a stacked bar chart. As with all problems, it is often useful to start with a simpler version of the problem. After you understand the simpler situation, you can apply that understanding to the more

Read More

Data Visualization | Learn SAS | Programming Tips

Rick WicklinAugust 24, 2022 0

How to stagger labels on an axis in PROC SGPLOT

A SAS programmer asked how to display long labels at irregular locations along the horizontal axis of scatter plot. The labels indicate various phases of a clinical study. This article discusses the problem and shows how to use the FITPOLICY=STAGGER option on the XAXIS or X2AXIS statement to avoid collisions

Read More

Programming Tips

Kevin RussellAugust 17, 2022 0

The ADDROWID data set option maintains the order of your data when executing a DATA step in SAS® Cloud Analytic Services (CAS)

SAS' Kevin Russell compares how you order your data with a BY statement in SAS 9.4 versus in CAS using the ADDROWID data set option in SAS Viya.

Read More

Programming Tips

Teri PatsilarasAugust 10, 2022 0

SAS Visual Analytics: Automatic Actions: a three-part series

If you haven't explored data with Automatic Actions enabled yet, then read on to learn about some fast and easy ways to gain insights using One-way filters, Two-way filters or Linked Selection! Part 1 – Easy exploration for multiple data sources In this post, we focus on One-way filters. Here

Read More

Learn SAS | Programming Tips | Students & Educators

Suzanne MorgenAugust 1, 2022 0

Meet our SAS Press Author of the Month – Ron Cody

Recently, the SAS Press team moved to a new building on the SAS campus. And when the SAS Press team moves, we bring a lot of books with us! Packing and organizing all of our books gave us a chance to appreciate all of our authors’ hard work during the

Read More

Programming Tips

Ursula PoloJuly 27, 2022 0

Manage and Balance Workloads in SAS

SAS Grid Manager for Platform, SAS Grid Manager, and SAS Viya Workload Management all manage and balance job loads, right? So, are there three SAS products providing the same functionality? Let’s explore, as I am curious in your answer after you read this article. Each of the three applications has

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 25, 2022 0

Monte Carlo estimates of area

I've previously shown how to use Monte Carlo simulation to estimate probabilities and areas. I illustrated the Monte Carlo method by estimating π ≈ 3.14159... by generating points uniformly at random in a unit square and computing the proportion of those points that were inside the unit circle. The previous

Read More

Programming Tips

Peter Styliadis

Peter StyliadisJuly 21, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 8 - Creating Calculated Columns

Welcome to the continuation of my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to filter CAS tables. Now it's time to focus on creating calculated columns on a CAS table. Load and explore

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 20, 2022 0

A tip for visualizing the density function of a distribution

It isn't easy to draw the graph of a function when you don't know what the graph looks like. To draw the graph by using a computer, you need to know the domain of the function for the graph: the minimum value (xMin) and the maximum value (xMax) for plotting

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 18, 2022 0

Tips for computing right-tail probabilities and quantiles

A colleague was struggling to compute a right-tail probability for a distribution. Recall that the cumulative distribution function (CDF) is defined as a left-tail probability. For a continuous random variable, X, with density function f, the CDF at the value x is F(x) = Pr(X ≤ x) = ∫

Read More

Programming Tips

Dr. Christian FG Schendera

Dr. Christian FG SchenderaJuly 12, 2022 0

Why learn SQL?

SQL (Structured Query Language) is the most widely used programming language for relational databases worldwide. No other programming language produces more hits for a web search than SQL and interest is growing rapidly. In June 2010, Google showed 135 million hits versus 586 million hits in June 2020. SQL is

Read More

Advanced Analytics | Analytics | Data Visualization | Programming Tips

Yinliang WuJuly 11, 2022 0

A better 3D scatter plot macro

SAS SGPLOT already provides the necessary graphical elements for complex visualization. 3D or high-dimensional data can be easily visualized after being projected appropriately. With SAS' strong support for animation features, SAS users can create complicated 3D or high dimension visualizations quickly.

Read More

Data Management | Learn SAS | Programming Tips

Leonid BatkhanJuly 7, 2022 0

Splitting a data table into multiple sheets of an Excel workbook

Leonid Batkhan shows how to split a data table into multiple Excel spreadsheets in a single workbook.

Read More

Learn SAS | Programming Tips

Rick WicklinJuly 6, 2022 0

Use functions in a WHERE statement to filter observations

Many people know that you can use "WHERE processing" in SAS to filter observations. A typical use is to process only observations that match some criterion. For example, the following WHERE statement processes only observations for male patients who have high blood pressure: WHERE Sex='Male' & Systolic > 140; In

Read More

Programming Tips

Peter Styliadis

Peter StyliadisJune 29, 2022 0

Getting Started with Python Integration to SAS® Viya® - Part 7 - Filtering CAS Tables

Welcome to the seventh installment in my series Getting Started with Python Integration to SAS Viya. In previous posts, I discussed how to connect to the CAS server, how to execute CAS actions, and how to work with the results. Now it's time to learn how to filter CAS tables. Load and explore data

Read More

Analytics | Data Visualization | Programming Tips

Rick WicklinJune 29, 2022 0

Compute the multivariate t density function

A previous article shows how to compute the probability density function (PDF) for the multivariate normal distribution. In a similar way, you can compute the density function for the multivariate t distribution. This article discusses the density function for the multivariate t distribution, shows how to compute it, and visualizes

Read More

Analytics | Programming Tips

Rick WicklinJune 27, 2022 0

The derivative of a quantile function

Recently, I needed to solve an optimization problem in which the objective function included a term that involved the quantile function (inverse CDF) of the t distribution, which is shown to the right for DF=5 degrees of freedom. I casually remarked to my colleague that the optimizer would have to

Read More

Learn SAS | Programming Tips

Leonid BatkhanJune 16, 2022 0

Automating Excel workbooks creation using SAS

Leonid Batkhan shows you how to automate and improve a sometimes onerous hands-on process of creating Excel workbooks.

Read More

Learn SAS | Programming Tips

Rick WicklinJune 13, 2022 0

Detect palindromes and rotational palindromes in SAS

A palindrome is a sequence of letters that is the same when read forward and backward. In brief, if you reverse the sequence of letters, the word is unchanged. For example, 'mom' and 'racecar' are palindromes. You can extend the definition to phrases by removing all spaces and punctuation marks

Read More

Programming Tips

Kathryn McLawhornJune 10, 2022 0

A comparison of the ODS destinations for writing to Microsoft Word

There are several alternatives to writing to a Microsoft Word file when you use the SAS® Output Delivery System (ODS). The RTF, TAGSETS.RTF and TAGSETS.RTF_SAMPLE destinations create an RTF formatted file. The WORD destination, which is still considered preproduction, creates a DOCX formatted file. The destinations provide many of the same functions, although some features are unique to each one. The destination that you choose might vary depending on your desired final output.

Read More

Data Visualization | Learn SAS | Programming Tips

Yinliang WuJune 7, 2022 0

Considerations for generating time-accurate animation with SAS

SAS can generate animations in GIF or SVG format. The SAS system option ANIMDURATION can specify the duration of a frame corresponding to the appropriate FPS.

Read More

Programming Tips

Rick WicklinJune 1, 2022 0

Random assignment of subjects to groups in SAS

A common question on SAS discussion forums is how to randomly assign observations to groups. An application of this problem is assigning patients to cohorts in a clinical trial. For example, you might have 137 patients that you want to randomly assign to three groups: a control group, a group

Read More

Programming Tips

Ron CodyMay 31, 2022 0

Using formatted CLASS variables

If you use formatted variables in a CLASS statement in procedures such as MEANS or UNIVARIATE, SAS will use the formatted values of those variables and not the internal values. For example, consider you have a data set (Health) with variables Subj, Age, Weight, and Height. You want to see

Read More

Analytics | Programming Tips

Rick WicklinMay 25, 2022 0

How much does a bootstrap estimate depend on the random number stream?

Many modern statistical techniques incorporate randomness: simulation, bootstrapping, random forests, and so forth. To use the technique, you need to specify a seed value, which determines pseudorandom numbers that are used in the algorithm. Consequently, the seed value also determines the results of the algorithm. In theory, if you know

Read More

Analytics | Data for Good | Learn SAS | Programming Tips

hyuntaekjooMay 20, 2022 0

CData JDBC Driverを利用したSNS・ファイルストレージサービスとの連携のご紹介

SAS ViyaではCData JDBC Driverを使って下記のソーシャルメディア・ファイルストレージサービスにシームレスにかつ、素早く連結できます。・Facebook ・Google Analytics ・Google Drive ・Microsoft OneDrive ・Odata ・Twitter ・YouTube Analytics 本日はCData JDBCドライバーを使ってTwitterと連携し、「天気」に関するツイートを取得してみたいと思います。順番通り説明しますので、最後までお読みいただき、皆さんも是非ご活用ください。 1. Twitter API利用申請 Twitter Developer PlatformにてTwitter APIの利用申請を行います。申請にあたり、名前と住んでいる地域、利用目的などの情報を提供する必要がありますので、事前に用意しておいてください。また、利用申請の承認はTwitter側で数日かかる場合がありますのでご了承ください。 Twitter APIの利用申請が終わったら、申請完了のメールが届きます。また、申請の検討が終わり、Twitter APIが利用できる状態になりましたら、「Account Application Approved」というメールが届きます。 2. CData Twitter JDBC DriverインストールインストールにはSASの契約とは別途、CData社との契約が必要ですが、30日間トライアルで使うことも可能ですので、ご紹介します。まず、CData Twitter JDBC Driverインストールページにアクセスします。次に、Downloadクリックします。 Download Trialをクリックします。適切なOSを選択してDownloadをクリックします。今回はWindowsを選択しました。ダウンロードされたTwitterJDBCDriver.exeファイルを開き、画面に表示されるステップに従ってインストールを完了します。 3. Connection String生成

Read More

Learn SAS | Programming Tips

Rick WicklinMay 16, 2022 0

How to unroll frequency data

In categorical data analysis, it is common to analyze tables of counts. For example, a researcher might gather data for 18 boys and 12 girls who apply for a summer enrichment program. The researcher might be interested in whether the proportion of boys that are admitted is different from the

Read More

Previous 1 2 3 4 … 60 Next