Tag: SAS Macros

Proc SQL and the power of select into

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 …

SAS Macro to FTP files between PC and Unix or among Unix server Locations…

Here’s a SAS Macro to FTP files between PC and Unix, or among Unix servers etc….

http://snipplr.com/view/42667/sas-macro-to-ftp-files-between-pc-and-unix-or-among-unix-server-locations/

OR

http://www.docstoc.com/docs/57936940/SAS-Macro-to-FTP-files-between-PC-and-Unix-or-among-Unix-servers

SAS Macro to FTP files between PC and Unix or among Unix servers


Default value to macro variable

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 exist. […]

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…

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…