About jdmarshg

jdmarshg · ‎09-22-2015

Hello everyone I'm using SAS DI Studio. User written code captures counts form a SQL Server database while looping through files. During the first loop for some reason I'm getting a count of 0 after data is loaded to a table. It seems as if the count is capturing the state of the table before it is completed. Is there a way to pause between before running a proc sql statement? SAS is installed on Linux. Any insight would be greatly appreciated as this is very frustrating as to why when I run the SAS base code within the code editor i get the proper count back but the package for some reason returns 0. Regards, Jonathan Jon

jdmarshg · ‎06-01-2015

OOOOH Yes.... It tried the approach Linus placed forth.. In so many searches why have I not found this link... 13485 - How to pass a macro variable into the WHERE clause to query an Oracletable with PROC SQL Pass-Through I just got it to work.... I'm coming from the SSIS world so of course SSIS to SQL Server is merely built in but this case just opens soo many doors with integration with SQL Server. I'm now going to try user24feb approach This made my day .... many thanks %let dataset_name = Jonathan; proc sql; connect to SQLSVR as SQLDB (datasrc="DEV04Kerberos"); select * from connection to SQLDB (EXECUTE Jonathan.dbo.InsertNewSchema @SchemaName = %unquote(%str(%'&dataset_name%'))); disconnect from SQLDB; quit; Regards, Jonathan

jdmarshg · ‎05-31-2015

I have used this code to call a job within sql server with a hard coded value for the parameter job_name. I'm looking to take a macro variable and pass it into the sql server stored procedure. How would I go about doing that? proc sql; connect to SQLSVR as SQLDB (datasrc="&datasrc"); select * from connection to SQLDB /*( EXECUTE msdb.dbo.sp_start_job @job_id = 'E9B5D67A-0695-49F1-8CE2-388671ECB4B6');*/ ( EXECUTE msdb.dbo.sp_start_job @job_name = 'job_name'); disconnect from SQLDB; quit; Regards, Jonathan

jdmarshg · ‎05-29-2015

Good morning everyone, I have learned how to call a stored procedure in stored procedure. I have still yet to be able to using SQL Pass Thru if the correct approach to pass a macro variable into a stored procedure residing in SQL Server. Will post more code shortly as I continue to research and try different methods. Regards, Jonathan Marshall

jdmarshg · ‎12-15-2014

Hi Mike has there been an update for this issue. Regards, Jonathan

jdmarshg · ‎12-15-2014

I would like SAS just to ignore these errors and continue on if I could for a quick work around until another solution is found. Any suggestions ?? How do I go about the SAS System to continue processing? The SAS System stopped processing this step because of errors.

jdmarshg · ‎12-15-2014

Has there been a resolution for this? Regards, Jonathan

jdmarshg · ‎12-15-2014

Thank you for all the options for a solution. It seems from this other thread I found that SAS DIS that the %macro etls_recordCheck; which is automatically generating these counts. Here is the other thread. I am continuing to research this issue and figure out a work around. Regards, Jonathan

jdmarshg · ‎12-13-2014

Good evening, I'm receiving the following error and wanted to know how I would handle in SAS. For SQL Server I would have to use SELECT COUNT_BIG(*) is there an equivalent? select count(*) into :sourcecnt from LipSDD00.Fundamental; CLI open cursor error: [SAS/ACCESS to SQL Server][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Arithmetic overflow error converting expression to data type int. Regards, Jonathan

jdmarshg · ‎10-17-2014

That worked thank you. Jonathan

jdmarshg · ‎10-17-2014

Hello everyone I'm having issues with the file-reader not reading in a value like such. 1999-12-31 00:00:00 Here is what I have tried thus far. DATETIME19. DATETIME20. DATETIME22.3 Any suggestions would be greatly appreciated on how to resolve. I have tried the following encoding. WLATIN1 & UTF-8

jdmarshg · ‎09-04-2014

How would I go about passing macro variables into the stored procedure? Can anyone point me in the right direction?

jdmarshg · ‎03-20-2014

Reez, Thank you that is perfect.

jdmarshg · ‎03-20-2014

Is there a way within SAS DI Studio Code Editor to get macro variables to show up in a different color in the log output. When using symbolgen mprint etc... I would like for certain output from the %put as well to be color coded in someway to assist in debugging / development. Jonathan

jdmarshg · ‎01-23-2014

Thank you guys for your input this has been very helpful. Much appreciated. Jonathan

Online Status	Offline
Date Last Visited	‎01-17-2016 11:16 PM

Re: Change Default Bluish background ODS Reporting Proc Report

Change Default Bluish background ODS Reporting Proc Report

Re: Excel

Excel

Re: Conditional E-mail Report

Conditional E-mail Report

E-mail to Distribution List

Re: ODS HTML Report Outlook

ODS HTML Report Outlook

Re: Skip last row in data file SAS DI Studio

Re: Change Default Bluish background ODS Reporting Proc Report

Re: Excel

Re: Conditional E-mail Report

Re: ODS HTML Report Outlook

Re: Arithmetic overflow error converting expression to data type int. ...

Capturing Counts from destination SQL Server Database

Re: Data Integration Studio (Pass sas macro variable into SQL Server S...

Re: Data Integration Studio (Pass sas macro variable into SQL Server S...

Data Integration Studio (Pass sas macro variable into SQL Server Store...

Re: D.I. Studio - etls_recordCheck macro issues

Re: Arithmetic overflow error converting expression to data type int. ...

Re: D.I. Studio - etls_recordCheck macro issues

Re: Arithmetic overflow error converting expression to data type int. ...

Arithmetic overflow error converting expression to data type int. (Tra...

Re: SAS DI Informat for DateTime

SAS DI Informat for DateTime

Re: calling stored procedure in SAS DI

Re: Highlight Color Coding

Highlight Color Coding

Re: Code Generation Mode SAS DI Studio