对于如下数据:
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
要把他们读入,我写了一个命令如下,但是最后面的那个金额无法解决逗号表示的问题,请问怎么办呢?
data Employee;
infile 'E:\sas\employee.txt' dlm="," ;
input ID : $3.
Name : $20.
Depart : $8.
DateHire : mmddyy10.
Salary : dollar8.
;
run;
title "List of The File";
proc print data=Employee;
format DateHire mmddyy10.
Salary dollar8.
run;
得到结果如下:
Obs ID Name Depart DateHire Salary
1 123 Harold Wilson Acct 01/15/1989 $78
2 128 Julia Child Food 08/29/1988 $7
3 828 Roger Doger Acct 08/15/1999 $39
4 900 Earl Davenport Food 09/09/1989 $45
5 906 James Swindler Acct 12/21/1978 $78
谢谢各位啊,这个问题想了好久想不出来呀。