topic Re: Creating a comma delimited text file in SAS Procedures

Creating a comma delimited text file

uksusu — Thu, 05 May 2011 08:58:07 GMT

I need some help converting a SAS dataset into a specific Text file format
The ideal format for the text files would be:

All files should be in text format with each line of data ended with a {CR}{LF} character pair.
All fields REGARDLESS OF TYPE should be encapsulated in double quotes and separated by a single comma.
Any date values should be in the form “YYYY-MM-DD”.
Header and trailer records are not required.

Below is an example record of the output type I need:

"56979","GCR011","3882","Actual","2010-10-31","179.09"
"45153","GCR011","3000","Actual","2011-01-31","75.80"

Within the dataset dates and numerics are formatted as date and numeric variables.

Thanks in advance

Re: Creating a comma delimited text file

data_null__ — Thu, 05 May 2011 11:06:23 GMT

Use a filename where I used TEMP.

[pre]
filename FT56F001 temp;
data _null_;
file FT56F001 dsd termstr=crlf;
set sashelp.class;
today = date();
format today yymmdd10.;
put (_all_)(~);
run;

proc fslist file=ft56f001;
run;
[/pre]

Re: Creating a comma delimited text file

sss — Thu, 05 May 2011 14:18:22 GMT

Hi

Very simple way to do is by ODS.

Code goes here

ODS CSV FILE="C:\TEXTDATA.CSV";
PROC PRINT DATA=SASHELP.CLASS;
RUN;
ODS CSV CLOSE;

Re: Creating a comma delimited text file

uksusu — Thu, 05 May 2011 14:38:35 GMT

Thanks data _null_.

I got it working apart from one issue. The actual width of my report is much larger than the example and has 45 variables. Before it reached the end of the first observation though the text file creates at carriage return (without a comma separation) and creates a new line.

EG: -
"56979","GCR011","3882","Actual"
"2010-10-31","179.09"
"45153","GCR011","3000","Actual","2011-01-31"
"75.80"

Is there a way around this at all?

Thanks...

Re: Creating a comma delimited text file

uksusu — Thu, 05 May 2011 14:44:10 GMT

Sorry, I've ised the lrecl= to set width and it appears ok.
However, I want to confirm that by setting the lrecl= does that affect the 'carriage return' ({CR}{LF} character pair) I need at the end of each line?

Thanks......

Re: Creating a comma delimited text file

data_null__ — Thu, 05 May 2011 16:30:38 GMT

You are correct as long as LRECL is big enough for the longest record everthing else will be OK.

Re: Creating a comma delimited text file

uksusu — Fri, 06 May 2011 08:06:52 GMT

Thanks for all the help, it all works perfectly now. 🙂