Hello Barry,   There are a couple of different ways that filter states can be displayed in VA.   When you follow a report link or page link action, a breadcrumb trail will appear at the top of the page. There is a filter icon on this trail that lets you see and toggle any filters from the source object that you followed the link from.   You can also display "interactive filters" as dynamic text in a Text object. This includes filters from page and report prompts and from page and report link actions.   The Filters pane displays the status of any object-specific filters, and when you are in View mode it also shows "interactive filters" such as those from report prompts.   Does this help?   Sam ... View more

Okay, I unloaded the table without the extension, and then loaded the one with the sashdat extension. Now they both have the columns I need. I went back to the dashboard editor, it still isn't there. Maybe I need to wait until the DI jobs run? ... View more

Thanks, I figured it out.  You at least pointed me in the right direction.  There were two things I wasn't understanding.  1)  That each rule needed to be written separately and 2)  That I could make a rule for a single chart. ... View more

Hi Barry,   Putting this information in a text object on the same page is probably the best approach. If there is a lot of information, you could put a link in text object that would go to another page for details. This could be a hidden page, which will act as a pop-up window when the user clicks the link.   Sam ... View more

You will need to identify the correct library reference name for the query to work. A library reference is name that has a maximum of 8 bytes with 1 char=1 byte. The name can begin only with a letter or an underscore followed by numbers or chars  ... View more

Are you linking the prompt container itself, or the list control object inside the container. If you select the list control, then Actions tab, you should be able to select both tables. The table that uses a different data source should prompt you to map the Country column.  ... View more

I get this in a log.  Not sure what it's supposed to be showing me; 1 The SAS System 21:02 Wednesday, October 2, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program (11)'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH=''; 6 %LET _CLIENTPROJECTPATHHOST=''; 7 %LET _CLIENTPROJECTNAME=''; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=ACTIVEX; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///D:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 24 FILENAME EGXLSSX TEMP; 25 ODS EXCEL(ID=EGXLSSX) FILE=EGXLSSX STYLE=Excel 26 OPTIONS ( 27 EMBEDDED_TITLES="no" EMBEDDED_FOOTNOTES="no" SHEET_INTERVAL="None" 28 ); WARNING: Unsupported device 'ACTIVEX' for EXCEL(EGXLSSX) destination. Using device 'ACTXIMG'. 29 30 GOPTIONS ACCESSIBLE; 31 32 filename _all_ list; NOTE: Fileref= EGSR Physical Name= /sas/saswork_das/SAS_work122700002C60_shcsbiapp1vp/#LN00185 NOTE: Fileref= EGXLSSX Physical Name= /sas/saswork_das/SAS_work122700002C60_shcsbiapp1vp/#LN00186 NOTE: Fileref= STDIN Physical Name= <standard input> NOTE: Fileref= STDOUT Physical Name= <standard output> NOTE: Fileref= STDERR Physical Name= <standard error> NOTE: Fileref= FILDES03 Physical Name= <File Descriptor 03> NOTE: Fileref= FILDES04 Physical Name= <File Descriptor 04> NOTE: Fileref= FILDES05 Physical Name= <File Descriptor 05> NOTE: Fileref= FILDES07 Physical Name= <File Descriptor 07> NOTE: Fileref= FILDES08 Physical Name= <File Descriptor 08> NOTE: Fileref= FILDES09 Physical Name= <File Descriptor 09> 33 34 GOPTIONS NOACCESSIBLE; 2 The SAS System 21:02 Wednesday, October 2, 2019 35 %LET _CLIENTTASKLABEL=; 36 %LET _CLIENTPROCESSFLOWNAME=; 37 %LET _CLIENTPROJECTPATH=; 38 %LET _CLIENTPROJECTPATHHOST=; 39 %LET _CLIENTPROJECTNAME=; 40 %LET _SASPROGRAMFILE=; 41 %LET _SASPROGRAMFILEHOST=; 42 43 ;*';*";*/;quit;run; 44 ODS _ALL_ CLOSE; NOTE: Writing EXCEL(EGXLSSX) file: /sas/saswork_das/SAS_work122700002C60_shcsbiapp1vp/#LN00186 45 46 47 QUIT; RUN; 48 ... View more

data want; char="fsdfdgbv¿42553"; position=find(char,"¿"); run; ... View more

Why would SAS change the label if all you did was change the name? You could set the new label. data New_Table; set Old_Table; rename Variable_Name = 'Variable Name'n; label Variable_Name = 'Variable Name'; run; Or perhaps just remove the old one. data New_Table; set Old_Table; rename Variable_Name = 'Variable Name'n; label Variable_Name = ' '; run; ... View more

@BarryP  For merging/joining all the data must be on the same server (your Server1).  You can either find a way to issue libname statements which can access all the data you need - the libnames with UNC paths as proposed. That's the easiest way if it works.   If you have SAS/Connect licensed then you can also use remote library services. Such a library definition allows you to transparently access data via a remote SAS server (your Server2).   How this works is documented here (the SAS/Connect client in the docu is your Server1 to which you connect via SAS EG): https://go.documentation.sas.com/?docsetId=connref&docsetTarget=p12j8b6w2nuxpon15xu0fqsisfkk.htm&docsetVersion=9.4&locale=en  ... View more

Thanks, Tom.  This was the step that I was misunderstanding the most.  One I convert to characters, this seems to solve my problem: proc transpose data=Date_Formats; var var1 var2 var3; run; ... View more