topic Proc Export in SAS Studio

Proc Export

Aidan — Fri, 07 Apr 2017 13:15:31 GMT

Hi There

I want to add blank spaces at the end of my exported .csv file.

The csv file is formatted correctly but I cannot get the blank spaces at the end. It stops at 475 but need it to continue to col 600

The data is all concatenated into 1 string and is all converted to text as per attached

PROC EXPORT DATA=work.W4NV5KA
OUTFILE="\\xxxx\xxx\xxxx\Test.txt";
DBMS=CSV REPLACE;
PUTNAMES=NO; 
RUN;

Re: Proc Export

Reeza — Fri, 07 Apr 2017 13:24:39 GMT

It sounds like you need a fixed width format instead? But that wouldn't make sense with a comma delimited file.

Your best bet is a manual export using a data step you can specify the LRECL to indicate your record length.

You can start off by using the code generated in the log from your PROC EXPORT and add the LRECL to the FILE statement.

http://stats.idre.ucla.edu/sas/faq/how-do-i-write-out-a-file-that-uses-commas-tabs-or-spaces-as-delimiters-to-separate-variables-in-sas/

File statement docs

http://support.sas.com/documentation/cdl/en/lestmtsref/69738/HTML/default/viewer.htm#n15o12lpyoe4gfn1y1vcp6xs6966.htm

Re: Proc Export

Aidan — Fri, 07 Apr 2017 13:31:14 GMT

Do you mean jsut add the LRECL = 650 for example below?

PROC EXPORT DATA=work.W4NV5KA
OUTFILE="\\xxxx\Test.txt" LRECL=650
DBMS=TAB REPLACE;
PUTNAMES=NO;
RUN;

Re: Proc Export

RW9 — Fri, 07 Apr 2017 13:31:53 GMT

Errm, CSV = Comma Separated Variable file. What does spaces have to do with this? The comma is the delimiter.

Re: Proc Export

Aidan — Fri, 07 Apr 2017 13:33:21 GMT

Just seeing if its possible

Re: Proc Export

Reeza — Fri, 07 Apr 2017 13:38:53 GMT

@Aidan wrote:

Do you mean jsut add the LRECL = 650 for example below?

PROC EXPORT DATA=work.W4NV5KA
OUTFILE="\\xxxx\Test.txt" LRECL=650
DBMS=TAB REPLACE;
PUTNAMES=NO;
RUN;

LRECL is not a valid option in PROC EXPORT. I'm not seeing a way to do this using PROC EXPORT. The first link has an example of the data step code. You'd change the LRECL in the FILE statement in the data step.

I'm assuming that setting the 'string' to a length of 650 didn't automatically give you a length of 650.

Re: Proc Export

ballardw — Fri, 07 Apr 2017 15:09:26 GMT

@Aidan wrote:
Just seeing if its possible

Note with proc export. Export is very limited.

Re: Proc Export

Tom — Sat, 08 Apr 2017 15:29:26 GMT

It is possible. Stupid, but possible.

Use a FILENAME statement so you can tell SAS that your file should be fixed length.

filename csv temp lrecl=30 recfm=f;
proc export data=sashelp.class file=csv replace
  dbms=csv 
;
run;
data _null_;
  infile csv length=len;
  input;
  put _n_ 3. len 3. +1 _infile_;
run;