The project that I’m currently working on requires several input data tables, and those tables must have a specific schema. That is, each input table must contain columns of a specific name, type, and length in order for the rest of the system to function correctly. The schema requirements aren’t […]
Tag: sql
Improving on a SAS programming pattern
Earlier this week I described a common programming pattern in the SAS macro language. The pattern sets up a loop for processing each distinct value of a classification variable. The program uses the PROC SQL SELECT INTO feature to populate SAS macro variables. The effect: you can roll your own […]
SAS OLAP Cubes: Using PROC SQL and MDX to Query OLAP Cubes
SAS PROC SQL has a lot of neat ways you can extract and manipulate data. In my experience, SAS users typically write PROC SQL to query SAS datasets or relational tables in databases. You can also…
[[ This is a content summary only. Visit my webs…
An Analytical Valley: Big Data and Data Scientists (and SAS Programmers)
Tom Davenport reported an observation that Silicon Valley is becoming more analytical since companies in the Valley such as Google, Facebook, eBay, LinkedLn all have strong presences in analytics. Besides such predominant companies, I’d also like to add Yahoo to the list although Yahoo is no longer in its peak. Yahoo is the largest sponsor […]
NOTE: CALCULATED in SQL
If you use SQL, either hand-cranked from the Editor, or generated via Enterprise Guide or DI Studio, you’re probably familiar with creating new columns (“computed columns”). However, have you ever struggled to create a computed column from a computed c…
NOTE: CALCULATED in SQL
If you use SQL, either hand-cranked from the Editor, or generated via Enterprise Guide or DI Studio, you’re probably familiar with creating new columns (“computed columns”). However, have you ever struggled to create a computed column from a computed c…
First One In Gets the Win
Yikes, it’s been a while since the last update! So I will try to keep this one short and useful. Most everybody knows there are essentially two ways for tables to be merged in SAS: using the merge statement in the data step and using a join in SQL. …
First One In Gets the Win
Yikes, it’s been a while since the last update! So I will try to keep this one short and useful. Most everybody knows there are essentially two ways for tables to be merged in SAS: using the merge statement in the data step and using a join in SQL. …