when i trying to connect to sql server through PC SAS , getting the below error.
"ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
ERROR: Connection to the odbc DBMS does not exist.
This is the sample code for this error:
proc sql;
connect to odbc (dsn=rfdev user=Import pwd=***** );
create table industry.compid2sic_&asofdate
as select * from connection to odbc(
select distinct b.compid as borrower_id, b.wgt , c.[SIC CODE] as sic_code , c.[Industry Code Cross Reference] as Industry_c
FROM DBO.HBUS_SA_CUBE_&asofdate AS A
LEFT JOIN [REPORTING].DBO.NA_V_IndWgt_t() AS B ON A.Borrower_Id = B.[COMPID]
LEFT JOIN DBO.TEMP_SICIndMapForBoard AS C ON B.UNDY = C.[SIC CODE]
where a.report_mlob <> 'Retail'
);
disconnect from odbc;
quit;
