Showing posts with label Importing Files. Show all posts
Showing posts with label Importing Files. Show all posts
Wednesday, March 18, 2015

SAS Macro to Import CSV Files into SAS

›
/*********************************************************** IMPORT CSV files into SAS Work Library June 10, 2011 http://sastipsbyhal.bl...
Wednesday, June 13, 2012

SAS Macro to Import all Worksheets of an XLSX file

›
/* SAS Macro to import all worksheets of an XLSX file */ /* http://sastipsbyhal.blogspot.com/ */ /* Extra required software includes...
Tuesday, March 13, 2012

Example Libname Statement to Connect to a Password-Protected Microsoft Access MDB File

›
Example SAS libname statement to connect to a password-protected MDB file: LIBNAME myLib "\\filepath\database.mdb" DBPW="yo...
Friday, November 4, 2011

Importing Multiple Spreadsheets in SAS for Windows

›
What if you had to integrate data from a large number of spreadsheets scattered throughout a Windows file directory, including a number of ...
Tuesday, August 30, 2011

SAS Macro to Import Excel Files into SAS

›
/*********************************************************** IMPORT EXCEL files into SAS -works with both xls and xlsx files -assumes all...
Wednesday, July 6, 2011

How to create a SAS date from "YYYY-MM-DD HH:MM:SS"

›
Problem How to pull a SAS date from a text field formatted as YYYY-MM-DD HH:MM:SS. Solution data myTable; set myTable; informat date...
Friday, June 10, 2011

SAS Macro to Import Tab-Delimited Files into SAS

›
/*********************************************************** IMPORT TAB-DELIMITED text files into SAS June 10, 2011 http://sastipsbyhal....