any errors kindly correct input statement=>contains sequence of arguments INPUT <variables> <informats> <record-directives> <positionals>; varaible: char $ or & and numeric(default length=8) informat: char=w. numeric=w.d (w=width,d=decimal) record-directives :to hold the current record so that you can continue to read from the record with later INPUT statements. Otherwise, IML automatically goes to the next record for the next INPUT statement positionals: go to a specific column on the record @ operand ;to go to the indicated column For example, @30 means to go to column 30 + operand specifies to skip the indicated number of columns.;; data; input ========> cards ==============> conditions ====================> output compilation 1. syntax errors 2 pdv class 3 a b c 4 c n n 5 8 8 8 6 _ . . Execution Phae : pdv output a b c a b c _ . . 1 2 3 1 2 3 _ . . 4 5 6 4 5 6 _ . . 7 8 9 7 8 9 4 th ; data class; input a b ; datalines ; /*cards*/ 1 2 3 4 5 6 flowover 7 8 9 ; run; input ========> cards ==============> conditions ====================> output pdv output a b a b . . 1 2 1 2 . . 4 5 4 5 . . 7 8 7 8 . . ; data; INPUT <specification(s)><@|@@>; The INPUT statement with no arguments is called a null INPUT statement. The null INPUT statement; data _null_; set sashelp.class; run; specifications: variable: data var; input var1 var2 $; datalines; 1 rajesh 2 satheesh ; run; variable list; data var_list; input var1-var3 ; datalines; 1 2 3 3 4 5 ; run; pointer control: (moves the input pointer to a specified line or column); data point_ctr; input @3 a @5 b; datalines; 1 23456 6 54321 ; run; column-specifications: specifies the columns of the input record that contain the value to read. ; data clm_spc; input a 1-3 b 5-6; datalines; 123 45678 6547 2536 ; run; format-modifier : allows modified list input or controls the amount of information that is reported in the SAS log when an error in an input value occurs. ; data format_md; /*input a b ;*/ input a dollar4. b comma7.; format a dollar5. b comma7.; datalines; $250 1,200 $356 21,345 ; run; informat. specifies an informat to use to read the variable value.; data informat_md; /*input a b ;*/ input a dollar4. b comma7.; format a dollar5. b comma7.; datalines; $250 1,200 $356 21,345 ; run; @ holds an input record for the execution of the next INPUT statement within the same iteration of the DATA step. This line-hold specifier is called trailing ; data at_rate; input a b @; if b=2 then do; input @5 c 1. @7 d 1.;end; else if b=3 then delete; datalines; 1 2 3 6 5 0 3 5 6 0 3 2 6 1 2 3 5 5 ; run; data at_rate1; input a b @ ; /*if remove @ then chek reult*/ input c d ; datalines; 1 2 3 6 5 0 3 5 6 0 3 2 6 1 2 3 5 5 ; run; @@ holds the input record for the execution of the next INPUT statement across iterations of the DATA step. This line-hold specifier is called double trailing @. ; data at_at_rate; input a b c @@; datalines; 1 2 3 4 5 6 7 8 9 ; run; Column Pointer Controls : @n moves the pointer to column n. ex: @15 moves the pointer to column 15: ; data cp_control; /*input @1 a $ @2 b$ @3 c;*/ input @1 a 1. @2 b $1. @3 c ; datalines; 1M3 2F4 4F3 ; run; @numeric-variable: moves the pointer to the column given by the value of numeric-variable.; data numer_var(drop= d e f); d=1;e=2;f=3; input @d a 1. @e b $1. @f c ; datalines; 1M3 2F4 4F3 ; run; @(expression) moves the pointer to the column that is given by the value of expression. @'character-string' : locates the specified series of characters in the input record and moves the pointer to the first column after character-string. ; data at_cst; input @'ravi' name $4. @'5' b $3.; datalines; kinravikijg 345369 ksravilkkj 25623 ; run; @character-variable : locates the series of characters in the input record that is given by the value of character-variable and moves the pointer to the first column after that series of characters. data at_cst_var; a='ravi'; input @a name $4. @'5' b $3.; datalines; kinravikijg 345369 ksravilkkj 25623 ; run; @(character-expression)/@'character-string': locates the series of characters in the input record that is given by the value of character-expression and moves the pointer to the first column after the series. +n : moves the pointer n columns; data nplus; /*input a +2 b +3 c;*/ input a +1 b +2 c; datalines; 1 2345 6789 98 7465 231 ; run; +numeric-variable : moves the pointer the number of columns that is given by the value of numeric-variable. +(expression) moves the pointer the number of columns given by expression Line Pointer Controls: #n: moves the pointer to record n data at_the_rate6; input #1 a b c #2 d e f; datalines; 1 2 3 4 5 6 7 8 9 10 11 12 ; run; data at_the_rate5; input a b c; input d e f; datalines; 1 2 3 4 5 6 7 8 9 10 11 12 ; run; /*One input statement, one semicolon, and*/ /*END; forward slash pointers:*/ data at_the_rate5; input a b c/d e f; datalines; 1 2 3 4 5 6 7 8 9 10 11 12 ; run; #numeric-variable : moves the pointer to the record that is given by the value of numeric-variable. #(expression): moves the pointer to the record that is given by the value of expression. modifers : & and colon : Ampersand (&) Modifier : It controls the SAS system, values are separated by more than one space. When we use the ampersand format modifier, two blanks are required to signal the end of a data value. It can effectively deal with embedded spaces/blanks.We can also control length of the variable. It recognizes One single blank --> Embedded blank More than one blank --> Delimiter blank Colon(:) Modifier : It controls the length of the variable and call the informat techniques. data modifiers ; infile cards; input eid name & $ 19. Des & $ 18. ; cards; 101 Kiran Kumar varma Tester 102 Swati Vohra Finance Analyst 103 Kranthi Bommasani Programmer ; run; " The ~ (tilde) format modifier ; enables you to read and retain single quotation marks, double quotation marks, and delimiters within character values."; " The : (colon) format modifier enables you to use list input but also to specify an informat after a variable name, whether character or numeric. SAS reads until it encounters a blank column, the defined length of the variable (character only), or the end of the data line, whichever comes first."; data scores; infile datalines dlm="," dsd; input Name : $9. Score1-Score3 Team ~ $25. Div $; datalines; Smith,12,22,46,"Green Hornets, Atlanta",AAA Mitchel,23,19,25,"High Volts, Portland",AAA Jones,09,17,54,"Vulcans, Las Vegas",AA ; run; input styles;depending on the arragement of data values; 1. column 2. list(simple and modified) 3.formatted 4.named(can not used another input style here) 1.column input:column numbers follow the variale name input name $ 1-8 age 11-12; data clm_ip; input name $ 1-8 age 11-12; datalines; raviraje 27 kingmake 18 ; run; 2.list input;variable names are simple listed "data values are separated by balnk at least one" ex; input name $ age; data lst_ip; input name $ age; datalines; raviraje 27 kingmake 18 ; run; 3.formatted input;apply both format and informat format=sas data to human understand data display =read standard data infomrat=read non standard data ex; input name $char8. +2 income comma6.; data form_ip; input name $char8. +2 income comma6.; /*format income comma6.;*/ datalines; raju 12,000 sati 15,000 ; run; 4.named input;specify the name of the variable followed by an equal sign ex;input name=$ age=; data nm_ip; input name=$ age=; datalines; name=rajesh age=25 name=shalini age=5 ; run; 5.multiple stysle in single input statement;expect named input all of the different input styles ex; input id name $18. team 25-30 startwght endwght; data mul_ip; input id name $5-12 gender $1.; datalines; 123 ravi M 124 raju M 125 shaliniF ; run; pointer controls; column pointer controls; +n @n line pointer controls ; #n / line-hold specifiers; @ @@ ¢ column pointers; data noraml98; input @1 a @3 b$ @5 c; datalines; 1 M 3 2 4 F 3 ; run; ¢ column skip pointer +n; data noraml36; input a +2 b$ +3 c; datalines; 1 M 3 2 F 6 run; data method4; input empid 4. +4 name $ 18. +3 Des $ 10. ; cards; 1001 Kiran kumar Tester 1002 Kranti kumar panda Analyst 1003 pawan kumar saha Programmer 1004 Laxmikant Parida Manager ; run; ¢ column hold pointer @n ¢ column range pointer .n; data noraml; input a 1-3 b $5-10 c 11-16; datalines; 123 raviol 34566 263 rajesh 36985 ; run; 5) absolute input method: column hold pointer @n @4; data method4; input @1 empid 4. @9 name $ 18. @30 Des $ 10. ; cards; 1001 Kiran kumar Tester 1002 Kranti kumar panda Analyst 1003 pawan kumar saha Programmer 1004 Laxmikant Parida Manager ; run; Format Modifiers for Error Reporting: ? : suppresses printing the invalid data note when SAS encounters invalid data values ?? : suppresses printing the messages and the input lines when SAS encounters invalid data values. The automatic variable _ERROR_ is not set to 1 for the invalid observation.
... View more
