Lounge - convert YYMM to number of months
Asked By terri destefano
18-Aug-11 11:35 AM
I need to calculate the loan amortization in months. The format of the date is YYMM right now, ie 1709 (17 years 8 months) but I need to create code in SAS to reformat this into number of months. How would I write this in SAS?
Riley K replied to terri destefano
The following code calculates age in completed years from the variables birth andsomedate.
age = floor((intck('month',birth,somedate)
- (day(somedate) < day(birth))) / 12);
Here are few tutorials on SAS date formats,
am trying to sumif different days of the week. Table is setup as below: A. Date Date Date Date Date . . . . . . B. Data Data Data Data Data . . . . . . I know that = weekday(Date, 1) will give me a 1 through 7 of the date Sunday through Saturday. Somehow, I feel like = sumif(A:A, weekday(A:A) = 1, sum can not use whole column pior to XL-2007 If you are using the 1900 date system, and DOW = 7, you will also add any values in B2:B40 where A2
I need help please. I am creating a staff scheduling. the format is like this date date date date date date name client A client A client C client C client D client D name client create a summary per client which showing the staff participated in each client and the date we perform work on the client. I am thinking to use Vlookup function. To do table which copy the name column between each column which make the table like this date name date name date name client A name client A name client C name client
independent data Excel Hello, I have a spread sheet with several columns ( about 300) of date and the needs to be sorted example: A B C D E F 1 Date Date Date Date Date Date 2 310 710 230 1468 2001 672 3 222 111 2133 28 1453 772 4 independent, data description: Hello, I have a spread sheet with several columns ( about 300) of date and the needs to be sorted example: A B C D E F 1 Date
Help DataBase Could someone assist with the following? I am getting errors! Sum(IIf([Award Date]) > = ([Date Rcvd]), ([Award Date])-([Date Rcvd])) AS [# Days to Award] Thanks, Access Queries Discussions VBA (1) CARFinal (1) AwardDays (1 AwardDate (1) DateDiff (1) DateRcvd (1) TedMi (1) Althouhg (1) Sum(IIf([Award Date] > = [Date Rcvd], DateDiff("d", [Date Rcvd], [Award Date]) AS [# Days to Award], 0)) There were some syntax problems and some best practice issues