topic Re: Export table in one row file in SAS Programming

Export table in one row file

luca87 — Mon, 28 Feb 2022 14:03:41 GMT

Hi,

I have a table with 5 rows and one column, the columns are formatted in $32759 (maximum allowed).
I need to export this table to txt format but it needs to be all in one row. If I do the proc export or data _null_ file and open the final file, for example with notepad++, I see that there are 5 rows. I have also tried transposing but I always have the same problem.

How can I do this? Obviously without using xcommand.

Thanks a lot!

Re: Export table in one row file

andreas_lds — Mon, 28 Feb 2022 14:30:59 GMT

Try something like this:

data _null_;
   set sashelp.class(keep=Name) end=lastObs;
   file "onerow.txt";
   
   if not lastObs then put Name @;
   else put Name;
run;

Re: Export table in one row file

japelin — Mon, 28 Feb 2022 14:34:03 GMT

how about this.

Use put statement with @.

data have;/* sample */
  length vars $32759;
  do i=1 to 5;
    vars=put(i,best.);
    output;
  end;
  drop  i;
run;

filename out temp ;
data _null_;
  set have;
  file out LRECL=163795;
  put vars @;
run;

Re: Export table in one row file

Ksharp — Tue, 01 Mar 2022 12:47:33 GMT

Check RECFM=N option of INFILE or FILENAME ,which could excess the limit of 32767.

data _null_;
set sashelp.class;
file 'c:\temp\want.txt' recfm=n;
put (_all_) (:);
run;