topic Dates from excel in SAS Procedures

Dates from excel

dereck255 — Wed, 28 Jan 2015 02:21:28 GMT

Please see below:

data XYZ;

infile file1 dlm='09'x notab dsd missover;

informat Date1 DATE.;

input Name $ Num1 Name2 $ Num2 Date1 Var1 Var2 Var3;

Date1=IDate;

format Date1 IDate date10.;

keep Name Num1 Name2 Num2 Date1 IDate;

run;

When I do this, I get "." for both Date1 and IDate and the error that IDate is uninitialized.. When I remove the Date1=IDate statement the Date format works out fine. I have a feeling it has something to do with the input statement. Any ideas?

Re: Dates from excel

dereck255 — Wed, 28 Jan 2015 02:22:52 GMT

I figured it out! Date1=IDate should be IDate=Date1;

Re: Dates from excel

Jagadishkatam — Wed, 28 Jan 2015 02:26:59 GMT

i dont think it is necessary to keep the variable IDate in the keep statement, it is this reason you got the uninitialized note.

From the input statement you are reading the date as date1 variable. so there is no need to use date1=ldate.

Thanks,

jag

Re: Dates from excel

Reeza — Wed, 28 Jan 2015 03:08:36 GMT

Why is the title of the question dates from Excel? This looks to be reading a tab delimited file.

MISSOVER is considered deprecated and TRUNCOVER should be used instead.

Re: Dates from excel

dereck255 — Wed, 28 Jan 2015 03:50:08 GMT

because the file is from excel - I just didn't show the dde.

Re: Dates from excel

art297 — Wed, 28 Jan 2015 04:29:41 GMT

: Where have you heard/read that missover has been deprecated?

Re: Dates from excel

Reeza — Wed, 28 Jan 2015 04:57:12 GMT

I think the term came up in a discussion either here or on SAS-L this month, the question was what is the difference between TRUNCOVER/MISSOVER.

I don't think it's actually deprecated, just no longer useful in the majority of situations.