topic Re: How to deal with the below ERROR: Import unsuccessful and The data set may be incomplete in New SAS User

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

Silvan — Sat, 04 Nov 2023 05:46:38 GMT

Error 1:

Error 2:

Thanks!

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

Kurt_Bremser — Sat, 04 Nov 2023 06:43:53 GMT

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.

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

Tom — Sat, 04 Nov 2023 12:45:11 GMT

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.

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

Silvan — Sat, 04 Nov 2023 14:06:19 GMT

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

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

Silvan — Sat, 04 Nov 2023 14:11:43 GMT

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