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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.