Three primary input styles in SAS List input Column input Formatted input
Three primary input styles in SAS ——List input ——Column input ——Formatted input
List input you can use the INPUT statement with list input to read 1.free-format data(data that is not organized in fixed fields)自由格式数据 2.free-format data that is separated by nonblank delimiters,such as commas以非 空格为分隔符 3.free-format data that contains missing values含缺失值
List input • you can use the INPUT statement with list input to read 1. free-format data (data that is not organized in fixed fields)自由格式数据 2. free-format data that is separated by nonblank delimiters, such as commas以非 空格为分隔符 3. free-format data that contains missing values含缺失值
4.character values that exceed eight Characters超过8个字符的字符型值 5.nonstandard free-format data非标准 数据 6.character values that contain embedded blanks含嵌入空格的字符型值
4. character values that exceed eight Characters超过8个字符的字符型值 5. nonstandard free-format data非标准 数据 6. character values that contain embedded blanks含嵌入空格的字符型值
Most free-format data fields are clearly separated by blanks and are easy to imagine as variables and observations. But fields can also be separated by other delimiters,such as commas,as shown below. Raw Data File Credit ·例 -+-10-+ -20 MALE,27,1,8,0,0 FEMALE,29,3,14,5,10 FEMALE,34,2,10,3,3 MALE,35,2,12,4,8 FEMALE,36,4,16,37 MALE,21,1,5,0,0 MALE,25,2,9,2,1 FEMALE,21,1,4,26 ALE,38,3,11,4,3 FEMALE,30,3,5,1,0
• Most free-format data fields are clearly separated by blanks and are easy to imagine as variables and observations. But fields can also be separated by other delimiters, such as commas, as shown below. • 例
When characters other than blanks are used to separate the data values,you can tell SAS which field delimiter to use.Use the DLM= option in the INFILE statement to specify a delimiter other than a blank(the default). ·data perm.survey; infile credit dlm=','; input Gender Age Bankcard FreqBank Deptcard FreqDept; run; The field delimiter must not be a character that occurs in a data value
• When characters other than blanks are used to separate the data values, you can tell SAS which field delimiter to use. Use the DLM= option in the INFILE statement to specify a delimiter other than a blank (the default). • data perm.survey; infile credit dlm=','; input Gender $ Age Bankcard FreqBank Deptcard FreqDept; run; • The field delimiter must not be a character that occurs in a data value