Tag Archives: SAS data management

Connecting SAS to Other Applications: Different Strategies

Did you know it is possible to integrate SAS with other data environments, like Microsoft SQL or Excel?

Connecting SAS to other applications is often necessary, and there are many ways to do it. Read this blog post for a couple of use-cases of SAS data integration using various SAS components.

Project Management Terminology for Public Health Data Scientists

If you are a health data analyst or a biostatistician, we might find computer programmers and application developers use different terminology for the same ideas and concepts.

Project management terminology is often used around epidemiologists, biostatisticians, and health data scientists, and it’s often hard for us to admit we aren’t familiar with some of the terms. Watch my videos and take my Applications Basics course to get up to speed with vocabulary from the health application development domain.

Reducing Query Cost (and Making Better Use of Your Time)

Slow queries can happen in SAS, R, Python, SQL or any database language. These slow queries have a cost.

Reducing query cost is especially important in SAS – but do you know how to do it, or what it even means? Read my blog post to learn why this is important in health data analytics.

Variable Names in SAS and R Have Different Restrictions and Rules

You need to come up with names of variables in SAS and in R, but they need to be compatible with both languages if you are running a data warehouse.

Variable names in SAS and R are subject to different “rules and regulations”, and these can be leveraged to your advantage, as I describe in this blog post.

Referring to Variables in Processing Data is Different in SAS Compared to R

When doing data processing, especially extract-transform-load (ETL) into a data warehouse, you might need to refer to the variables in your code, and it's done differently in SAS vs. R.

Referring to variables in processing is different conceptually when thinking about SAS compared to R. I explain the differences in my blog post.

Verified by MonsterInsights