Help using Base SAS procedures

What are the benefits of SAS 9.4 over 9.2

Reply
Super Contributor
Posts: 259

What are the benefits of SAS 9.4 over 9.2

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?

Super Contributor
Posts: 394

Re: What are the benefits of SAS 9.4 over 9.2

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.

Super User
Posts: 5,257

Re: What are the benefits of SAS 9.4 over 9.2

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.

Data never sleeps
Super Contributor
Posts: 259

Re: What are the benefits of SAS 9.4 over 9.2

Just the basic SAS product.

Super User
Posts: 5,257

Re: What are the benefits of SAS 9.4 over 9.2

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

Data never sleeps
Super User
Posts: 10,500

Re: What are the benefits of SAS 9.4 over 9.2

Lots of changes in the statistical graphics parts.

SAS Employee
Posts: 967

Re: What are the benefits of SAS 9.4 over 9.2

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.

Super User
Posts: 17,840

Re: What are the benefits of SAS 9.4 over 9.2

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 Smiley Happy

Super Contributor
Posts: 259

Re: What are the benefits of SAS 9.4 over 9.2

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

Regards

Super User
Posts: 17,840

Re: What are the benefits of SAS 9.4 over 9.2

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

Super Contributor
Posts: 259

Re: What are the benefits of SAS 9.4 over 9.2

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 !

Super User
Super User
Posts: 7,403

Re: What are the benefits of SAS 9.4 over 9.2

Theres a typo in your filename:

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

| should be \

Super Contributor
Posts: 259

Re: What are the benefits of SAS 9.4 over 9.2

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. 

Super User
Posts: 17,840

Re: What are the benefits of SAS 9.4 over 9.2

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.

Super Contributor
Posts: 259

Re: What are the benefits of SAS 9.4 over 9.2

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?

Ask a Question
Discussion stats
  • 20 replies
  • 660 views
  • 1 like
  • 7 in conversation