How to deal with the below ERROR: Import unsuccessful and The data set may be incomplete

[Silvan]

Error 1: 

 

Error 2:

Thanks!

[Kurt_Bremser]

Welcome to the communities!

Since I assume you do this on SAS On Demand, you must upload your file to the server first, and then use the path of the uploaded file.

If you do this from a Mac, use Chrome as your browser; several parts of SAS Studio do not work with Safari.

[Silvan]

Thanks for your reply! I installed the parallels command on MAC, I consider turning to the online version🤔. 

[Tom]

I see you seem to be trying to read from some file created on a MAC.

For some strange reason Excel on Mac never adopted to the fact that decades ago the MacOS switched to being a flavor of Unix and it defaults to writing text files using Carriage Return instead of Line Feed as the end of line markers.

Try setting the TERMSTR=CR option on the INFILE statement.  For the PROC IMPORT define a fileref using a FILENAME statement so you can add the TERMSTR=CR option there also.

If you are the one that created the CSV file from Excel on MAC then make sure to select the right filetype when saving so that it uses the proper end of line characters.

[Silvan]

Thank you for your detailed explanation! I will give it a try later.