180 likes | 504 Views
Hello SAS 9.4: What's New?. ChrIs Hemedinger, SAS. Just a Glance. Rushing to judgement. SAS 9.4. What's New for SAS Users? Some Highlights!. Filename ZIP XLSX support – extended for 9.4 DOSUBL Extended attributes on data sets New ODS output destinations Some notes about bitness.
E N D
Hello SAS 9.4: What's New? ChrIs Hemedinger, SAS
Just a Glance Rushing to judgement
SAS 9.4 What's New for SAS Users? Some Highlights! Filename ZIP XLSX support – extended for 9.4 DOSUBL Extended attributes on data sets New ODS output destinations Some notes about bitness
Bitness Supported Architectures Initial release of SAS 9.4 – 64-bit only on Windows SAS Enterprise Guide 6.1 – 64-bit only SAS Add-In for Microsoft Office – 32-bit and 64-bit Maintenance 1 release will re-introduced 32-bit applications SAS 9.4M1 brings back 32-bit support on Windows for SAS Foundation and SAS Enterprise Guide
Extended Attributes Store information about your data in your Data Ideas include: Add statistics (data set level or column level) Document formulas Embed an entire SAS program! More: http://support.sas.com/resources/papers/proceedings13/135-2013.pdf http://blogs.sas.com/content/sasdummy/2013/10/17/extended-attributes-sas-94/ Custom attributes that can enrich your SAS data
Extended Attributes Code example
Extended Attributes Result example
Filename ZIP Would you like to Read ZIP files? Can read ZIP files created on Unix or Windows without requiring zip commands Can be from any software producing ZIP files Password-protected ZIP files not supported Can write ZIP files as well Can be read by any software that reads ZIP files
ODS Package Reminder: How you can create ZIP files More: http://support.sas.com/resources/papers/proceedings13/131-2013.pdf
Reading ZIP files Member access example
INFILE with ZIP Using Directory-style syntax or MEMBER= Similar to FILENAME with directories, CATALOG
New XLSX Support XLSX enhancements with SAS/ACCESS to PC Files PROC IMPORT and EXPORT with DBMS=XLSX Add new sheet to existing workbook, replace an existing sheet XLSX is where it's at Does not require PC Files Server Not subject to 32-bit/64-bit complications
DOSUBL Submit SAS Code "On the SIDE" DOSUBL (new in 9.3m2) submits a complete step of SAS program code and waits while it executes Supports any SAS statements/steps Compare with CALL EXECUTE, which is SAS macro only
DOSUBL Example trick in SAS Enterprise Guide
ODS PowerPoint New ODS Destination: PowerPoint
Also: EPUB Book your results on e-Readers • ODS EPUB destination • Open e-book standard • Supported on a number of devices, including Apple iBooks http://support.sas.com/resources/papers/proceedings13/368-2013.pdf
Lots More See the What's New in SAS 9.4 doc http://support.sas.com/documentation/whatsnew