Hello,
I need to import an excel file with a where condition saying pull only col a with dateformat .
Example : I have a table with 3 columns as follows
Col A Col B Col C
23/11/2018 Cars 2000
24/10/2018 Buses 4000
Null
test 600
When I import the above table into sas, I need to pull in data where Col A is non-empty and Col A has only dates.
proc import datafile =filepath
out=work.input (where=(Not Missing(A) & A=date9.))
dbms=xlsx replace;
getnames=No;
run;
Can someone suggest best way to do this.
Thanks in advance all the help you provide 🙂