In this statement, PROC IMPORT uses the Input library (Permanent library).ģ. ![]() This implies OUT = Age is equivalent to OUT = Work.Age. In this statement, PROC IMPORT uses the WORK library. By default, the imported dataset is saved on WORK library (temporary library) OUT= option tells SAS to create a dataset with any name of your choice. In SAS University edition, file location would beĭATAFILE = "/folders/myfolders/Boards.xls"Ģ. You need to find shared folder which is generally available as Folders > My Folders DATAFILE= option tells SAS where to find the Excel file that you want to import (Complete filename path).įor example : DATAFILE = "C:\Desktop\age.xls" Most of the raw data files are saved in MS Excel so we need to take it to SAS for further analysis.ġ. ![]() Loading excel data to SAS is one of the most common task of a SAS programmer / analyst. This tutorial covers how to import excel data to SAS with PROC IMPORT. PROC IMPORT is the SAS procedure used to read data from excel into SAS.
0 Comments
Leave a Reply. |