proc export and then proc import-header raw is in raw data instead of in headers row

Ronein — Wed, 27 May 2020 06:07:35 GMT

Hello

I export a big SAS data set into txt file.

The txt file is with columns headers.

In the future I need to use this txt file and then I need to import it into SAS.

The problem is that when Iimport it then the header columns is in the rows of data instead of in the headers row.

What is the way to solve it?

proc export data=tbl1
outfile="/path/Revenue.txt"
dbms=tab replace;
run;


/*Import into SAS when need it*/
data Revenue; 
infile   "/path/Revenue.txt"
        dlm='09'X dsd truncover;
input ID
     branch
	  partition1 :$400.
	 partition2 :$400.
	  partition3 :$50.
	  SOURCE :$50.
 	  revenue	;
run;

Re: proc export and then proc import-header raw is in raw data instead of in headers row

Kurt_Bremser — Wed, 27 May 2020 06:18:51 GMT

See INFILE Statement, FIRSTOBS option.

topic Re: proc export and then proc import-header raw is in raw data instead of in headers row in SAS Programming

proc export and then proc import-header raw is in raw data instead of in headers row

Re: proc export and then proc import-header raw is in raw data instead of in headers row