Here’s a macro that can put distinct values of a variable in a SAS dataset to a macro variable of your choice.%macroput_distinct_varvalues_in_list(dsn,var,mac_var,dlm=comma,quotes=double); %global&mac_var.; …
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….
OR
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…