Skip to content Skip to sidebar Skip to footer
Showing posts with the label Proc Sql

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

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

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

Proc Sql Vs Data Step For Looking Up Values Form A Reference Table That Includes Exceptions

I am trying to find out tax values for a particular good in a particular city in a particular state… Read more Proc Sql Vs Data Step For Looking Up Values Form A Reference Table That Includes Exceptions