Desktop productivity for business analysts and programmers

Importing csv causes a dot if null value

Reply
Frequent Contributor
Posts: 131

Importing csv causes a dot if null value

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.

Super Contributor
Posts: 296

Re: Importing csv causes a dot if null value

Frequent Contributor
Posts: 131

Re: Importing csv causes a dot if null value

options missing='' ;

worked well.  Thanks

Ask a Question
Discussion stats
  • 2 replies
  • 662 views
  • 1 like
  • 2 in conversation