topic Importing csv causes a dot if null value in SAS Enterprise Guide

Importing csv causes a dot if null value

Q1983 — Tue, 04 Nov 2014 00:51:51 GMT

Date 1st HAMP Trial Payment Rece

Here is an example of output when I import a .csv file into sas and then output it. If the value is a numeric or a date and the date is a null it assigns a period or dot.(hard to see here) I want the field to be blank and not show a dot when importing. The file type as an example here is Date/MMDDYY 10 so if there is a date it will something like this 10/15/2014. I am using the Import Data utility here.

Re: Importing csv causes a dot if null value

Scott_Mitchell — Tue, 04 Nov 2014 01:00:27 GMT

Use the Missing System Option as documented here http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000227574.htm

Re: Importing csv causes a dot if null value

Q1983 — Tue, 04 Nov 2014 13:51:06 GMT

options missing='' ;

worked well. Thanks