/***********************************************************************************
* This program is taken from the following book. If using please cite it as: *
* Emrouznejad, A. and W. Ho (2012). Applied Operations Research with SAS, *
* CRC Press: Taylor Francis Ltd, ISBN: 9781439841303. *
* For details please visit: http://www.sas-or.com. *
************************************************************************************/
* Program A1.4: An example of PROC IMPORT;
* Import Data from an EXCEL File;
proc import
datafile = ”c:/sasor/mydataspace.txt”
out = mydata
dbms = EXCEL2000
replace;
getnames = yes;
run;
/****************************************************************************
******************************END of the program*****************************
****************************************************************************/