01-27-2015 10:02 AM
What SAS products do you license?
Need for any new SAS product?
What constraints/problems do you have in the existing environment?
9.2 is getting quite old, so the willingness from SAS to provide fixes might be limited.
01-27-2015 03:06 PM
If all you've just got is Base SAS (you said 'basic SAS'), there's a lot of new stuff in in the ods graphics (proc sgplot, etc).
If you have SAS/Graph, there's a lot of new and/or enhanced stuff.
If you've got SAS/Stat or SAS/OR, you'll see a lot of graphical new-ness via the ods graphics.
01-27-2015 10:23 AM
There are usually not many performance enhancements.
The enhancements are to procedures and options available.
Most of the statistical procs now include a CODE statement to allow for easier scoring, PROC REG no longer has the PLOT statement, and as has mentioned the graphical capabilities have been expanded. ODS Excel is experimental but useful.
Read the link above for more
01-27-2015 10:39 AM
Think of Tagsets.excelxp but it generates a native excel file. No additional license as far as I know.
01-27-2015 11:15 AM
I've tried testing the code in the link but I keep getting the error message "DBMS type XLSX not valid for export". Everything else seems to work i.e.
filename temp "S:\Matthew|Report.xlsx";
input leapyr $3. days $2.;
ods excel file = temp;
proc export data = daysinmonth
dbms = xlsx
outfile = temp replace;
sheet = "test";
I GET THE ERROR AFTER THE LAST STEP !
01-27-2015 11:30 AM
That typo is not in the sas program - i can't seem to paste anything into this discussion forums so i have to type the code again which is annoying.
01-27-2015 11:58 AM
If you don't have SAS Access to PC FILES you won't be able to run the proc export to add to the file, but the portion,before the proc export should generate a native Excel file.
01-27-2015 12:03 PM
It does generate a native excel fuile but is there a way of populating the native excel file with the contents from daysinmonth so that it achieves the same outcome as a proc export?