I have:     %let ac_grp = "N02299 N99761 N79986 N99121 N01899 N09955";   PROC SQL;      CREATE TABLE EGTASK.TESTER AS      SELECT *      FROM EGTASK.ENR_CURR_V4 (where= (client_id = (&ac_grp))); QUIT;     This ends up not picking anything up from the original table. The client_ids are in the ac_grp macro variable.  Probably something easy that I'm missing.  Thanks ... View more

This is probably simple, but here goes.  Data is structured as monthly files...so each file has records from the days of a month.  It looks like:   Date      Market   Revenue July 1    1        5 July 1    1        6 July 2    2        4 July 3    3        6     There can be many transactions per day over the month.  I'd like to make:   Date and Market Revenue for each market in the horizontal, for each market.  Example   Date     1      2      3 July 1   11     0      0 July 2   0      4      0 July 3   0      0      6   As you can see, there is one date for a day, then the horizontal is the sum of each market's revenue (markets are 1,2,3, etc) for that day.   thx ... View more

I have data like:   Day    Current    Previous    Growth 1      10          5          1.0 2      20         10          1.0 3      30                    15          1.0 etc.   I would like to add another variable that creates a running total (RT) and running growth rate:   Day    Current    Previous    Growth    RT_Curr  RT_Prev   RT_Growth  1      10          5          1.0       10        5        1.0 2      20         10          1.0       30       15        1.0 3      30                    15          1.0       60       30        1.0 etc.   Is there an easy way to do this in SAS?  Datastep?   Thanks! ... View more

I have airline origin and destination data that looks like:   Departure   Destination    Current Count    Previous Count CYEG        CYYZ           51               22 CYYZ        CYEG           53               67 RPLL        CYYZ           21                6 CYVR        CYYC           11                9 CYYC        CYVR           15                1     What really matters is the total traffic between COMMON city pairs. What would be good would be to get output as:   Common City Pair   Current Count   Previous Count CYEG <--> CYYZ     104             89 RPLL <--> CYYZ      21              6 CYVR <--> CYYC      26             10     The values in the Current Count and Previous count are now the sums of the COMMON city pairs in the original data. Common city pairs can be anywhere in the dataset and not necessarily right after one another.   Thanks!     ... View more