topic Re: First row contains variable names in SAS Programming

First row contains variable names

Peadymarvin — Thu, 08 Dec 2016 16:43:55 GMT

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

Re: First row contains variable names

RW9 — Thu, 08 Dec 2016 16:59:44 GMT

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;

Re: First row contains variable names

anoopmohandas7 — Fri, 09 Dec 2016 18:58:50 GMT

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 ;