Sas dates

[chimukah]

Hi all,

I have a question on SAS dates. I have a variable MHSTDTC which has dates like 2020-05 and also 2020-05-17. when i applied index function using PROC SQL like this

PROC SQL;

CREATE TABLE MEDICAL AS

SELECT *,

CASE WHEN INDEX (MHLNKID, 'D') THEN INPUT(MHSTDTC, YYMMDD10.) END AS C FORMAT=YYMMDD10.

FROM M

ORDER BY SUBJID;

QUIT;

The output will display only dates like '2020-05-17' while the ones like '2020-05' will not display. 

How will i display both dates in my output.

Thanks

[Kurt_Bremser]

Partial date strings need special treatment (special informat, or append a day before converting).

You also need to decide which day in the month is best for later analysis.

[chimukah]

Thank you KurtBremen for your suggestion. However the day is missing as can be seen from the partial date '2020-05'. I feel there's a way to get around it and display both even if its partial.

Regards

[Tom]

Since dates are stored as the number of days since 1960 you cannot make a date value without specifying the full date, including what day of the month.

If you want to display a "date" that does not have a day of the month then just leave it as a string.

If did pick a day of the month to use so that you can generate a date value you could have it display just the year and month by using a format that only shows that level of detail.  This is similar to how you can use a format to limit the number of decimal places displayed for a number.  So formats like YYMMN7. or MONYY7.

[Kurt_Bremser]

A date is a date is a date is a date. A date specifies a specific day within a specific month within a specific year.

To have usable date values in SAS, you need to have that specific day, so there is no way around that.

To help later users, you can keep separate year/month/day values, and let the users decide how to handle the missing values.

[chimukah]

What's the danger of using anydtdte10. in place of yymmdd10.

I tried it and it gave first day of the month.

[Kurt_Bremser]

There's no danger. Until somebody finds out that most cars are stolen on the first days of months.

[Tom]

---

@chimukah wrote:

What's the danger of using anydtdte10. in place of yymmdd10.

I tried it and it gave first day of the month.

---

The danger is what it does with ambiguous strings like:

01-02-03

If you read that with the YYMMDD informat or the B8601DA informat then it will always interpret the first value as the year, the second as the month and the third as the day (03FEB2001).  But ANYDTDTE will not.  Instead if will either treat it as DMY (01FEB2003) or MDY(02JAN2003) depending on the setting of you language/region options.

[PeterClemmensen]

Use the B8601DA informat as suggested by @data_null__ in the thread here.