I have two tables: Table1 and Table2   Data in Table1 can be like: Table_a      Table_b A                  B A                  C C                  E B                   D Data in table2 can be like: Table_name      Status A                          Completed B                           NOTCOMPLETED C                          COMPLETED D                          NOTCOMPLETED E                              OK my output should be like: Table1   status1                Table2     status2                             table3 status3 A            Completed       B             NOTCOMPLETED           D                 NOTCOMPLETED A           Completed         C              COMPLETED                 E                  OK I want to write all relations in one single row ... View more

I have a list of metadata tables registered in SAS Data Integration Studio within a specified library. Is there a method to write SAS code that generates a list including each table's name and the corresponding SAS DI jobs that utilize the table ... View more

I have an Oracle table called Oracle_table. In this Oracle table I have only one column and one row   Column name: Datetime_1 Value: 31/DEC/2801 11:59:59.000000000 PM   I load the data from Oracle into SAS using data steps   Data T; set Schema.Oracle_table;   /* assume implicit pass through*/ run;   Proc print data=T; run;   I got a . (dot) for the column Datetime_1 in SAS   Why?   ... View more

Hi Experts,   I am willing to transfer files from a remote SFTP server to local linux server and my command is below: Is there any problem with my code below as an example?   method1: %let ftpcmd = "sftp -i path of SSHKEY username@sftpserverdetail:/sftppath/file.csv /localpath/file.csv"; filename ftppipe pipe &ftpcmd.; data _null_; infile ftppipe; input; put _infile_; run;       method2: %let ftpcmd = "scp username@sftpserverdetail:/remotesftppath/file.csv /localpath/file.csv"; filename ftppipe pipe &ftpcmd.; data _null_; infile ftppipe; input; put _infile_; run; ... View more

Hi Experts,   Is there any code I can borrow to extract SAS DI metadata objects such as metadata name, metadata location etc?   for example: /myfolder/Job1   I want to extract the metadata path and objects stored under this path?   I understand there is a tool called SAS list Object can be used but I would like to know if anyone has available SAS macro to do this? ... View more

For example I have two log files: A and B A has a b c   B has c b c   So I want to compare the two files line by line and put the difference in another table such as   tablename=Compare_result line_no      records_from_a   records_from_b    1                          a                      c                 ... View more

Hi Experts, Is there any limitation on number of columns used when bulkload into Oracle?   I am loading a SAS table into Oracle using below: proc append base = oracle.table2(&oracle_bload_options BULKLOAD = YES BL_LOAD_METHOD = Truncate ) data =table1 force ; run;   table1 and Oracle.table2 both have 600 columns   I get the below errors: ERROR: ********************************************************************** Please look in the SQL*Loader log file for the load results. SQL*Loader Log File location(available only if BL_DELETE_FILES=NO was set) : -- Note: In a Client/Server environment, the Log File is located on the Server. The log file is also echoed in the Server SAS log file. ********************************************************************** NOTE: Statements not processed because of errors noted above. NOTE: PROCEDURE APPEND used (Total process time): real time 5.61 seconds user cpu time 0.04 seconds system cpu time 0.03 seconds memory 13503.21k   however if I reduce columns from Oracle.table from 600 to 260 then it is working!   Only first few columns have values and all rest columns are empty     Why is this?           ... View more

Hi Experts, I have two tables:  Table1 and Table2   Each table has 1000 columns (column1....column100) and each column has been defined as character with 5000 length Columns in each table are 100% identical in type and length   95% of the columns in each table empty and no value   I would like to compare two tables to see if there is any difference in data. For example: table1 has rows which not existed in table2 or table2 has rows which not existed in table1 such as:   Proc sql; create table diff1 as select * from table1 EXCEPT select * from table2 ; quit; Proc sql; create table diff2 as select * from table2 EXCEPT select * from table1 ; quit;   Proc sql noprint; select sum(Diff_Count) into :TotalChanges from ( (select count(*) as Diff_Count from diff1) union all (select count(*) as Diff_Count from diff2) ) x ; quit; (I want &TotalChanges above) last condition is table1 always has data but table2 sometimes empty   How to program this most efficiently due to large number of columns and length?   ... View more

I am wondering how do you stop DI processing if there is an error within the loop start and loop end.   For example: my DI jobs like below:   table1--->loop start--->job1--->job2--->jobN---->loop end   table1 is used to pass parameters to job1 for processing   however I found even job1 result any error it will not stop the loop which means job2 ...Job3....JobN still gets executed.   my question is how do you stop loop processing immediately if any of the middle jobs failed?  ... View more