Hi , I`m trying to create an Excel based report which has List reports on Sheet 1 followed by 6 graphs on subsequent sheet.Sheet 1 feeds the graph. Tried the following methods : SAS DDE:  Since the destination file is in UNIX this method did  not work SAS EXCEL XP: It does not support GPLOT for line graph Has anyone tried automation of  such a report.Kindly suggest alternative ... View more

Hi , I need to run a job automatically for 10 years in DI studio with out any manual intervention. Following vars will be used as parameters to be passed 1)  &YEAR_BEG_DAY  2) &YEAR_END_DAY derived from below. DATA _NULL_; CALL SYMPUT("YEAR_BEG_DAY",put(INTNX("YEAR",Today(),-1,'B'),DATE9.));/*FIRST DAY OF THE YEAR*/ CALL SYMPUT("YEAR_END_DAY",put(INTNX("YEAR",Today(),-1,'E'),DATE9.));/*LAST DAY OF THE YEAR*/ RUN; I need to know how this could be done in DI studio.  I`ve 2 jobs actually. Job 1 will fetch 1 year data truncate and load  Table 1  and  Job 2 will do some transformations and Load another FINAL table  (Append) Again this has to be repeated for another 9 years. Can we actually do it in a single go and should this be better manually. ... View more

Hi, I`m looking for an equivalent of the below code in Data step HASH join. proc sql; create table rllp2 as select distinct a.*, b.enam as name,b.position,b.orid,b.ccid_1 as ccid,b.region1 as region max(a.BEGD,b.BEGD) as BEGD,min(a.ENDD,b.ENDD) as ENDD from rllp3 as a left join rllp1 as b on a.position_id_k = b.position_id_1 and ((a.BEGD BETWEEN b.BEGD and  b.ENDD) or (a.ENDD BETWEEN b.BEGD and  b.ENDD) or (a.BEGD >= b.BEGD and a.ENDD <= b.ENDD) or (a.BEGD <= b.BEGD and a.ENDD >= b.ENDD)) order by position,BEGD,ENDD; Not sure how to add the distinct ,extra join conditions and order by in a single datas tep. DATA MI ; IF 0 THEN SET rllp1;       DECLARE hash VS(hashexp:10, dataset:"rllp1");             VS.definekey('position_id_k,'position_id_1');             VS.definedata(all:'Y');             VS.definedone();                   DO UNTIL(eof);                         SET rllp3end=eof;                   IF VS.find()=0 THEN OUTPUT;                         ELSE DO;                   CALL missing( a1---b1);                   OUTPUT;             END;       END; STOP ; RUN; Kindly suggest some methods ... View more

Hi We are planning to migrate to 9.2 .Also changing env from windows to unix. Please could some expert advise on plan to proceed. Should we first promote then migrate or vice vesra. Also it would be great if a checklist could be provided on the critical components to be taken care of. Warm Regards ... View more

Hi While trying to exceute the following command I`m getting the error below FILENAME SALES PIPE "ls -tr /data/sharedall/cofeeds/comit/weekfeeds|tail -1"; ERROR: Insufficient authorization to access PIPE. ERROR: Error in the FILENAME statement. Bascially i`m trying to retrieve the file name of the last updated file in a folder from EG itself. The code runs fine when I run SAS in command propmt(UNIX). Also it has failed in the scheduler LSF Would be great if some experts  advice , if this error can be rectified or any other alternatives exist. ... View more

Hi, I`m looking for details regarding the SAS ROAMBI Mobile Integration. Especially capabilities  like if ROAMBI would be able to directly access datasets ,generate reports from OLAP Cubes etc. Help would be greatly appreciated. ... View more

Hi I need help to create a hash join equivalent to using two left joins , on total 3 tables like Proc sql; create table test as select * from Table1 as A  left join Table2 as B on (A.id=B.id)    left join Table3 as  on (A.key=C.Key) ; quit; For one table the following would work assuming Table  T1 >  Table T2 data SET1;      if 0 then set Table2 ; declare hash VS(hashexp:7, dataset:Table2 ); VS.definekey('KEY''); VS.definedata(all:'Y'); VS.definedone(); do until(eof); set Table1 end=eof;      if VS.find()=0 then output; else do; call missing(of T1-T2); output; end; end; stop; run; ... View more