dates

Hello all, I am trying to extract the years from a datetime variable and do not seem to find a way. I am attaching images of what I see on STATA. Can someone explain to me in a simple way what I should do? Thank you in advance!

I have a range of dates from ~1950 to the present that are in the 5 digit Excel/Microsoft date code. I'd like to create date ranges. I'm looking for something like recode date into year (42005 thru 42369) = 2015 (the above syntax might be off by a bit, but you get the picture!)...

Hello, I have a table with dates (every day, ascending order), where each row is the flowing day, and a column with number of expressions. Something like this: Day 1 | 20 expressions Day 2 | 23 expressions … I need to see if there is significance between two periods: up to day...

Hi, I need to create variables that splits out a length of stay across years and enters the number of days in each of those years into separate year variables. For example, I have a length of stay for a case of 8.02 years. CaseID StartDate EndDate 222 12/23/1988 01/01/1997...

Hello, I have a large data set, and, in the data set, there are a number of dates entered as string variables (e.g., 05SEP2012). I need to determine the length of time in years between some of these variables (e.g., from 20MAR1969 to 05SEP2012), but can't seem to figure it out. I have...

Hi All, Nice to meet you, my first post. In SPSS, I would like to recode a date (variable StartDate) dd.mm.yyyy to its relevant finanical year (variable FinancialYear - a categorical variable). I can't figure out how to write the code to specify the date ranges, without spending 2 days on...

Dear All, I need your help regarding one of my projects of Stata software. You must be familiar with dates formatting, system variables and lagging and merging and transposing of data. I understand you would be busy in your job and studies, and that is why I am happy to pay you reasonable...

Hello, Does anyone have syntax that can calculate Date Differences but exclude the weekends? I have used the syntax below, but it would add 1 day values if it did not go over 1 week. So if the difference was 2 days the compute function would equal 3. However, it is accurate if it spans over a...