2
votes
2answers
26 views
How to change the YEAR value of a numeric date variable?
data olddate;
format date ddmmyy10.;
input date ddmmyy10.;
cards;
12/06/1995
;
run;
I want to change the year value (which is 1995) to 1996 without converting the variable to char …
3
votes
4answers
71 views
How to find the End of Week Date for a given date…?
Hi All,
I want to find what the end of the week date is for each date in order to collapse dates to the week level...
for example: date: 7/27/2010 end_of_week_date: 7/31/2010
t …
2
votes
4answers
254 views
Finding the # of days between two dates?
I have data like:
patid startdate endday
01S1003 9/30/2008 3/16/2009
How do I find the number of days bewteen startd …
2
votes
3answers
157 views
How to change char Date values into DATE9. format?
I have data as shown below: Both variables are $10 fromat
DOB MDATE
11/19/1999 4/17/2006
10/19/1999 4/17/2006
6/28/2000 4/17/2006
9/27/2 …
3
votes
3answers
115 views
Help using date format MMYYS.
I need to convert a character string (MM/YYYY) into a date (MM/YYYY). I was trying to use the format mmyyss. or mmyyss7. and received the following error log (same error if I use …
1
vote
2answers
44 views
How to create a listing of all intervening dates between a start and end date?
I have the following code where I have a tradid with the first date
when the trade was opened and the second date when it was closed (as
shown in the code below).
Data new;
…
