Hi All,
I am trying to insert rows in SQL Server DB using SAS SQL Pass through facility.
The below code works fine in SQL but I am not sure what I am missing while I am incorporating it in SAS. Could you please tell me the appropriate changes to be made in SAS.
USE [SDMS]
GO
INSERT INTO [sur].[FactSurveyTotal]
([SurveySK]
,[TotalTypeNm]
,[TotalSubTypeNm]
,[DOSTotalCnt]
,[EDWTotalCnt]
,[WithNAPct]
,[WithoutNAPct]
)
VALUES (
(SELECT SurveySK FROM sur.DimSurvey where SurveyYearNum='2020' AND SurveyTypeNm='Physician')
,'Test Type'
, 'Test SubType'
,1
,2
,3
,4
)
With
proc sql;
connect to odbc(dsn="XXXXXX" user=XXXX password="XXXXX" );
(
ABOVE SQL CODE
);
QUIT;
Am I missing anything or should I modify the sql code in any way ?
Thank you,
Prad
... View more