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.
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?
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
Thank you so much Cynthia.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.