![]() You need to find shared folder which is generally available as Folders > My Folders PROC IMPORT DATAFILE= "c:\deepanshu\sampledata.xls" The main keywords used in the following program are : It supports various formats such as excel file, csv, txt etc. You don't need to specify variable type and variable length to import an external file. PROC IMPORT is a SAS procedure to import external files into SAS. For colon delimiter, the syntax would be infile 'file-description' dlm=':'.For tab delimiter, the syntax would be infile 'file-description' dlm='09'x.Syntax : Infile 'file-description' dlm=',' If you have a data file with other delimiters such as comma or tab you need to define the delimiter before defining the variables using INFILE and DLM = options. There is no difference between these two keywords. You can also use CARDS instead of DATALINES. ![]() RUN - The DATA step ends with a RUN statement. ![]() PROC PRINT - To print out the contents of data set in output window.Ħ. DATALINES - To indicate that lines following DATALINES statement a real data.ĥ. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |