About DavidCaliman

DavidCaliman · ‎03-25-2015

I can not use Stored Process in this Information Map.

DavidCaliman · ‎03-25-2015

I have a date prompt in the Information Map Studio. I need to use the value selected in a prompt on the calculation within a data item. I tried to use "&p_date"d and did not work. Could anyone help me?

DavidCaliman · ‎01-09-2015

How can I see all scheduled reports from all users on the Web Report Studio via In-Process Scheduling Server? How can I see which are running now, for example? Where are generated logs of these runs?

DavidCaliman · ‎01-07-2015

I used the following and it works: proc copy in=lib1 out=lib2 CONSTRAINT=YES INDEX=YES; select y; run;

DavidCaliman · ‎01-06-2015

When i use the command below, a new table is generated, however the sas index file is not generated. proc sql; create table x (compress=char) as select * from y; ** y has a index file Is there some command to create a table from another, generating the index file? I have some tables that are becoming very large because of deletes operations. SAS has not command to rebuild a table, so I need to do this recreation once a week automatically, and should not fail if you create a new field in the table, for example.

DavidCaliman · ‎12-05-2014

I need any special license to run the SAS to the options below? -cpucount 4 -threads I need to increase the processing power in the SAS. When two jobs perform the same time, the performance is very low. I added the following command line in the Job and the log did not show anything related to threads. THREADS=YES CPUCOUNT=4

DavidCaliman · ‎12-01-2014

What command can I use to create a column in a SAS table and initialize it to default value 'N' ? Example: proc sql; alter table LIB1.TABLE1 ADD FLAG char(1) format = $1. DEFAULT 'N' ;

DavidCaliman · ‎11-14-2014

Hi!! I have two tables: table1 - 10,000,000 rows Key: cd1, cd2, cd3, cd4 table2 - 30,000 rows Key: cd1, cd2 And I want to run the sql below: proc sql; delete from table1 a where exists (select 1 from table2 b where a.cd1=b.cd1 and a.cd2=b.cd2) ; This sql took more than three hours and did not finish. table1 and table2 are SAS tables. Does anyone have any tips on how to optimize this SQL?

DavidCaliman · ‎07-07-2014

There is the possibility of visualizing the queries behind the reports executed in Web Report Studio?

DavidCaliman · ‎06-26-2014

I can send email via the Job status handling. If an error occurs in the job, I need to pass the job name in the message of the email. How to do it within the handling status of a job? Searching on google, I see that there is a variable called ETLS_JOBNAME. And in the code generated by the DI, the following command sends the message of the email: data _null_; file sendMail; dttm = put(datetime(),nldatm.); put dttm "&message."; run;

DavidCaliman · ‎06-05-2014

I used this solution: http://www.wuss.org/proceedings12/55.pdf Thank you all for your help.

DavidCaliman · ‎06-04-2014

To do it with user-coding transformation, does anyone have an example of how to do? The logic is as follows: c= count(files(/project/customer*)) if c=0 then abort(job); end

DavidCaliman · ‎06-04-2014

How do I abort a job in data integration studio using the following rule: - Check if exists a file on the sas server starting with /project/customer* - Failing that, I need to abort the process Tks

DavidCaliman · ‎05-29-2014

Jaap Karman,thanks for your reply. how I set the item below? is there any manual that I can read about it? "you can change that to readonly (access-readonly) allowing many processes for read. (Blocking a possible update process)"

DavidCaliman · ‎05-28-2014

The opposite occurs: The table is being locked while I am running the report, not when I'm doing the load. The table involved is a SAS table.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Using a prompt value in a Data Item - IMS

Using a prompt value in a Data Item - IMS

Report Scheduling with In-Process Scheduling

Re: CREATE TABLE AS SELECT

CREATE TABLE AS SELECT

DI THREADS and CPUCOUNT

Add SAS Table Column with Default Value

Proc SQL Delete Very Slow

Web Report Studio - Queries

How to pass the job name via email in DI?