05-17-2018 08:27 AM - edited 05-17-2018 08:29 AM
05-17-2018 08:32 AM
See my footnotes for how to post data. Excel files are mostly useless for this (unless your problem lies in importing them).
05-17-2018 08:38 AM
A date variable always has the three components = day, month, year. If you do not have one then you need to default one in. You can use ISO dates, which are character:
For a numeric, you can have a default, then format it to display differently:
want=mdy(monthvar,1,yearvar); format want monyy7.;