紧急求助..谁能帮我把sql中的存储过程转换到sas程序中来,然后用sas程序去实现它们? 非常紧急,希望大家能帮忙,不

shiyiming

紧急求助..谁能帮我把sql中的存储过程转换到sas程序中来,然后用sas程序去实现它们? 非常紧急,希望大家能帮忙,不胜感激,谢谢!!!
1：UPDATE pt_BankFile_process(表1) set OpenBalance=CAST(b.Balance AS MONEY)
FROM pt_BankFile_process(表1) a
INNER JOIN #t2(临时表2) b
ON a.BankID=b.bankId
AND a.AccountNumber=b.AccountNumber
AND a.OpenDate=CONVERT(DATETIME,b.Date_Account_Opened)
WHERE a.OpenBalance!=b.Balance AND a.BankID=9

2：UPDATE pt_BankFile_process(表1)
SET DT = b.dt_times
FROM pt_BankFile_process a
INNER JOIN #t2(临时表2) b
ON a.BankID=9
AND a.AccountNumber=b.AccountNumber
AND a.OpenDate=b.[Date_Account_Opened]

3: delete from pt_BankFileDetail where BankID=9

4:INSERT INTO pt_BankFileDetail (
                BankID ,
                AccountNumber ,
                MyAccountNumber ,
                [Date] ,
                Amount ,
                [Type]
        )
SELECT
                 a.BankID
                ,a.AccountNumber
                ,a.MyAccountNumber
                ,a.opendate
                ,b.TransactionAmount
                ,'T'
FROM pt_BankFile_process a
JOIN [pt_QualificationRequirements] b
ON a.BankID = 9
AND b.BankID = 9
AND a.ProductType = 'Checking'
AND b.ProductType = 'Checking'
JOIN dbo.Tmp_Index c
ON a.DT=c.ix
ORDER BY AccountNumber