About ramkal21

ramkal21 · ‎12-25-2023

Thanks much @mkeintz . Yes, this is exactly what i needed. It worked!

ramkal21 · ‎12-24-2023

Hi All, I have a scenario to read below Input data Field1 Field2 Field3 Field4 Field2 Field3 Field 4 Field2 Field3 Field4 and so on till 78 times and write it as, Field1 Field2 Field3 Field4 Field1 Field2 Field3 Field4 Field1 FIeld2 Field3 Field4 I tried writing the INPUT statements as below Input Field1 @; Input Field2 Field3 Field4 @@; However, it seems to go in a loop and job ended up failing due to space issue with SAS dataset. The input file has less than 100,000 records and sets of Field2, Field3 Field4 is 78. Output records count should be 78*100,000 = 7,800,000 So am assuming the issue with my code and not with the space issue. Could you please clarify? I am getting below error in the logs ERROR: Insufficient space in file WORK.SASDAT1.DATA. ERROR: File WORK.SASDAT1.DATA is damaged. I/O processing did not complete. NOTE: 1 record was read from the infile INPFIL1. NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. WARNING: The data set WORK.MAD900WFL may be incomplete. When this step was stopped there were 1712581607 observations and 10 variables. Thanks your help! Happy Holidays Ram

ramkal21 · ‎12-01-2023

Thanks @Cynthia_sas. I need to send the report to a Mainframe file and not to a windows / PC. so could you please let me know if there is any option at all within ODS listing to configure the cell width or any other ODS styles that can still be in readable format on Mainfraime side? Thanks for your inputs.

ramkal21 · ‎11-13-2023

Thanks @SASKiwi for the update. I received the response as 'XCMD', so it is enabled in our environment. I will try to use the XCMD and will let you know if i am successful at it.

ramkal21 · ‎11-13-2023

Thank you @Reeza @SASKiwi @Kurt_Bremser for your inputs. Could you please clarify how to verify XCMD is setup during SAS startup? Also, could you please point me to any documentation with examples of using the external commands such as 'X' from @Kurt_Bremser 's post? I am trying to replace one of FOCUS utility programs with SAS and we have below FOCUS call to COBOL program like below. Please note that am trying to run both the SAS and COBOL in z/OS Mainframe environment. INCLUDE <<COBOL Executable>> Please let me know if you need more details. Thanks.

ramkal21 · ‎11-10-2023

Hi All, Could you please let me know if i can call COBOL programs from SAS? any example for doing that? Thanks, Ramanujam

ramkal21 · ‎11-10-2023

Thank you @Cynthia_sas and @ballardw. I was not able to access to silo.tips link due to an internal security issue. Could you please share any examples of ODS HTML that i could refer to, to start with? Actually, i need to use the file / report output from ODS in the Mainframe and send it to a report repository location. Though, i should still be able to view the report clearly on Mainframe as well. I will explore more on this. Thanks!

ramkal21 · ‎11-08-2023

@ballardw to clarify on my response on 'FORMCHAR' change, am getting a new line space between EMPL_SAL row and EMPL_BONUS. My recent query if it is possible to eliminate this?

ramkal21 · ‎11-08-2023

Thank you @ballardw for your inputs. It helped. One thing though below field setting it up as spaces. It ended up adding a new line between the fields values, which i really dont need. Is there a way to remove that extra line or based on my understanding so far, it is not possible? formchar=" " Also, could you please elaborate on what you had meant by below line? "To maintain appearance of Listing output, open a text box using the </> icon above the message window and paste the copied text there." Also, by SAS List i meant the below DD Statement (in Mainframe), the output of PROC TABULATE is automatically sent to below DD statement by SAS. //SASLIST DD DSN=<HLQ>.SASLIST, Thanks again for your inputs! Ramanujam

ramkal21 · ‎11-08-2023

Thanks @PaigeMiller and @Reeza. I was able to get my need satisfied by using $QUOTE format (please see below link)., basically was trying to reduce lines of code. Using $QUOTE format eliminated the need to have a separate line for QUOTE function. https://documentation.sas.com/doc/en/vdmmlcdc/8.1/ds2ref/p180g91lfrpgfnn0zw28u8hwu3mt.htm#:~:text=Writes%20data%20values%20that%20are%20enclosed%20in%20double%20quotation%20marks. var1 = QUOTE(var2); replaced it as put var1 $quote8.; My output is a comma delimited file and using 'Quotes' for characters eliminates the confusion when the file is imported at the receiving end. Hope this clarifies. Thank you both again for leading me to the right solution. Regards, Ramanujam

ramkal21 · ‎11-08-2023

Thanks @PaigeMiller for your quick response. I am trying to mimic output from a vendor product utility (which is being replaced) and that utility automatically identifies fields datatypes based on it's values. Other than QUOTE, could you let me know if there is any other option?

ramkal21 · ‎11-08-2023

Thank you @Cynthia_sas for your response. Could you let me know if ODS will work in z/OS Mainframe? Also, my query on formatting was around PROC TABULATE command if those options are possible? Thanks, Ramanujam

ramkal21 · ‎11-08-2023

Hello all, I was wondering if SAS has a capability to automatically add Quotes or Double quotes to output fields values based on say if the field is of Character or Numeric or Packed decimal value Say if the field is CHAR Name Ivy I am expecting the output in the file as below "Ivy" If the field values are not CHAR then it should not add the double quotes. Thanks, Ramanujam

ramkal21 · ‎11-08-2023

Thanks a lot @ballardw. This worked and exactly what i was looking for. Could you please let me know whether below additional formatting is possible? - option to remove the Tabular borders? - option to make it as a report with 'Page' numbers - make the whole output 'left' indented. i wrote the output to a saslist file and it came up aligned 'center' - also if you could point me to examples to apply styling to ORG-ID - like i would like it to be underlined, that would be helpful. ORG_ID -------- - to remove the 'Sum' column label. would not need it to show up in my scenario -------------- | Sum | +------------| | | | | | 12000.00| +------------| Thank you so much. You have saved a lot of development hours for me already. Regards, Ramanujam

ramkal21 · ‎11-07-2023

Hello all, Input to my SAS program Organization (ORG_ID), Employee ID (EMPL_ID), Employee Salary (EMPL_SAL), Employee Bonus (EMPL_BONUS) ABC, 12345, 5000, 1000 ABC, 78899, 7000, 2000 DEF, 67890, 10000, 3000 DEF, 22993, 8000, 500 NOTE: ORG_ID, EMPL_ID, EMPL_SAL and EMPL_BONUS are SAS variables Output report am desiring is TITLE on top of the report along with PAGE numbers in the report. Followed by Summary of amounts based on each field in the SAS dataset / input file and a final set of TOTALs for each of those fields as well at Organization level ORG_ID -------------- ABC EMPL_SAL 12,000 EMPL_BONUS 3,000 DEF EMPL_SAL 18,000 EMPL_BONUS 3,500 TOTAL EMPL_SAL 30,000 EMPL_BONUS 6,500 With PROC REPORT or PROC Summary i was not sure how i can customize the fields to display like above, i can display them as columns but not as rows. Could you please suggest any examples which i could use to achieve the above outcome? Thanks, Ramanujam

Online Status	Offline
Date Last Visited	‎07-22-2024 05:28 PM

Re: Reading multiple occurrances of the same fields in SAS - using @ a...

Reading multiple occurrances of the same fields in SAS - using @ and @...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Possibility to call COBOL programs from SAS?

Re: Possibility to call COBOL programs from SAS?

Possibility to call COBOL programs from SAS?

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Does SAS have a capability to automatically add Quotes to output v...

Re: Extracting words from a string after a specific character

Re: Reading multiple occurrances of the same fields in SAS - using @ a...

Re: Does SAS have a capability to automatically add Quotes to output v...

Re: Possibility to call COBOL programs from SAS?

Re: Does SAS have a capability to automatically add Quotes to output v...

Re: Possibility to call COBOL programs from SAS?

Re: Reading multiple occurrances of the same fields in SAS - using @ a...

Reading multiple occurrances of the same fields in SAS - using @ and @...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Possibility to call COBOL programs from SAS?

Re: Possibility to call COBOL programs from SAS?

Possibility to call COBOL programs from SAS?

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Re: Does SAS have a capability to automatically add Quotes to output v...

Re: Does SAS have a capability to automatically add Quotes to output v...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Does SAS have a capability to automatically add Quotes to output value...

Re: Help with PROC REPORT to display summarized fields in ROWS vs COLU...

Help with PROC REPORT to display summarized fields in ROWS vs COLUMNS