Hello, I am looking for some suggestions. I'm importing a .csv that has NULL values in numeric fields (using SAS 9.4). I have created the code below based on some google searches. It works fine EXCEPT when I reference nulls in the informat statement, it crops my numeric values to two decimal places. If I try to specify a numeric format (e.g. ConVol nulls. 9.5) I get an error "Syntax error, expecting one of the following: a name, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_." I would like to retain all decimal places. And suggestions on how I can modify this code? Thanks in advance! PROC FORMAT; invalue nulls 'NULL'=. ; RUN; DATA yield; informat FMAID 2.0 Model $10.0 YieldClass 3.0 ConVol nulls. ; infile 'Z:\vol.csv' dsd dlm=',' missover firstobs=2 LRECL=32767 n=500; input FMAID Model $ YieldClass ConVol; RUN; (Sample Data for reference) FMAID Model YieldClass ConVol 1 Vol/Age 1 0 1 Vol/Age 1 0.74387 1 Vol/Age 1 NULL 1 Vol/Age 1 17.6377 1 Vol/Age 1 36.11641 1 Vol/Age 1 115.1822 1 Vol/Age 1 86.87595 1 Vol/Age 1 NULL 1 Vol/Age 1 143.0345
... View more