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 2007 then one can provide the information in multiple excel sheets in an Workbook...or put it to ,(comma) or a | (pipe) delimited file and then open that with notepad/word application....  if you still wanted to stick with Excel... Plea

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 statement is similar to the ERROR statement except that PUTLOG does not set _ERROR_ to 1. The PUT statement writes to the LOG or to an External File with a FILE statement, but the PUTLOG statement always writes to the LOG. Try this... Please v

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-FTP-files-between-PC-and-Unix-or-among-Unix-servers var docstoc_docid="57936940";var docstoc_title="SAS Macro to FTP files between PC and Unix or among Unix servers";var docstoc_urltitle="SAS Macro to FTP files between PC and Unix or among...