Hi, I'm trying to import this dataset into SAS (it's the NHIS 2019 adult dataset). I downloaded it as a csv, but have been having trouble importing csv files into SAS, so I converted it into an excel file, which I've had success with in the past. This is my code: libname nh "C:\users\Jodie-Ann\Documents\ile"; proc import out=nhis datafile = "c:\users\\Jodie-Ann\Documents\ile\adult2019.xlsx" dbms = excel replace; sheet = "sheet2$"; range = "A1:TN31998"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run; When I run I get this error: WARNING: SHEET name will be ignored if conflict occurs with RANGE name specified. ERROR: File _IMEX_.'sheet2$A1:TN31998'n.DATA does not exist. ERROR: Import unsuccessful. See SAS Log for details. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.44 seconds cpu time 0.25 seconds I've used this code before with a different data set that I converted from csv to excel, but not sure why it's not working this time. Any help would be appreciated, thank you!
... View more