Thank you very much to all and especially to Danz,
can I execute the same as below:
Sum(COALESCE (case When JOB_TYPE ='B' then 0 end, case When TASK_IND='Y' then 1 end, case when (sign(90- _ARRIVE_TASK_UPD )) =-1 then 0 end, case when FEEDBACK_IND='N' then 0 else 1 end))
... View more
no, I am not using pass through, i am just trying to conver oracle code into sas.
tried with coalesce and case but it ended with errors...
... View more
sum(
nvl(decode(JOB_TYPE,'B',0,
decode(TASK_IND,'Y',
decode(sign((90-( _ARRIVE_TSK_UPD/60 ))),-1,0,
decode(( Case
when TASK_IND = 'N' or Completion_Code = '00'
then 'N'
else 'Y'
end ),'Y',1,0)),0))
,0)),
thanks in advance.... venkat
... View more
Hi Torres/Jaap, Thank you very much now it is working. The only issue is the placement of title option, which has to bring two different places. Regards, Venkat P
... View more
Hi Jaap, Thank you very much, i suspect the second task is related to the customization. I have configured the customized templated in the startup pages of sas web application. But do the PDF starting with the SAS System is also related to customization? Regards, Venkat P
... View more
Dear Experts, First of all thank you very much in advance for every one for your time. I am generating a ODS PDF report from SAS Stored Process though sas web pertal SAS 9.4, the report is fine but there are two poroblems which i trying to resolve. 1. The pdf of is starting with a title "The SAS System", which i want to supress. 2. When i open the the stored process through web portal i would like to place the company logo in the stored process window. I am not able to find the place to point the GIF file. Both the above mentioned issues are in sas 9.4. Regards, Venkat P
... View more
Hi RW / Jaap, Well the issue is resolved and thanks for you both for quick reply. Sorry Jaap while giving example i hgave incorrect Macroname, but in the process i used corret name. The issue with trim function using for all the macro variables, thanks RW. Regards, Venkat P
... View more
Hi, I am creating a macro for create table in teradata and i woudl like to call that macro for each table. So i have wrote the below mentioned code but i am getting a typical warning and the table is not created as below Code: %let ini= VK; %let fcode=ab123; %let work=wt; %let brand2 = Very; %let SEASON2=AW14; %macro filecheck (DB=, Tablename=, sql_code=, indx=); proc sql; connect to teradata (user=&user. password=&password. mode=teradata); OPTIONS COMPRESS=YES; EXECUTE (ct &tablename. &sql_code. &indx.) by teradata; %mend; %filecheck_create (DB=*****, Tablename=%put(%trim(&ini._&Fcode._brow_&brand2._&season2.)_&work.), sql_code=(aba, abc), indx= primary index (abc)) by teradata; WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. Above code resolving the table name but it is not creating the table and generating the warning. Can some one help what is the solution for the same to define table in the same pattern. Regards, Venkat P
... View more
Hi Jaap, Thank you, we are using SAS 9.1.3 EI desktop version, but we are migrating to SAS 9.4 server version with all BI tools. As 9.4 SMU not support 9.1.3, i am looking for alternatives for my work done. As I have taken the responsibility of migrating, very keen to know all the alternatives and possibilities. Regards, Venkat P
... View more
Hi Jaap, Once again thank you very much, yes i have to migrate SAS EG as well in my migration process. In this scenario can we consider it as promoting to 9.4 from 9.1.3 rather than considering it as migration. Will that workout? Like install Complete installation of SAS 9.4 and design the same structure SAS 9.1.3. Regards, Venkat P
... View more
Hi Jaao, Thank you for your quick reply. Yes I have checked and it has suggested to migrate either to 9.2 or 9.3 as interim process before migrating to 9.4. But that will be an issue if I migrating SAS EBI, what about migrating just SAS Base. Can i Promotions to migrate the catalogs and datasets? Regards, Venkat P
... View more
Can I Migrate SAS content from SAS Enterprise Intelligence Suite for Education version 9.1.3 to 9.4. If I can migrate is there any special requirements need for the same?
... View more
