#Proc import sas code#
Read the file as-is, but add GUESSINGROWS=MAX statement to your import code Read your log NOTES and know the places where NA occurred you will have a missing value in your data set. Your file contained only numbers the 20 rows, so the procedure guessed class_size was numeric. Proc IMPORT guesses each fields data type based on looking at the first few rows (default is 20 rows) of a text file. Look under the period to confirm, the ZONE is 0 and NUMR 9. You are getting the NOTE: because of the NA value in the class_size field. Here is trick using the _INFILE_ automatic variable that you can use to make the change on the fly while reading the file.
Since all of the fields are numeric you can do that easily because you don't have to worry about replacing real text that just happens to have the letter A after the letter N.
One way to deal with the NA text in the input file is to replace them with periods. Input sl_no school iq test ses class_size meanses meaniq Infile '/home/u44418748/MSc Biostatistics with SAS/Datasets/school.txt' Since it looks like your file only has six variables and they are all numeric the code is trivial. I wouldn't bother to use PROC IMPORT to read a delimited file. For SAS you can use a period to represent a missing value. So the delimiters are right next to each other. In a delimited file missing values are normally represented by having nothing for the field. If you are the one that created the file the you might check if the system you are using has a way to not put the NA into the file to begin with. Did you create that text file from R? That package has a nasty habit of putting text values of NA for numeric values into text files.
0 kommentar(er)
