HI , I try your code , but it is only read the first line of data which is empty. here is the note form the lot: NOTE: The infile "C:\Users\Guo\Desktop\trail 2015.csv" is: Filename=C:\Users\Guo\Desktop\trail 2015.csv, RECFM=V,LRECL=32767,File Size (bytes)=145, Last Modified=18Jun2018:13:56:50, Create Time=18Jun2018:13:56:49 NOTE: Invalid data for Plot in line 2 1-5. NOTE: Invalid data for Cultigennumber in line 3 1-20. NOTE: Invalid data for Rep in line 4 1-5. NOTE: Invalid data for Loc in line 5 1-8. NOTE: Invalid data for Std in line 5 9-16. NOTE: Invalid data for _1 in line 5 17-24. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+--- 1 Trial - 2015,,,,, 17 2 ,,,,, 5 3 food quality data,,,,, 23 4 ,,,,, 5 5 Plot,Cultigen number,Rep,Loc,Std,1 34 Plot=. Cultigennumber=. Rep=. Loc=. Std=. _1=. _ERROR_=1 _N_=1 NOTE: 6 records were read from the infile "C:\Users\Guo\Desktop\\trail 2015.csv". The minimum record length was 5. The maximum record length was 34. NOTE: SAS went to a new line when INPUT statement reached past the end of a line. NOTE: The data set WORK.FOODQUALITYDATA has 1 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.34 seconds cpu time 0.32 seconds The output is like this : SAS Output The SAS System Obs Plot Cultigennumber Rep Loc Std _1 1 . . . . . . do you know why? hoe can I fix it thanks.
... View more