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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.