topic Re: importing data from a csv, null field in SAS Programming

importing data from a csv, null field

Crysis85 — Tue, 11 Oct 2016 13:14:10 GMT

Hello,

So, I have to import data from a csv file in pretty good shape to a new SAS table.

In a data step I set up INFORMATs FORMATs and the INPUT statement. The file is imported correctly the only problem is that instead of just missing values (as in ,,) some field have ,null, as a value between separators. That particular variable will be numeric so when on that value I give a numeric INFORMAT (like BEST2. since there are 2 digits numbers where there isn't null) the log shout at me "invalid data".

Take notice that the resulting table is correct, in that particular field I have, as I should, the period.

How can I resolve the warnings?

Re: importing data from a csv, null field

Kurt_Bremser — Tue, 11 Oct 2016 13:23:40 GMT

You could create a custom format:

proc format library=work;
invalue testfmt
 'null' = .
  other=best.
;
run;

data test;
input x1 testfmt.;
cards;
null
1
2
0
.
;
run;

Re: importing data from a csv, null field

Crysis85 — Tue, 11 Oct 2016 13:25:52 GMT

Didn't think of that, thanks!