topic Re: Read Multiple text files at a time in SAS Programming

Read Multiple text files at a time

BrahmanandaRao — Wed, 25 Nov 2020 04:47:56 GMT

/*Read multiple txt files*/

/*Method One*/

filename t 'C:\Users\Anand\Desktop\Pandas_rawdata\multiplefilesforreading\*.txt'		;
	data multi;
	infile t;
	input Name$ Sex$ Age $Height$ Weight$;
	proc print;run;


/*Method Two*/
%macro import_multitext(fname);

proc import 
datafile="C:\Users\Anand\Desktop\Pandas_rawdata\multiplefilesforreading/&fname..txt"
out=imptext.&fname.
dbms=tab
replace
;
run;

%mend;
%import_multitext(Class_1.txt);

Here I am trying to read text files at at time

I got problem in 1st method variables names also get two times

and 2nd method i didn't get output

Re: Read Multiple text files at a time

ChrisNZ — Wed, 25 Nov 2020 05:47:16 GMT

> I got problem in 1st method variables names also get two times

I do not understand

> and 2nd method i didn't get output

Unsurprising.

%import_multitext(Class_1);

might work better.

Re: Read Multiple text files at a time

BrahmanandaRao — Wed, 25 Nov 2020 05:54:28 GMT

Error Libname not assign

Re: Read Multiple text files at a time

ChrisNZ — Wed, 25 Nov 2020 06:15:20 GMT

If you want answers, provide information. What sort of reply is this?

This error message is not even accurate, and has nothing to do with the issue described so far.

Show us the log. Describe the problem. Provide the exact code used. Help us help you.

Re: Read Multiple text files at a time

BrahmanandaRao — Wed, 25 Nov 2020 07:23:19 GMT

Re: Read Multiple text files at a time

Kurt_Bremser — Wed, 25 Nov 2020 10:12:17 GMT

Show the log of the LIBNAME statement where you assign library imptext.

Re: Read Multiple text files at a time

ChrisNZ — Fri, 27 Nov 2020 01:27:20 GMT

The message states the library NAME is not assigned.

This library is not used (or defined) in the code shown.

Please ask a question that we can answer by provide a single, comprehensive, version of what you are doing.