My xlsx file has 4650 records and 7 columns. Proc import only reads in 4500 records. When I run the file through stat transfer and create a new file the new file will import correctly. SAS version 9.3.
Works fine for me.
1294 libname x xlsx "&path\test file.xlsx"; NOTE: Libref X was successfully assigned as follows: Engine: XLSX Physical Name: C:\Downloads\test file.xlsx 1295 proc copy inlib=x outlib=work; 1296 run; NOTE: Copying X.TEST to WORK.TEST (memtype=DATA). NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used. NOTE: The import data set has 4560 observations and 7 variables. NOTE: There were 4560 observations read from the data set X.TEST. NOTE: The data set WORK.TEST has 4560 observations and 7 variables.
How did you try to read it?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.