topic Re: What are the benefits of SAS 9.4 over 9.2 in SAS Procedures

What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 14:36:39 GMT

My team have recently been updated to SAS 9.4 from 9.2 and I can't see any significant benefit so far.

Does it run faster? Any other benefits?

Re: What are the benefits of SAS 9.4 over 9.2

Tim_SAS — Tue, 27 Jan 2015 14:43:36 GMT

That's a big question. For a good overview, check out What's New in SAS 9.3 and What's New in SAS(R) 9.4.

Re: What are the benefits of SAS 9.4 over 9.2

LinusH — Tue, 27 Jan 2015 15:02:43 GMT

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.

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 15:05:00 GMT

Just the basic SAS product.

Re: What are the benefits of SAS 9.4 over 9.2

LinusH — Tue, 27 Jan 2015 15:08:12 GMT

So read the links provided by Tim, and list for yourself the things that you wish/need to improve in your environment.

Re: What are the benefits of SAS 9.4 over 9.2

ballardw — Tue, 27 Jan 2015 15:16:04 GMT

Lots of changes in the statistical graphics parts.

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 15:23:46 GMT

There are usually not many performance enhancements.

The enhancements are to procedures and options available.

For example:

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

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 15:31:26 GMT

Does ODS Excel mean you can export to Excel? Does you need additional license to do this?

Regards

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 15:39:36 GMT

Think of Tagsets.excelxp but it generates a native excel file. No additional license as far as I know.

Using ODS EXCEL and PROC EXPORT to bundle Excel-based reports - The SAS Dummy

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 16:13:01 GMT

DS2 is a new language available in SAS 9.4

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 16:15:04 GMT

Thanks Reeza

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";

Data daysinmonth;

input leapyr $3. days $2.;

datalines:

Y0131

Y0229

...

;

RUN;

ods excel file = temp;

proc export data = daysinmonth

dbms = xlsx

outfile = temp replace;

sheet = "test";

run;

I GET THE ERROR AFTER THE LAST STEP !

Re: What are the benefits of SAS 9.4 over 9.2

RW9 — Tue, 27 Jan 2015 16:25:41 GMT

Theres a typo in your filename:

filename temp "S:\Matthew|Report.xlsx";

| should be \

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 16:30:46 GMT

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.

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 16:58:43 GMT

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.

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 17:03:31 GMT

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?

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 17:06:07 GMT

proc print the dataset within the ODS open/close statements, similar to what you would do if using ods tagsets.excelxp.

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Tue, 27 Jan 2015 17:10:17 GMT

Reeza, thanks but I don't follow. Could you give an example of code you would use to achieve this?

Re: What are the benefits of SAS 9.4 over 9.2

Reeza — Tue, 27 Jan 2015 17:16:42 GMT

ods excel file='/folders/myfolders/sample.xlsx' style=minimal options(sheet_name='test');

proc print data=sashelp.class noobs;

run;

ods excel close;

Re: What are the benefits of SAS 9.4 over 9.2

GraphGuy — Tue, 27 Jan 2015 20:06:07 GMT

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.

Re: What are the benefits of SAS 9.4 over 9.2

brophymj — Wed, 28 Jan 2015 10:37:21 GMT

Thanks Reeza, that worked

Is there a way to stop excel from opening?

Also, can you populate multiple sheets this way?

Thanks