cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
adleach2
‎08-15-2022
  • 11 Posts
  • 0 Likes Given
  • 1 Solutions
  • 1 Likes Received

Re: How to Get PROC ODS TEXT on a new Tab in ODS EXCEL output

by Fluorite | Level 6 in ODS and Base Reporting
‎04-30-2020 01:49 PM
1 Like
‎04-30-2020 01:49 PM
1 Like
However,  it the SHEET_INTERVAL="PROC" does put the PROC ODS TEXT on a new page.    Thanks @Reeza for pointing me in the right direction.  ... View more

Re: How to Get PROC ODS TEXT on a new Tab in ODS EXCEL output

by Fluorite | Level 6 in ODS and Base Reporting
‎04-30-2020 01:46 PM
‎04-30-2020 01:46 PM
Unfortunately it looks like I don't have the SHEET_INTERVAL="NOW" options available to me.   ERROR: Argument now for word option sheet_interval not recognized. Expecting one of these keywords output, table, page, bygroup, bygroups, proc, none or none.   We are on SAS  9.04.01M3P062415  ... View more

Re: How to Get PROC ODS TEXT on a new Tab in ODS EXCEL output

by Fluorite | Level 6 in ODS and Base Reporting
‎04-30-2020 01:44 PM
‎04-30-2020 01:44 PM
@Reeza Here is My codes as requested data work_path; work_path = pathname ( "WORK" ) ; call symput ( "work_path", trim(work_path) ) ; run; ods excel file="&work_path./test.xlsx"; ods excel options(sheet_name="Output 1" sheet_interval="output"); proc print data=sashelp.class; run; ods excel options(sheet_name="TEXT" sheet_interval="output"); proc odstext ; p 'NEED THIS ON A NEW TAB'; run; ods excel options(sheet_name="Output 2" sheet_interval="output"); proc tabulate data=sashelp.class; class age sex; table age, sex; run; ods EXCEL close; ... View more

How to Get PROC ODS TEXT on a new Tab in ODS EXCEL output

by Fluorite | Level 6 in ODS and Base Reporting
‎04-30-2020 12:46 PM
‎04-30-2020 12:46 PM
Hi,      I am using SAS ODS EXCEL to create a multi tab excel spreadsheet.   I would like to have tabs with output and then some tabs with text.    I was going to use PROC ODSTEXT for the text,        However, I can't the PROC ODS TEXT output to appear on its own tab.       I have attached my code as well as the excel output.        Any suggestions on how to achieve this?    Thanks, Alan   ... View more

Re: How to Mask a * in a macro call ?

by Fluorite | Level 6 in SAS Programming
‎02-13-2020 01:37 PM
‎02-13-2020 01:37 PM
@Tom  Thanks for clarifying the issue.   This solutions works.  ... View more

Re: How to Mask a * in a macro call ?

by Fluorite | Level 6 in SAS Programming
‎02-13-2020 01:37 PM
‎02-13-2020 01:37 PM
@Reeza  Thank you    ... View more

Re: How to Mask a * in a macro call ?

by Fluorite | Level 6 in SAS Programming
‎02-13-2020 01:36 PM
‎02-13-2020 01:36 PM
@Krueger   Thanks that will work as well.  ... View more

How to Mask a * in a macro call ?

by Fluorite | Level 6 in SAS Programming
‎02-13-2020 12:18 PM
‎02-13-2020 12:18 PM
Dear Community ,       I am working on a macro to do some OS commands for me.    I want to pass parameters to the macro that contain the character *.           However,  my code doesn't work  because SAS is recognizing * as the comment to end of line .          For example,  my macro call looks like        %_53_os_cmd ( oscmd = cp /home/e931413/from/*.* /home/e931413/to/.    ) ;       Of course the * in the first parameter causes SAS to ignore everything after that.   Is there is a way I can pass the * to the macro?   Thanks!  ... View more

Re: Location of code or definition for %fcf_get_runasofdate macro ?

by Fluorite | Level 6 in Fraud, AML and Security Intelligence
‎02-07-2020 08:15 AM
‎02-07-2020 08:15 AM
@SASKiwi  @ballardw  Thanks for the replies.   When I add those options and run the macro I get nothing back in the log   options mprint symbolgen source mlogic ; %fcf_get_runasofdate ; NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds   The macros definitely are compiled. See below.  Hopefully someone as SAS Saved the code before they compiled it.   proc catalog ; 27 contents cat= ECMCMAC.sasmacr out=temp; 28 run; NOTE: The data set WORK.TEMP has 1 observations and 9 variables. 29 30 31 filename outfl "/home/e931413/ECMCMAC"; NOTE: The macro %FCF_GET_RUNASOFDATE was compiled with the /SECURE option. No output will be produced for this %COPY statement. ERROR: The /SOURCE option was not specified when the macro FCF_GET_RUNASOFDATE was compiled. ERROR: An error occurred during the execution of the %COPY statement. 32 33 %copy FCF_GET_RUNASOFDATE / OUTFILE=outfl source; ... View more

Re: Location of code or definition for %fcf_get_runasofdate macro ?

by Fluorite | Level 6 in Fraud, AML and Security Intelligence
‎02-06-2020 03:01 PM
‎02-06-2020 03:01 PM
So I found the macro code.   The macros where compiled and stored in a SAS CATALOG  called sasmacr located in the   /opt/sas/sashome/SASFoundation/9.4/cmacros/antimnycmn directory at our install.   Unfortunately, when the macros where compiled and put the catalog they were compiled with the SECURE option which means I cannot retrieve the source code.   Does anyone know how to get the code?   ... View more

Location of code or definition for %fcf_get_runasofdate macro ?

by Fluorite | Level 6 in Fraud, AML and Security Intelligence
‎02-06-2020 01:15 PM
‎02-06-2020 01:15 PM
Hi,        I am new to SAS AML.   I am trying to understand what the %fcf_get_runasofdate macro is doing so I would like to see the source cod or definition.     However, I can't find any fcf_get_runasofdate.sas in any of the sas autocall paths.         Can any one tell me where this macro is defined?    Thanks, Alan   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-15-2022 02:58 PM
Likes from
View All
Quick links