Hello Experts,
I'm wondering if it is possible to import the csv file from 3rd row please ?
Thank you !
@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.
Are you using the Data Step or PROC IMPORT?
proc import 🙂
@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.
While I do agree with @Kurt_Bremser, your answer to the Proc Import problem can be found in the thread below 🙂
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.