Can we derive a date variable in information map studio?
Here is the problem description below,
I would like to derive a date variable from already existing 2 variables i.e i have a registered dataset in Information Map studio and i have corresponding map also.
I have 2 date variables like start date and drop date.........so here i would like to create a new variable which is going to have both start and drop dates together as data values.
So could you please help me how to derive teh new variable in information map studio in order to achieve this?
I don't understand what you mean when you say " i would like to create a new variable which is going to have both start and drop dates together as data values."
Usually date variables are numeric variables that hold 1 value -- the number of days since Jan 1, 1960 (the SAS "internal" value of 0). So if you have this data:
-3334 0 (Internally Stored Values)
The start date would represent Nov 15, 1950 and the drop date would represent Jan 1, 1960 for those two separate internally stored date variables.
How would you envision creating 1 new variable from 2 variables??? What would the new variable look like? Would it represent the number of days between the start date and the drop date? Would it be a numeric variable or a character variable??? Can you use the two dates above and show what your new variable would look like?? Can you explain how you would use this new variable that somehow "had both dates together as data values"??