Skip to content Skip to sidebar Skip to footer
Showing posts with the label Sas
Writing Efficient Queries In Sas Using Proc Sql With Teradata

Writing Efficient Queries In Sas Using Proc Sql With Teradata

Post a Comment
EDIT: Here is a more complete set of code that shows exactly what's going on per the answer be… Read more Writing Efficient Queries In Sas Using Proc Sql With Teradata
Transpose Dataset In Hive

Transpose Dataset In Hive

Post a Comment
I'm trying to transpose a variable in Hive such as: Id1 Id2 Event 1 1 7 2 2 3 2 … Read more Transpose Dataset In Hive
Sas Proc Sql Returning Duplicate Values Of Group By/order By Variables

Sas Proc Sql Returning Duplicate Values Of Group By/order By Variables

Post a Comment
I have some fairly simple SQL that should provide 1 row per quarter per asset1. Instead, I get mul… Read more Sas Proc Sql Returning Duplicate Values Of Group By/order By Variables
Create Variable That Counts Progressively How Many Times An Id Is Repeated In A Day

Create Variable That Counts Progressively How Many Times An Id Is Repeated In A Day

Post a Comment
So I have a table that has different days and didfferent hours in each day, and the client ID can a… Read more Create Variable That Counts Progressively How Many Times An Id Is Repeated In A Day
Sas Proc Sql Innerjoin Returning No Columns

Sas Proc Sql Innerjoin Returning No Columns

Post a Comment
question was resolved Proc SQL not returning any columns. Innerjoin thanks to TOM. I appreciated th… Read more Sas Proc Sql Innerjoin Returning No Columns
Sas Do Loop + Lag Function?

Sas Do Loop + Lag Function?

Post a Comment
This is my first post, so please let me know if I'm not clear enough. Here's what I'm t… Read more Sas Do Loop + Lag Function?