* here is my input data ;
123,"Harold Wilson",Acct,01/15/1989,$78,123. 128,"Julia Child",Food,08/29/1988,$89,123 007,"James Bond",Security,02/01/2000,$82,100 828,"Roger Doger",Acct,08/15/1999,$39,100 900,"Earl Davenport",Food,09/09/1989,$45,399 906,"James Swindler",Acct,12/21/1978,$78,200
* here is my output;
Obs
id
name
dept
HireDate
Salary
1
123
Harold Wilson
Acct
01/15/1989
$78
2
128
Julia Child
Food
08/29/1988
$89
3
7
James Bond
Security
02/01/2000
$82
4
828
Roger Doger
Acct
08/15/1999
$39
5
900
Earl Davenport
Food
09/09/1989
$45
6
906
James Swindler
Acct
12/21/1978
$78
as you can see, i am not able to get full salary value.
any idea what am i doing wrong here ?
here is my code....
data Employee; infile'/folders/myfolders/Learning/employee.csv' dsd dlm=',' ; input id : 3. name : $20. dept : $10. HireDate : mmddyy10. Salary : dollar10.; format HireDate mmddyy10. Salary dollar10.; run; proc print data=employee; run;
... View more