Hello, I am using Proc SQL to extract data from the DB. However, rather that a range of data (i.e between X and Y), i would like to extract it from multiple dates. I would like to use %LET DATES = ('21-JUN-2016'd',22-jul-2016'd,'21-NOV-2016'd,'21-dec-2016'd); Instead of this: %LET BEGDT = '01-jul-2016'd; %LET ENDDT = '31-dec-2016'd;
... View more
Hi, I am trying to identify the dates interest rates increased/decreased for a customer in a period of time. INPUT Date CustomerAccount InterestRate 1/1/2016 1 2 2/1/2016 1 2 3/1/2016 1 3 4/1/2016 1 3 1/1/2016 2 8 2/1/2016 2 8 3/1/2016 2 9 4/1/2016 2 9 OUTPUT Date CustomerAccount PreviousRate New Rate 3/1/2016 1 2 3 3/1/2016 2 8 9 I appreciate your help.
... View more
Thank you for your response If i had 2 fields, how would i change the data step? INPUT: ID State Date 123 MD 1-1-2016 123 MD 1-3-2016 123 TX 2-4-2016 123 TX 2-7-2016 Need Output ID State Days 123 MD 0 123 MD 2 123 TX 0 123 TX 3
... View more
Please see additional details and clarification below: I would like to run the report that yields the following record (1 row per day) for the past 6 months. Currently, i manually change the date on top of the report to run a report for a particular date in the past. %LET REPDT = '01-Jan-2017'd; Proc SQL (to extract data) Data Step (to calculate variables) Result: Date Transactions Exceptions 1/1/17 700 60 However, i would like to run it for the past 6 months and yield results below: Result: Date Transactions Exceptions 1/1/17 700 60 1/2/17 10 0 1/3/17 2 1 Thanks again for taking the time.
... View more
I have a daily report and below is the report Date #oftransactions ExceptionsA ExceptionsB 01/01 50000 100 2 I would like to run it for everyday of the month and at the end of the month create the report below. This report uses both procSQL and Data steps. Also, daily data file is pulled from a database. Date #oftransactions ExceptionsA ExceptionsB 01/01 50000 100 2 01/02 20000 20 1 01/03 10000 40 1 01/04 1000 5 0 01/05 6000 7 0 Thank you for taking the time to help.
... View more
I would like to calculate difference between the dates in the following data set: Patient # visit date 123 12-02-16 123 12-05-16 123 12-10-16 456 01-02-16 456 01-07-16 456 01-14-16 To create result: Patient # # of days 123 0 123 3 123 5 456 0 456 5 456 7
... View more