Proc import csv file

[SASdevAnneMarie]

Hello Experts,

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

Thank you !

[PeterClemmensen]

Are you using the Data Step or PROC IMPORT?

[SASdevAnneMarie]

proc import 🙂

[Kurt_Bremser · Accepted solution]

---

@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.

[SASdevAnneMarie]

Thank you, Kurt !

[PeterClemmensen]

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-IMPO...

[Patrick]

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