Hi,   When we are running a program from SAS studio, the program is running succussfully with error free (rc=0), but when the same program is running in the unix environment it doesnt return the exit code as zero. Can anyone help on this.   Regards, Siddhartha ... View more

Hi,   I  need to execute the  programs successfully and need to get the return code(rc=0) after the program completes successfully. Can anyone help me, how to get the return code in the Log , whether the program is executed successfully with (retruncode)rc=0 and fails if rc >0.   Thanks & Regards, Siddhartha ... View more

We need to call the sas program from unix shell with the filenames to be passed as parameters. Please help us how can we pass a parameter to sas program from command line as argument and how it has to be handleled inside the SAS program.  The scenario is to call a same sas program in the weekly and monthly job with the different set of files. ... View more

Hi, I have FTP ed a dataset named MR0305 from mainframes to Solaris Server and using in the SAS program. The dataset has been in the Solaris server after FTP has been done. But I was getting the error as: 253 ) 254 ; ERROR: File SID.MR0305A.DATA does not exist. 255 256 *-- NO BLANK TERR06 / TERR07 RECORDS -------------------------------*; I have tried so many but again the same error has been repeatedly coming: ERROR: File SID.MR0305A.DATA does not exist. Any suggestions will help a lot. Thanks & Regards, Sid ... View more

We are migrating SAS programs from Mainframe to Unix. In the mainframe, sas programs we have COMP-3 fields using PD formats. When I was trying to convert the PD formats to Zw.d formats in the unix server, I was getting the error as: I get the Note in my log: NOTE: Invalid data for U_PRC in line 291 648-659. NOTE: Invalid data for NETAMT in line 291 660-671. ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be   Mainframe SAS Program:   FILENAME MR015B '/u175/MR012/D0902.txt'; DATA TEMP_C UPDATE_C; INFILE MR015B ; INPUT @1 HEADER $CHAR551. @495 LINECNT 2. @ ; DO I=1 TO 14 BY 1 UNTIL (I = LINECNT); ZZ = 552 + (142 * (I-1)); INPUT @ZZ TRAIL $CHAR35. @ZZ + 35 RNUM $CHAR9. @ZZ + 44 SHPQTY 6. @ZZ + 50 ORDQTY 6. @ZZ + 56 TRAILB $CHAR40. @ZZ + 96 U_PRC PD5.2 @ZZ + 107 NETAMT PD5.2 @ZZ + 118 TRAILC $CHAR24. @ ; *--- UPDATE ORDER QUANTITY -------------------------------------------*; ORDQTY = ROUND((ORDQTY / 50), 1.0); *--- UPDATE UNIT PRICE -----------------------------------------------*; U_PRC = U_PRC * 50; *--- UPDATE SHIP QUANTITY --------------------------------------------*; SHPQTY = ROUND((SHPQTY / 50), 1.0); OUTPUT TEMP_C; END; run;   I had just changed the PD5.2 to z11.2 for U_PRC & NETAMT column as follows in the above program:   DO I=1 TO 14 BY 1 UNTIL (I = LINECNT); ZZ = 552 + (142 * (I-1)); INPUT @ZZ TRAIL $CHAR35. @ZZ + 35 RNUM $CHAR9. @ZZ + 44 SHPQTY 6. @ZZ + 50 ORDQTY 6. @ZZ + 56 TRAILB $CHAR40. @ZZ + 96 U_PRC 11.2 @ZZ + 107 NETAMT 11.2 @ZZ + 118 TRAILC $CHAR24. @ ; I was getting the error as: Invalid values for U_PRC & NETAMT. NOTE: Invalid data for U_PRC in line 291 648-659. NOTE: Invalid data for NETAMT in line 291 660-671.   Please suggest how to make changes for the respective PD format fields. Thanks & Regards, SId ... View more

Hi, I am having the below program where COMP-3 fields are using PD formats. I was trying to read the file having PD formats, using z8. for PD4. and z13.2 for PD6.2. But getting invalid values when I use Zw.d formats for the PD's. Could anyone suggest which format I need to use.   DATA TEMP_01 ; INFILE MRCUST ; INPUT @1 CUSTNUM $CHAR9. @10 RNUM $CHAR9. @19 RNUMCI $CHAR1. @20 RCC $CHAR14. @22 RCCSC $CHAR2. @22 RCCPT $CHAR5. @34 U_CR PD4. @38 U_MTD PD4. @42 U_QTD PD4. @46 U_YTD PD4. @50 U_L12 PD4. @54 U_LY PD4. @58 R_CR PD6.2 @64 R_MTD PD6.2 @70 R_QTD PD6.2 @76 R_YTD PD6.2 @82 R_L12 PD6.2 @88 R_LY PD6.2 ; Thanks & Regards, Sid ... View more

Hi, I was using a text file from mainframe in one of the program, there are some comp-3 fields. While using this fields with the format starting with PDw.d formats. I am getting the control characters in the output. I am not able to read the format with these characters. Can any one suggest how to read control character in the output. Below is the screnshot. Thanks & Regards, Sid ... View more

Hi, I am having the columns as AS_OF_DT and dw_Load_time as date columns and the format is numeric. I need to take the latest of these date values. AS_OF_DT  DW_LOad_time 19601  19614.462789 19589  19614.462789 19235  19603.345679 19590  19405.213453 19560  19349.298756 19340  18777.132456 19430  18796.654378 I need to refer these in the codes as macro variables. Could any one help me on how to go on this. Regards, Sid ... View more