topic Re: DATE9. Formatting Not Working With Manually Created Dataset in SAS Procedures

DATE9. Formatting Not Working With Manually Created Dataset

random1 — Thu, 13 Oct 2016 06:16:52 GMT

I am making a mock data set. It doesn't like read in the dates.

Here is the first few lines with the first row:

data mockdata;

input LINK_I CARDNMBR DATE $ Date9. ACTIVE DELQs;

datalines;

1 1 30JUN2014 1 1

;

run;

In the output, it cuts off the last digit and gives 30JUN201 and it considers it a charater, not a date 😞

Re: DATE9. Formatting Not Working With Manually Created Dataset

Reeza — Thu, 13 Oct 2016 06:26:39 GMT

What does the $ imply in the input statement?

Remove it for starters.

Re: DATE9. Formatting Not Working With Manually Created Dataset

random1 — Thu, 13 Oct 2016 06:32:24 GMT

I thought you had to put that after a variable name to say its a character.

If I remove $ i.e. have:

data mockdata;

input LINK_I CARDNMBR DATE Date9. ACTIVE DELQs;

datalines;

1 1 30JUN2014 1 1

then the date value for first row is 19904. I don't want it to show as a number of days since 1960. I just want it to show as 30JUN2014.

If I remove "Date9." i.e. :

data mockdata;

input LINK_I CARDNMBR DATE ACTIVE DELQs;

datalines;

then the whole date column shows as missings (has ".")

Re: DATE9. Formatting Not Working With Manually Created Dataset

Kurt_Bremser — Thu, 13 Oct 2016 06:44:02 GMT

Using a date informat does not automatically assign a display format to a variable; so you need a separate

format date date9.;

statement.

Re: DATE9. Formatting Not Working With Manually Created Dataset

Ksharp — Thu, 13 Oct 2016 08:28:55 GMT

data mockdata;

input LINK_I CARDNMBR DATE : Date9. ACTIVE DELQs;

format date date9.;

datalines;

1 1 30JUN2014 1 1

Re: DATE9. Formatting Not Working With Manually Created Dataset

random1 — Thu, 13 Oct 2016 22:21:53 GMT

Thanks. This works.