Dummies on dates MATLAB

4 views (last 30 days)
Ali Akbar
Ali Akbar on 10 Apr 2015
Commented: Ali Akbar on 11 Apr 2015
I have a calendar with specific dates that I want to create dummy variables for.
The calendar is from 1991 to 2014 and there are announcements on different days of the month throughout the time period. This is how it looks:
First column years, second months and third days.
I have the announcement dates that I want to fit to this calendar with dummy variables. These dates look like this:
How do I create an array with the length of my first calendar with 1 for the days of announcement (second calendar) and 0 otherwise. I need to somehow distinguish the different months from each other while assigning 1 to the dates.

Accepted Answer

Brendan Hamm
Brendan Hamm on 10 Apr 2015
We can do this with the ismember(A,B) function, which returns a logical vector the length of A indicating whether the corresponding element in A appears in B. We can pass in an optional input argument to make this act on the rows of A and B, which we will need to do here on the first 3 columns of each of your variables..
calIdx = ismember(calendar(:,1:3),CPI_cal(:,1:3),'rows');

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!