Hi All, I'm writing my first SAS program and I need some guidance on something very simple: I need to read a dataset from an excel file with multiple sheets (but I need to read one sheet). Here's the code I came with that doesn't work sofar. I needed to print the first 20 observations * Read data from external file into SAS data set; DATA Orders; INFILE 'C:\MySAS\Orders.xls'; sheet = "test"; INPUT OrdNum CustName CustAdd CustCd Item Price; Run; PROC PRINT DATA = Orders; sheet = "test"; TITLE 'MyOrders'; Run; Any help is greatly appreciated. Thanks,
... View more