Blog Feed: Learn SAS Programming

SAS Macro to put SAS data into Multiple Excel Work sheets

Published on 2011-02-06 09:13:34

I believe most of us have encountered this situation... I have a sas dataset with more than 70k records...How can I provide this information in an Excel file to the business user.... If one is using previous versions of MS Excel ie. < Excel 2 > read more

SAS Macro to put SAS data into Multiple Excel Work sheets

Published on 2011-02-06 09:13:34

I believe most of us have encountered this situation... I have a sas dataset with more than 70k records...How can I provide this information in an Excel file to the business user.... If one is using previous versions of MS Excel ie. < Excel 2 > read more

SAS Macro to put SAS data into Multiple Excel Work sheets

Published on 2011-02-06 09:13:34

I believe most of us have encountered this situation... I have a sas dataset with more than 70k records...How can I provide this information in an Excel file to the business user.... If one is using previous versions of MS Excel ie. < Excel 2 > read more

PUTLOG statement

Published on 2011-01-28 06:27:38

The PUTLOG statement writes a message that you specify to the SAS log. The PUTLOG statement is helpful when you use macro-generated code because you can send output to the SAS log without affecting the current file destination. The PUTLOG s > read more

PUTLOG statement

Published on 2011-01-28 06:27:38

The PUTLOG statement writes a message that you specify to the SAS log. The PUTLOG statement is helpful when you use macro-generated code because you can send output to the SAS log without affecting the current file destination. The PUTLOG s > read more

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

Published on 2010-10-20 20:56:13

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- > read more

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

Published on 2010-10-20 20:56:13

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- > read more

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

Published on 2010-10-20 20:56:13

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- > read more

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

Published on 2010-10-12 06:34:03

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 > read more

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

Published on 2010-10-12 06:34:03

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 > read more

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

Published on 2010-10-12 06:34:03

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 > read more

SAS Macros to Read data from MS Excel using DDE

Published on 2010-10-07 07:05:25

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 > read more

SAS Macros to Read data from MS Excel using DDE

Published on 2010-10-07 07:05:25

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 > read more

SAS Macros to Read data from MS Excel using DDE

Published on 2010-10-07 07:05:25

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 > read more

PUTLOG statement

Published on 2010-10-06 17:37:42

The PUTLOG statement writes a message that you specify to the SAS log. The PUTLOG statement is helpful when you use macro-generated code because you can send output to the SAS log without affecting the current file destination. The PUTLOG s > read more

SAS Project 5: General....SAS Technical Problem to solve....DIY

Published on 2010-10-05 05:35:40

Here's a little Complex SAS Reporting Example to work with... One of the Adhoc Reporting groups at a company maintains a MS Access Database of all the Internal and External Dept requests that are worked by a Data Analysts team. Now the Managem > read more