topic Re: How to concatenate a value of data set to another data set in SAS Programming

How to concatenate a value of data set to another data set

yadaw — Tue, 16 Jan 2018 07:18:54 GMT

I have two files with some data.

file1.txt

123

456

789

100

file2.txt

ABC

I want output file file3.txt as:-

123ABC

456ABC

789ABC

100ABC

How can i do this?

Re: How to concatenate a value of data set to another data set

PeterClemmensen — Tue, 16 Jan 2018 07:26:51 GMT

one way

data file1;
input numVar;
datalines;
123
456
789
100
;

data file2;
charVar="ABC";
run;

proc sql;
	create table file3 as 
	select cats(numVar, charVar) as newVar
	from file1, file2;
quit;

Re: How to concatenate a value of data set to another data set

PeterClemmensen — Tue, 16 Jan 2018 08:12:26 GMT

Btw, do you want to output this as a TXT file?

And are file1 and file2 SAS data sets?

Re: How to concatenate a value of data set to another data set

yadaw — Tue, 16 Jan 2018 08:52:35 GMT

Output should be in file and file1 and file 2 are data sets

Re: How to concatenate a value of data set to another data set

PeterClemmensen — Tue, 16 Jan 2018 08:53:20 GMT

You mean that your output should be in a TXT file?

Re: How to concatenate a value of data set to another data set

yadaw — Tue, 16 Jan 2018 08:55:35 GMT

No any file, doesn't matter text or any other.

Re: How to concatenate a value of data set to another data set

PeterClemmensen — Tue, 16 Jan 2018 09:00:25 GMT

You can do something like this with a data step

data _null_;
	set file3;
	file "MyPath\MyFile.txt";
	put newVar;
run;

Or alternatively PROC EXPORT to export the file

Re: How to concatenate a value of data set to another data set

Astounding — Tue, 16 Jan 2018 14:39:21 GMT

The INFILE and FILE statements actually require complete paths, not just the file name itself:

data _null_;

infile "file2.txt";

input part2 $;

infile "file1.txt" end=done;

file "file3.txt" noprint;

do until (done);

input part1 $;

put part1 +(-1) part2;

end;

run;