Hi Saskiwi, The below code worked for me to extract ADSL from DB for study 6300. Is there any way to extract multiple studies in single time like in("xxxx" "xxxx" "xxxx" ). proc sql; Connect to oledb (init_string = "Provider = SQLOLEDB.1; BULKLOAD = YES; Integrated Security = SSPI; Persist Security Info = True; Initial Catalog = VCDM_ANALYTIC; Data Source = ITSUSRAWSP02788,1433" Schema = BST ); Create table extract.adsl_6300 as select * from connection to oledb ( EXEC bst.usp_ADS_SHOW_DATASET "6300", "ADSL" ); quit; Thank you, Kumar.
... View more