Ninan Tracker

Re: macro CALL EXECUTE- ERROR: More positional parameters found than defined

Ninan — Thu, 13 May 2021 19:19:52 GMT

Responses below from Astounding and Kurt are solutions
Response from Tom about using nested functions be considered as extension of what we have discussed here,

now this thread has many use-cases to explore for SAS MACRO learner!!
Thanks everyone for all your replies.

Re: macro CALL EXECUTE- ERROR: More positional parameters found than defined

Ninan — Thu, 13 May 2021 13:55:12 GMT

Thank you for your response, this is an alternate solution to avoid the complexities of concatenating different parameter while calling the macro.

Re: macro CALL EXECUTE- ERROR: More positional parameters found than defined

Ninan — Thu, 13 May 2021 12:49:48 GMT

I have tried %NRSTR in multiple combinations before but it was throwing different errors, may be because of unbalanced quotes, commas, and brackets

But rethinking with fresh mind it is working now -😊

call execute('%get_dbdata(%NRSTR(' || strip(mbr_list) || '))' );;

Thank you Kurt

macro CALL EXECUTE- ERROR: More positional parameters found than defined

Ninan — Thu, 13 May 2021 05:44:32 GMT

I wanted to iteratively pass list of variables in quotes separated by commas to a SQL WHERE “IN” clause

WHERE IDS in ('a111','a222','a333');

Please check below working piece of SAS macro code, first approach invokes macro directly using %, it is working as expected.

In the second approach; macro invocation using CALL EXECUTE, I am not able to pass multiple parameters without wrapping up in quotes

Else it will throw ERROR: More positional parameters found than defined

But as workaround I am able to remove the additional quote using a dequote inside the macro.

Can you suggest modification to CALL EXECUTE statement so that macro variable mbrlist receive values as 'a111','a222','a333' and not “'a111','a222','a333'”,

so that dequote statement is not needed, ie wrapping CALL executive parms or just macro parm with %NRSTR, %NRBQUOTE etc functions?


%macro get_dbdata(mbrlist)  ;
    %put &=mbrlist;
    %let mbrlist_DQ=%sysfunc(dequote(&mbrlist.));
    %put &=mbrlist_DQ;
%MEND;



/* 1. Call macro direct */

%let mbrlst='a111','a222','a333';
%put &=mbrlst;
%get_dbdata(%nrstr(&mbrlst));


/* 2. Call macro using Call execute */

data qq;
    /*   set indata; */


    mbr_list="'b111','b222','b333'";
    put mbr_list=;
    call execute('%get_dbdata("' || strip(mbr_list) || '")'  );;

run;

Re: Export Image from designer and viewer

Ninan — Fri, 10 Apr 2015 16:57:12 GMT

We still have SAS VA 6.3 in our shop and we were not able to perform print (Pre-Production),

While printing VA was throwing error about PrintBird stored process

“HTTP Status 500... Error encountered executing stored process”, later SAS support/Admin was able to resolve this issue making the few security access in my our side.

After resolving that, it was found that report is not generating any data, ie print just produce blank PDF and SAS support response on this is that

this problem exists in UNIX environment, and entire printing model was scrapped and rewritten from scratch and ver 7.1 no longer uses the PrintBird stored process !!

So upgrade is the only option left for us.

Anybody using 6.3 has any workaround to do print other than taking screenshots?

Thanks..

Stack container object restore while transitioning in maximized view [V6.3]

Ninan — Mon, 06 Apr 2015 16:24:59 GMT

Version: SAS VA 6.3

I have created a VA report with multiple objects including a stack container,
area occupied by stack container is only quarter of the page, so I am using maximize icon to expand the view

But I am not able to move from one stack container object to next while the container is maximized, ie if I click the next arrow while stack container is maximized, it goes to next object but restore to original size.

But I have seen in “SAS Sample Reports Cross Industry” (2nd tab: product overview, revenue per vendor stats-stack container”)
http://www.sas.com/software/visual-analytics/demos/cross-divisional.html
it will goes from one stack container object to another without restoring to original,

is the SAS report created with ver 7.1?
ie Stack container object restore while transitioning in maximized view is a limitation of ver 6.3?

Re: Custom summarization/ Default list selection

Ninan — Thu, 05 Mar 2015 16:41:12 GMT

I was able to achieve my goal using Aggregated Measures, unlike Calculated Data Items, it summaries the data based on the group value after aggregation. Ie in total column, it doesn't summarize the data from it's column data, but recalculates based on the formula using final grouped numbers of other columns in the formula. There may be limitations in Aggregated Measures, but few of those can be overcome by prior data preparation.
it is possible to have default selections in list control, ie once we link (interaction) list control with an object and save with a selection, then we can reopen it with same selection which will serve as the default selection.

note: still using VA Ver 6.3

Custom summarization/ Default list selection

Ninan — Wed, 18 Feb 2015 16:46:07 GMT

In visual analytics, table crosstab object has an option to sum the column total, but is it possible have additional customization to modify the summary line like in PROC REPORT computational override? Ie instead of sum of a column, I want to a different value like weighted average and instead of literal "Total" something like "National"?

Ie I have data related to all 50 USA states and I want the summary at bottom, and few columns have special formula and summary national numbers are not just sum of all the individual states.

Considering this is not possible in my 6.3 version, I am thinking to have a workaround to have separate row for national and values readily calculated in the data itself before presenting it and to have a “list” control to display the national value,

but second question I have is that is it possible to have a default list selection in list control?

Ie initially I had only states values and when I open the visualization, it will show the summary of all data without any filtration, due to above mentioned first problem I included a separate summarized row for national, now the total value will be double at the initial screen, but users can select national from list to get the correct value, so is it possible to have a default national selection in the first place when the visualization is displayed?

VA report- filter interaction

Ninan — Fri, 13 Feb 2015 17:19:02 GMT

I am using SAS VA6.3; I am novice to this product

I want to know how to set up global filters/control in reports OR how interaction across section can be set as “filter” instead of “link”

I have seen other similar posts on filters and response that the new 7.1 version will have these capabilities, our shop may NOT have this new version in near future, so can anyone please suggest a workaround to achieve this?

I want to create report with 4 sections/tabs and all 4 sections will be using different data/tables (I already have summarized data in four different tables instead of single huge combined source table)

Say I have common column “US STATES” in all the tables and I want a STATE list OR drop-down list in the first tab and if I select this control it should reflect the selection in all other sections, ie show only the selected state data.

If I include all tables in to a single section/tab, then I am able to have the “filter interaction” but once I move to different section it will drop the filter interaction WARNING-“If you move the object (List Table 2) to a different section, you will delete all of the interactions that are associated with that object.”

Interaction has an option like “Map data source”/link section with common columns, with this option, I am able to link to different sections using a common column, ie my case if I click on an object and then it will link to corresponding data in the next link, but linking is not related to filter or control, ie if I select two STATES from a list in the first section, I want those two selected states data only in all other sections too.

Note: I am creating reports and not exploration, in exploration I have seen global and local filter option but it is not available in reports and also it is not applicable to my scenario since I want users to select the filter while viewing the visualization.

Re: web tabs in tagset tableeditor

Ninan — Fri, 23 Jan 2015 18:42:21 GMT

options(pagebreak="2" PANELROWS="2" web_tabs="TAB1111,hide,TAB222");

this resolved my problem

Re: web tabs in tagset tableeditor

Ninan — Fri, 23 Jan 2015 17:37:48 GMT

I have same question as above to display reports top and bottom instead of side by side in stored process output

I have 3 reports and I want rpt1&2 in tab1 and RPT3 in tab2, I am able to display it using

ods tagsets.tableeditor file=_WEBOUT style=sasweb

options(PANELCOLS="2" web_tabs="TAB1111,hide,TAB222");

but report one and two are on side by side

in http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/tableeditor.tpl

I found an option PANELROWS, so I replaced PANELCOLS with PANELROWS, but it didn’t help.

note: my SAS version 9.4

Any help will be appreciated

Re: STP GMAP GIF image in Dashboard Indicator

Ninan — Thu, 22 Jan 2015 15:34:47 GMT

==response from SAS Technical Support===

SAS BI Dashboard supports only static images

and animated GIF files are not supported. Thus, there is not a way for BI Dashboard to display an interactive, or drillable, map.

The Information Delivery Portal includes a stored process portlet that might work well for you in this case.

For more information about custom graph indicators, see

http://support.sas.com/documentation/cdl/en/bidbrdug/67143/HTML/default/viewer.htm#n07w7uoobu0eron1p3u45zz3nz12.htm

Addressing your question about "call package_publish", BI Dashboard consumes data tables from SAS package files. No other package content can be read from BI Dashboard.

For more information, see

http://support.sas.com/documentation/cdl/en/publishdg/64884/HTML/default/viewer.htm#p0t7sslcpae11kn1i3ox1tn1e0pl.htm

Re: STP GMAP GIF image in Dashboard Indicator

Ninan — Mon, 12 Jan 2015 17:31:35 GMT

after including ods listing close; before ODS html

it is not throwing authorization error, but not producing any final output

“The SAS program did not produce any output.” And no error in the SAS log.

ie as per SAS BI dashboard 4.4 UG page 57 "Create a Stored Process to Use for Indicator Data" 1.c says

sets the macro variable _ARCHIVE_FULLPATH to the path of the archive file that the stored process generates

I have result from GMAP as

NOTE: 29428 bytes written to /data1/saswork/SAS_workA11F00038935_xxxxxx/SAS_work873800038935_xxxxxx/gmap.gif.

is archive file path " /data1/saswork/SAS_workA11F00038935_xxxxxx/SAS_work873800038935_xxxxxx/gmap.gif."?

%let _ARCHIVE_FULLPATH=&floc./gmap.gif; ?

I have also tried few code available in Paper 045-2010, Interactive Dashboards

http://support.sas.com/resources/papers/proceedings10/045-2010.pdf

does the "call package_publish" applicable to streaming gif images too or only for streaming dataset?

STP GMAP GIF image in Dashboard Indicator

Ninan — Mon, 12 Jan 2015 15:38:41 GMT

==Repost==

I have a stored process with below details and it is showing the output as expected

goptions device=gif;

goptions gsfname=_webout gsfmode=replace;

proc gmap map=USMAP data=usadata all;

But I want this image in dashboard, so I disabled “STP macro in SAS code” (already steaming and package is enabled and not using %STPBEGIN)

And now throwing

ERROR: Insufficient authorization to access /sas/config94/Lev1/YYYYYY/3225DC00-984F-11E4-A2BB-001E6787D0B2.

note: if the device=png, it will not throw any error, but png will not have drill down facility[interactive/clickable], ie I am able to get a plain US map in dashboard

After doing some research, I added a code as below after goption

%let floc=%sysfunc(pathname(work));

ods html gpath="&floc"

file="&floc./test.html"

;

And still it is throwing that error, but it wrote 22KB to work location (&floc)

100 proc gmap map=USMAP data=usadata all;

NOTE: 22252 bytes written to /data1/saswork/SAS_workA38D0004281D_xxxxxx/SAS_workD5DA0004281D_xxxxxx/gmap.gif.

ERROR: Insufficient authorization to access /sas/config94/Lev1/YYYYYY/3225DC00-984F-11E4-A2BB-001E6787D0B2.

Any help will be appreciated

SAS portal name different than SP

Ninan — Thu, 20 Feb 2014 19:06:31 GMT

In SAS portal, is it possible display different name than it's corresponding stored process name?

ie SAS stored process name is “SP12345 Monthly sales report” but in SAS portal I just want to display it as “Monthly sales report”

thanks