About venkatesh

venkatesh · ‎09-30-2011

Hi Experts, I am working on DI studio. I am planning to reduse a job running time from 1 hour to 45 minutes. could you please expalin me the process or please provide me the document for the same. Here my question is: Is there any performance tunning techniques. if yes Please provide any document on the same.? How to reduse job running time from 60 mins to 45 mins as a generic(already created indexes). Regards, Venkatesh.

venkatesh · ‎02-07-2010

proc sql; select *from dataset name where date ge '01012009'd ; quit;

venkatesh · ‎02-03-2010

Try this xxx=compress(mt||'DAYS'||' '||PP||U); Cheers, Venky.

venkatesh · ‎12-01-2009

Hi, what is meant by sas/access and sas/connect what is the differenece between the both. If u people think this is a silly question but for me its too difficult

venkatesh · ‎10-27-2009

Hi., Am unable to export the data from sas to excel(morethan 65,000 records). As i exported in to csv then also am able to view only 65,000 only. Please suggest on this. Thanks, Venkatesh

venkatesh · ‎04-29-2009

Hello Kevrow, If u want see the stored process(sp) program code which is created in DI studio. While creating sp in di studio, u will get stored process name with icon----right click-->properties--> execution here u will find the path(location of the stored process) it will be saved in the form of xxx.sas u can open these with note pad or eg or sas 9.1.3. Cheers, Venky.

venkatesh · ‎04-15-2009

Hello Cg, See the example. data test; input sex$ age; cards; m 25 f 60 f 56 m 65 u 52 ; proc format; value $sexes m = 'male' f = 'female' u = 'unknown' ; proc print; format sex $sexes.; run; or u can do as per daniel suggestion.

venkatesh · ‎04-13-2009

Hello Daniel, Am using DIS version 3.4 Dont know what i have to do to resolve this issue. There is no problem with lock issue because after completing first job then only am using for second. Help would be a great

venkatesh · ‎04-10-2009

Hi Team, Here i have a source file called A(CSV external file). Created Job(abcd) and loaded my target table successfully based on external file as source. and created one more job(abcd1) and used as same external file as a source run the job and job successfully run and loaded data into target table. now the problem is if i open first job (abcd) the source file is missing. Here my doubt is source file can't use more than a job. or Is there any problem with installation. or Is there any other problem. How can i achieve this problem if i run both jobs and source file has to be available in both jobs.

venkatesh · ‎04-08-2009

Haiyan In management console add user account in to defaultact as per your requirements and assign permissions to the account. if u assigned all permissions to the account, this user will work as admin, if not this user under control of sasadm account. Venky.

venkatesh · ‎04-03-2009

Sorry, I dont have any idea on this issue... Venky.

venkatesh · ‎04-03-2009

Haiyan, I think Problem with authentication, did u tried through admin credentials. still not working then hot fix link here and raise a track with tech support.. http://support.sas.com/kb/14/091.html http://support.sas.com/kb/34/792.html Venky.

venkatesh · ‎04-01-2009

Clarification about the SCD (Slowly changing dimension) and Look up Di studio will support all the three SCD types or only SCD type two transformation. and In a Job how many look up transformations can be used. is there any limit for the job. Venky.

venkatesh · ‎03-27-2009

Hi SaiRam, If u know the number of Observations(firstobs or obs). Try this., data test; infile cards firstobs=3; input a; cards; 76 56 98 ; proc print; run; Venky.

venkatesh · ‎03-27-2009

If u cant identify then try this.. Tools->Options->log->general->reset all default options will be reset(Don't know how much it will help) Venky.....

Online Status	Offline
Date Last Visited	‎04-19-2023 08:58 AM

How to reduce job running time from 1 hour to 45 mins(Performance tunn...

Re: checking dates in sql

Re: concatenate

SAS Access and Connect

Export data into excel

Re: View code of stored procedures

Re: label name display in output

Re: Missing Source file in a job DI studio(9.1.3)

Missing Source file in a job DI studio(9.1.3)

Re: failed running stored process from web report studio

How to reduce job running time from 1 hour to 45 mins(Performance tunn...

Re: checking dates in sql

Re: concatenate

SAS Access and Connect

Export data into excel

Re: View code of stored procedures

Re: label name display in output

Re: Missing Source file in a job DI studio(9.1.3)

Missing Source file in a job DI studio(9.1.3)

Re: failed running stored process from web report studio

Re: Cannot save PROC OLAP Code using SAS OLAP Cube Studio ver 9.1

Re: failed running stored process from web report studio

DI studio which type of scd will support

Re: getting last observation from a dataset

Re: No log listing from Proc Import