01-27-2015 09:21 PM
Please see below:
infile file1 dlm='09'x notab dsd missover;
informat Date1 DATE.;
input Name $ Num1 Name2 $ Num2 Date1 Var1 Var2 Var3;
format Date1 IDate date10.;
keep Name Num1 Name2 Num2 Date1 IDate;
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?
01-27-2015 09:26 PM
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.
01-27-2015 10:08 PM
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.
01-27-2015 11:57 PM
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.
Need further help from the community? Please ask a new question.