120123kimikohotstone 120124luciandaymond

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: Title $ Country $; run; 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Christina,Ngan, ... 120123,Kimiko,Hotstone, ... 120124,Lucian,Daymond, ... 120125,Fong,Hofmeister, ... data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; Implicit OUTPUT; Implicit RETURN; 1 2 Input Buffer 1234567890123456789012345 120102,Tom,Zhou,M,108255, Input Buffer 1 2 1234567890123456789012345 120102,Tom,Zhou,M,108255, PDV Employee First_ _ID Name $8 N8 120102 Tom PDV Last _Name $8 Zhou Gender $8 M Employee First_ _ID Name $8 N8 120102 Tom Job_ Country Title $8 $8 108255 Sales Ma AU Salary N8 ... 33 Gender $8 M Job_ Country Title $8 $8 108255 Sales Ma AU Salary N8 ... 34 Execution Execution Partial sales.csv Output SAS Data Set after First Iteration of DATA Step Work.subset3 Employee First_ _ID Name 120102 Tom Last _Name $8 Zhou Last _Name Zhou Gender M Job_ Country Title 108255 Sales Ma AU Salary 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Christina,Ngan, ... 120123,Kimiko,Hotstone, ... 120124,Lucian,Daymond, ... 120125,Fong,Hofmeister, ... data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Reinitialize PDV Last_Name $ Gender $ Salary Job_Title $ Country $; run; Input Buffer 1 2 1234567890123456789012345 120102,Tom,Zhou,M,108255, PDV Employee _ID N8 . 35 ... 36 First_ Name $8 Last _Name $8 Gender $8 Salary N8 Job_ Title $8 Country $8 . ... 6 Execution Execution Partial sales.csv Partial sales.csv 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Christina,Ngan, ... 120123,Kimiko,Hotstone, ... 120124,Lucian,Daymond, ... 120125,Fong,Hofmeister, ... data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Christina,Ngan, ... 120123,Kimiko,Hotstone, ... 120124,Lucian,Daymond, ... 120125,Fong,Hofmeister, ... Input Buffer Input Buffer 1 2 1234567890123456789012345 120102,Tom,Zhou,M,108255, 1 2 1234567890123456789012345 120103,Wilson,Dawes,M,879 PDV Employee _ID N8 . data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; PDV Last _Name $8 First_ Name $8 Gender $8 Salary N8 Job_ Title $8 Employee _ID N8 . Country $8 . ... 37 Last _Name $8 First_ Name $8 Gender $8 Salary N8 Job_ Title $8 Country $8 . ... 38 Execution Execution Partial sales.csv Partial sales.csv 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Christina,Ngan, ... 120123,Kimiko,Hotstone, ... 120124,Lucian,Daymond, ... 120125,Fong,Hofmeister, ... data work.subset3; infile 'sales.csv' dlm=','; input Employee_ID First_Name $ Last_Name $ Gender $ Salary Job_Title $ Country $; run; 120102,Tom,Zhou, ... 120103,Wilson,Dawes, ... 120121,Irenie,Elvish, ... 120122,Chris...
View Full Document

This document was uploaded on 02/25/2014 for the course STAT 410 at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online