You don't have to do 600 cases by hand. If this is a one off, then it
would probably be faster to do by hand than a macro. Here is how:
1. Make sure your dates are stored as Date type not text etc in Excel.
(highlight the column and check format cells).
2. Find out the birthdays (i.e. the year is now irrelevant) for all
cases. You can do this in many ways. For example, by creating an
adjacent column with the formula "=DATE(2400,MONTH(A1),DAY(A1))"
assuming that you stored your date of births in column A1. It is fine to
store this column as either general, number or date.
Note: I choose year 2400 above as it is a leap year allowing for 29th
February. And why 2400 and not 2000 or any other leap year? Just as a
precaution in case someone accidentally uses this as the date of births.
3. Sort the entire sheet using the birthdays column.
4. Cross reference these dates with your astrological star dates and
fill in the star sign. For example, all birthdays that fall between
September 24th and October 23rd is a Libra.
BTW, I am assuming the zodiac dates do not change from year to year.
Hope this helps.
Regards, Adai
Szydlo, Richard M wrote:
>
> I know this is far fetched, but I would like to see if a patient's
> astrological star sign is in anyway associated with survival......
>
> Does anyone have a macro for SPSS / Excel / SAS / Anything else - that
> will convert a date of birth to the appropriate astrological star
> sign.... I could of course do it by hand, but 600 date of births will
> take me a long time!
>
> Thanks,
>
> Richard Szydlo
> Imperial College School of Medicine
> London, UK
>
>
>
|