Iiau02aug194401011974 120122christinanganf27475sales

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: an,F,27475,Sales Rep. II,AU,27JUL1954,07/01/1978 120123,Kimiko,Hotstone,F,26190,Sales Rep. I,AU,28SEP1964,10/01/1985 120124,Lucian,Daymond,M,26480,Sales Rep. I,AU,13MAY1959,03/01/1979 120125,Fong,Hofmeister,M,32040,Sales Rep. IV,AU,06DEC1954,03/01/1979 120126,Satyakam,Denny,M,26780,Sales Rep. II,AU,20SEP1988,08/01/2006 120127,Sharryn,Clarkson,F,28100,Sales Rep. II,AU,04JAN1979,11/01/1998 data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; ***** $ means character variable 17 18 p107d01 3 Business Scenario 281 282 283 284 285 Business Scenario data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; proc print data=work.subset3; run; Partial PROC PRINT Output NOTE: The infile 'sales.csv' is: Name=S:\Workshop\ File Name=S:\Workshop\sales.csv, RECFM=V,LRECL=256 NOTE: 165 The The NOTE: The Obs records were read from the infile 'sales.csv'. minimum record length was 61. maximum record length was 80. data set WORK.SUBSET3 has 165 observations and 7 variables. 19 1 2 3 4 5 6 7 8 9 10 11 12 Employee_ ID 120102 120103 120121 120122 120123 120124 120125 120126 120127 120128 120129 120130 First_ Name Last_ Name Tom Wilson Irenie Christin Kimiko Lucian Fong Satyakam Sharryn Monica Alvin Kevin Zhou Dawes Elvish Ngan Hotstone Daymond Hofmeist Denny Clarkson Kletschk Roebuck Lyon Gender Salary M M F F F M M M F F M M 108255 87975 26600 27475 26190 26480 32040 26780 28100 30890 30070 26955 Job_ Title Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Country Ma Ma Re Re Re Re Re Re Re Re Re Re AU AU AU AU AU AU AU AU AU AU AU AU p107d01 20 DATA Step Processing Compilation The DATA step is processed in two phases: compilation execution During the compilation phase, SAS checks the syntax of the DATA step statements creates an input buffer to hold the current raw data file record that is being processed creates a program data vector (PDV) to hold the current SAS observation creates the descriptor portion of the output data set. Compile Program Initialize Variables to Missing (PDV) Execute Read Statement Execute Other Statements End of File? Yes No Next Step Output to SAS Data Set 21 22 Compilation Compilation data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; Input Buffer 1 2 1234567890123456789012345 23 ... 24 ... 4 Compilation Compilation data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; Inp...
View Full Document

Ask a homework question - tutors are online