@Tom Actually I do get what IMPORT does, but the point of the exercise was the importing data from an EXTERNAL source. Hence, the inclusion of a path with "C:". Thus, my head scratching as to why this didn't work, when I followed the instructions. I know it's not "moving", but rather reading and creating a SAS Data Set from the external file. Per the Prep Guide: The IMPORT procedure reads data from an external data source and writes it to a SAS data set. You can import structured and unstructured data using PROC IMPORT. You can import delimited files (blank, comma, or tab) along with Microsoft Excel files. If you are using SAS 9.4, then you can import JMP 7 or later files as well. Per the Prep Guide: Example: Importing an Excel File with an XLSX Extension This example imports an Excel file and creates a temporary SAS data set, Work.BootSales. options validvarname=v7; /*#1*/
proc import datafile='C:\Users\Student1\cert\boots.xlsx' /*#2*/
dbms=xlsx
out=work.bootsales
replace;
sheet=boot; /*#3*/
getnames=yes; /*#4*/
run;
proc contents data=bootsales; /*#5*/
run;
proc print data=bootsales;
run; Thanks again. Hopefully, I don't sound snarky. Just finding the SAS learning curve fairly steep, and the way the guides and documentation are written seem to make it steeper.
... View more
