DATA Step, Macro, Functions and more

reading CSV file

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

reading CSV file

When reading in this csv I just want the data as I am making my own variable names, therefore I do not want the first line of the output.  I am unable to alter the data so is there away to delete or not read in this first row?  The picture was too large to upload but it basically shows a line with titles and then data following. 

 

thanks!


Accepted Solutions
Solution
‎12-06-2016 08:13 AM
Super User
Posts: 7,809

Re: reading CSV file

Use the firstobs=2 option in the infile statement to make SAS start reading in line 2 of the csv.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎12-06-2016 08:13 AM
Super User
Posts: 7,809

Re: reading CSV file

Use the firstobs=2 option in the infile statement to make SAS start reading in line 2 of the csv.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 12

Re: reading CSV file

Thank you so much!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 158 views
  • 0 likes
  • 2 in conversation