Posts Tagged ‘ SAS Macros ’

Proc SQL and the power of select into

May 16, 2013
By

I have referenced this paper many times. Great help in using the power of proc sql with macro variables. Great for building lists of values and dynamic code. http://www.nesug.org/Proceedings/nesug97/coders/eddlesto.pdf Syntax: SELECT object-item ... ...
Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off

Default value to macro variable

October 12, 2010
By

NOTE: This is a great one we picked up from our friends over at the SAS community. We have run across this literally hundreds of times while programming SAS macros. You need to have a default value for a variable and you don’t want to write another macro to set it if it doesn’t...
Read more »

Tags: , , , , , , , , , , , , , , , , ,
Posted in SAS | Comments Off

SAS Macros to Search and Report Errors and Warnings from your SAS Logs

October 12, 2010
By
SAS Macros to Search and Report Errors and Warnings from your SAS Logs

How many a times at work have you gone thru the logs looking for ERROR, WARNINGS, NOTES etc for more information about the generated problem?...I've been doing a lot like that lately for developing / debugging / lines of code for more information...I j...
Read more »

Tags: , , , , , ,
Posted in SAS | Comments Off

SAS Macros to Read data from MS Excel using DDE

October 7, 2010
By
SAS Macros to Read data from MS Excel using DDE

Here are a set of SAS Macros to read data from MS Excel using DDE... Let me explain with some scenarios with the Excel data stored in "C:\Names.xlsx" in worksheet named "Sheet1"... This excel file has in fact data that can be read into 2...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.