BookmarkSubscribeRSS Feed
sy2011
Calcite | Level 5
Hi,

Can I use PROC IMPORT to import delimited text file which contains a lots of comment lines at the beginning of the file. The comment lines are marked with "#"s. I want to exclude the comment lines and start to import at the header line.

Thanks.

sy
6 REPLIES 6
ballardw
Super User
Single input file or multiple input files with varying numbers of comment lines?
sy2011
Calcite | Level 5
I've resolved the problem. Thank you for your reply.
sy2011
Calcite | Level 5
Thank you for all your replies. I've resolved the problem by using DBailey's approach, i.e., I used substr( ) to delete the lines with #s in the DATA step.
Ksharp
Super User
It seems that proc import cann't do it, But Import Data Wizard in sas menu can choose the start row of data. Maybe it is not what you want.


Ksharp
DBailey
Lapis Lazuli | Level 10
You could always fall back and write your own data step to check the first character of the line before parsing and outputting the data set.
sss
Fluorite | Level 6 sss
Fluorite | Level 6
HI
I am not sure about the wizard but you can do by code

data dataset_name;
infile 'path\file.txt' dlm='#&*';
input var1$ var2 ;
run;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 1159 views
  • 0 likes
  • 5 in conversation