What error is it giving you?

I don't know anything about SAS, so I can't say anything about the general formating but I have used ODBC and OLEDB some. The one thing I see that looks wrong in what you have below is that properties are set as one string normally, that is 'data source=Desktop/foo.udl' rather then 'data source'='Desktop/foo.udl'.

Jay