topic Re: Proc import csv file in SAS Programming

Proc import csv file

SASdevAnneMarie — Wed, 22 Sep 2021 08:30:36 GMT

Hello Experts,

I'm wondering if it is possible to import the csv file from 3rd row please ?

Thank you !

Re: Proc import csv file

PeterClemmensen — Wed, 22 Sep 2021 08:31:31 GMT

Are you using the Data Step or PROC IMPORT?

Re: Proc import csv file

SASdevAnneMarie — Wed, 22 Sep 2021 08:38:19 GMT

proc import 🙂

Re: Proc import csv file

Kurt_Bremser — Wed, 22 Sep 2021 08:44:25 GMT

@SASdevAnneMarie wrote:

proc import 🙂

Quick answer: don't.

It's not worth to use IMPORT and having to clean up the mess later. Write the data step yourself, according to the documentation of the file. You get full control over types, informats, formats, and where to start reading the data.

We read hundreds of files, and not one of the jobs uses PROC IMPORT.

Re: Proc import csv file

PeterClemmensen — Wed, 22 Sep 2021 09:10:13 GMT

While I do agree with @Kurt_Bremser, your answer to the Proc Import problem can be found in the thread below 🙂

https://communities.sas.com/t5/SAS-Procedures/variable-names-in-quot-row-2-quot-how-to-let-PROC-IMPORT-to/td-p/68009

Re: Proc import csv file

Patrick — Wed, 22 Sep 2021 09:17:01 GMT

Proc Import gives you less control what happens than a SAS data step which is why quite a few people don't like to use it but....

Have a look into the datarow statement. That should do what you're looking for.

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/p08ss3c3xtt2qzn1fsma45gyz333.htm

Re: Proc import csv file

SASdevAnneMarie — Wed, 22 Sep 2021 14:14:05 GMT

Thank you, Kurt !