p***7 发帖数: 535 | 1 Data facilit;
Infile "/analytics/ft.txt" DLM='|' dsd truncover lrecl=4096;
Input fac_id hosp_name $ long_name $ address1 open_date closed_date ;
run;
Data is below
fac_id | hosp_name|long_name |address1 |open_date |
closed_date
112060360 | mcennter |nald Center| 7989 Linda Vista Rd|10/01/2011|11/01/
2015
Whenever it reads the open_data and closed_date, it says not correct format
for them.
tried informat mmddyy10, but still doesn't work.
Help please!
Thanks | k****3 发帖数: 1251 | 2 is it this row data?
if it is
TRY open_date :MMDDYY. closed_date :MMDDYY.; | t****g 发帖数: 120 | 3 Are you missing "$" after "address1" for the "input" statement?
Input fac_id hosp_name $ long_name $ address1 open_date closed_date ; | s*****o 发帖数: 787 | |
|