Thanks for the responses. However, the result that I want is to use every first date as the start date and the the next date minus a month as end date so that the next date will be the next start date. For example date 03/09/2006 11/02/2008 11/04/2008 12/31/2010 09/13/2012 02/24/2014 the first start date is 03/09/2006 and end date is 10/31/2008 the second start date is 11/02/2008 and end date is 11/03/2008 the third start date is 11/02/2008 and end date is 11/30/2010 and so on. thanks
... View more
Hi all, I need to create start date and end date from a single date column: the date coulumn is as follow; date 03/09/2006 11/02/2008 11/04/2008 12/31/2010 09/13/2012 02/24/2014 From this date, I need to create two columns; start date and end date, no ID variable in this data. Thank you.
... View more
This actually produced a valid statement but did not give me what I intended to bring out of the output. Therefore, I need more solutions. Thanks very much.
... View more
I am trying to run a regeression program on sashelp.car using KEEP statement and here is the code that I used; data auto; set sashelp.cars; keep make model MSRP; run; proc reg data=auto; model MSRP=make model; run; and the log is; 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 proc reg data=auto; 74 model MSRP=make model; ERROR: Variable Make in list does not match type prescribed for this list. ERROR: Variable Model in list does not match type prescribed for this list. NOTE: The previous statement has been deleted. 75 run; WARNING: No variables specified for an SSCP matrix. Execution terminating. NOTE: PROCEDURE REG used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 76 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 91 while the error message is ' ERROR: Variable Make in list does not match type prescribed for this list. ERROR: Variable Model in list does not match type prescribed for this list.'
... View more