Raw Data and DATA Steps |
proc sql; create table proclib.paylist2 (IdNum char(4), Gender char(1), Jobcode char(3), Salary num, Birth num informat=date7. format=date7., Hired num informat=date7. format=date7.); insert into proclib.paylist2 values('1919','M','TA2',34376,'12SEP66'd,'04JUN87'd) values('1653','F','ME2',31896,'15OCT64'd,'09AUG92'd) values('1350','F','FA3',36886,'31AUG55'd,'29JUL91'd) values('1401','M','TA3',38822,'13DEC55'd,'17NOV93'd) values('1499','M','ME1',23025,'26APR74'd,'07JUN92'd); title 'PROCLIB.PAYLIST2 Table'; select * from proclib.paylist2;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.