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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.