csv output format

[ttxq]

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.

[Reeza]

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?

[ttxq]

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

[Cynthia_sas]

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

[ttxq]

Thank you so much Cynthia.