First row contains variable names

Reply
Occasional Contributor
Posts: 5

First row contains variable names

Hello again, I have a (probably) simple question and I feel dumb for not being able to figure it out.

 

The problem is that I have a text file and the first row contains variable names, how do I simply just delete the first row?

 

Thanks. 

 

Example:

 

Country, ID

USA, 1

China, 2

Germany, 3

Super User
Super User
Posts: 7,720

Re: First row contains variable names

How are you importing the file?  If its proc import then just add the option: firstobs=2;

If its a datastep (which is preferred) add firstobs=2 to the infile statement:
infile "yourfile.txt" firstobs=2;

 

 

Contributor
Posts: 44

Re: First row contains variable names

You can leverage the _n_ option and delete whichever specific record you want to delete.

Sample code attached.

data test ;
input country $ id ;
if _n_ =1 then delete ;
datalines ;
USA, 1
China, 2
Germany, 3
;
run ;

proc print data=test ;
run ;
Ask a Question
Discussion stats
  • 2 replies
  • 177 views
  • 0 likes
  • 3 in conversation