About DBailey

DBailey · ‎02-18-2014

What were you thinking wouldn't work? The create table like command? I think SAS looks at the oracle table structure and creates a new table with it.

DBailey · ‎02-18-2014

If that is your log, then you aren't running a pass-through query. Looks like you're running a normal statement. To use the pass-through, add "as conn" to your connection. proc sql; create table ods.ods_customer like ora.customer; connect to oracle as conn (path='...' user=XXXXX password=XXXXXX); insert into ods.ods_customer select * from connection to conn ( select * from customer where id in (1,2) ); disconnect from conn; quit;

DBailey · ‎02-18-2014

Are you importing a file using the EG wizard? If so, you can change the type and format of the data in the wizard. If not, then what are you doing that is creating these text formats?

DBailey · ‎02-18-2014

This code produces two oracle statements, but only one is executed. options sastrace=',,,d' sastraceloc=saslog; proc sql; connect to oracle as CDBMR (path='PMIS' ........); create table work.test as select * from connection to cdbmr ( select date_value from mdm.dbdates where date_value= to_date('30Nov2013') ); DISCONNECT FROM CDBMR; quit; Here's the log: 16 proc sql; 17 connect to oracle as CDBMR (path='PMIS' ..........); 18 19 create table work.test as select * from connection to cdbmr ( 20 select date_value from mdm.dbdates 21 where date_value= to_date('30Nov2013') 22 ); ORACLE_4: Prepared: on connection 5 select date_value from mdm.dbdates where date_value= to_date('30Nov2013') ORACLE_5: Executed: on connection 5 SELECT statement ORACLE_4 NOTE: Table WORK.TEST created, with 1 rows and 1 columns. What does your log look like?

DBailey · ‎02-18-2014

proc sql noprint; connect to oracle as ora (valid connection data would go here); INSERT INTO ODS.ODS_CUSTOMER (ID,DESC) select id, desc from connection to ora ( SELECT ID, DESC FROM ActualOracleSchema.CUSTOMER WHERE ID IN (1,2) ); disconnect from ora; quit;

DBailey · ‎02-11-2014

are both of the tables in oracle?

DBailey · ‎02-11-2014

it means that you should talk to your site administrator or SAS support for more details.

DBailey · ‎02-10-2014

unfortunately, the scheduling is site specific. As for the email in a macro... %macro tst(); all of your code... proc sql noprint; select count(*) into :recs from work.final_output; quit; %if &recs ne 0 %then %do; filename mailit email; data _null_; file mailit to=('emailaddress') from=('from email address') sender='Sender' Subject="subject" ; Line1= 'email text line 1'; Line2= 'email text line 2'; Line3 = "Syscc = &syscc"; put Line1; put Line2; put Line3; put ; put ; put "This email address is not monitored for replies."; put ; run; %end;

DBailey · ‎02-10-2014

There are plenty of people here who will help get you started if you post some examples of what you need.

DBailey · ‎02-07-2014

If you right-click on the node and select properties, you should be able to get to the prompt manager.

DBailey · ‎02-06-2014

just apply the format you need...presuming that connect_date is a date and not a datetime.. proc sql; create table z_connect_data as select select account_number, max(connect_date) format=date9. as MaxDate from connect_data group by account_number; quit;

DBailey · ‎02-06-2014

proc sql; create table z_connect_data as select select account_number, max(connect_date) as MaxDate from connect_data group by account_number; quit;

DBailey · ‎02-06-2014

If you define a text prompt (say pComment), I believe you can associate that prompt with the code that generates the report and use it as you would a macro variable. TITLE &pComment; or some such thing.

DBailey · ‎02-06-2014

The process we use requires you to: code a query that identifies the conditions for which you want to send an alert wrap the code in a macro that generates an email if there are records found use SAS Managment Console to schedule the job at whatever interval you need

DBailey · ‎02-06-2014

I think all you would have to do is change the join: proc sql; create table want2 as select t1.*, 1/20*ln(t2.x3/t1.x3) as x4 from want t1 left join want t2 on t1.age=t2.age and t1.year=t2.year-20; quit;

Online Status	Offline
Date Last Visited	‎03-18-2025 04:40 PM

Re: SAS Logs from LSF Scheduled jobs

Re: SAS Logs from LSF Scheduled jobs

Re: SAS Logs from LSF Scheduled jobs

Re: SAS Logs from LSF Scheduled jobs

SAS Logs from LSF Scheduled jobs

Re: proc sql and connect using

Re: proc sql and connect using

Re: proc sql and connect using

Re: proc sql and connect using

Re: proc sql and connect using

Add ability for PROC JSON to parse and read in JSON-formatted data

Re: proc sql and connect using

Re: proc sql and connect using

Re: Why this warning in numeric to charactoer conversion?

Re: Lag equivalent in PROC SQL

Enterprise Guide 8.2 Pane options

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: SAS EG Dates

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: Duplicate SQL running on Oracle

Re: How to Create Alerts on any condition in SAS?

Re: How to Create Alerts on any condition in SAS?

Re: Need help for convert sas script in to SQL script

Re: Accept input from report analyst

Re: Retrieve the most recent date in a dataset

Re: Retrieve the most recent date in a dataset

Re: Accept input from report analyst

Re: How to Create Alerts on any condition in SAS?

Re: How to count divisions of multiple rows etc.

SAS Global Forum 2019

SAS Global Forum 2020