topic Re: csv output format in ODS and Base Reporting

csv output format

ttxq — Thu, 29 Dec 2016 21:28:15 GMT

Hi all,

I just got a question about csv output file.

This is the headings I got from ods csv

2013				2014				2015
Total	ADMISSION RECORD FOUND			Total	ADMISSION RECORD FOUND			Total	ADMISSION RECORD FOUND
	Found	Not found	9	Found	Not found	9	Found	Not found	9
Number	Number	Number	Number	Number	Number	Number	Number	Number	Number	Number	Number

but what I want is

2013				2014				2015
Total	ADMISSION RECORD FOUND			Total	ADMISSION RECORD FOUND			Total	ADMISSION RECORD FOUND
	Found	Not found	9		Found	Not found	9		Found	Not found	9

What should I do to adjust the headings, Thanks a lot.

Re: csv output format

Reeza — Thu, 29 Dec 2016 21:32:27 GMT

Post your code.

CSV is comma delimited file, is this the type of file you want, or do you want an Excel file?

Also, what version of SAS do you have?

Re: csv output format

ttxq — Thu, 29 Dec 2016 21:40:47 GMT

ODS csv FILE = "test.csv" ;

proc tabulate missing format=7. formchar=' ' data=a;
class statefip sub recfnd disyr / preloadfmt;
tables statefip all, sub all, disyr*(all recfnd) /box='Characteristics' condense rts=53 printmiss misstext='0';
keylabel N='Number' ALL='Total' PctN='Pct';
run;

ods csv close;

Yes, the csv file is what I want. And I use SAS 9.4

Re: csv output format

Cynthia_sas — Fri, 30 Dec 2016 15:11:23 GMT

Hi: It appears that you do not want "Number" to appear in the results. Is that correct? Your code is putting "Number" in the final row of header cells. You should be able to suppress it by altering your KEYLABEL statement.

Instead of this:
keylabel N='Number' ALL='Total' PctN='Pct';

Try this:
keylabel N=' ' ALL='Total' PctN='Pct';

after the N=, it is quote-space-quote.

cynthia

Re: csv output format

ttxq — Tue, 17 Jan 2017 16:13:33 GMT

Thank you so much Cynthia.