SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 64277: "Detailed data" option in the Export Data dialog box is missing or it returns "expected parameter: # was not found" in a SAS® Visual Analytics report

DetailsHotfixAboutRate It

Overview

Depending on which application you are using, you might encounter one or both of these two issues when attempting to export detailed data from a SAS Visual Analytics report:

  • In SAS Visual Analytics, you see the following error when you select Detailed data in the Export Data dialog box:
The expected parameter: # was not found. An error occurred.
  • In SAS® Report Viewer, the Detailed data option is missing from the Export Data dialog box.

    Note: There are valid reasons why Detailed data is not available. For example, Detailed data is not available for objects that have a post-aggregate filter. To determine whether you are encountering the problem described in this note, attempt to export detailed data from SAS Visual Analytics. If you also see the error, then you are encountering this issue.

Cause

These problems can occur if the report includes a calculated data item that uses a parameter in an IF/ELSE expression. Here is an example:

IF ( 'MyMeasure Parameter'p Contains 'Revenue' )
                  RETURN 'Revenue'
                  ELSE 'Profit'n

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Visual AnalyticsLinux for x648.38.4ViyaViya
Microsoft® Windows® for x648.38.4ViyaViya
SAS SystemSAS Report ViewerMicrosoft® Windows® for x648.38.4ViyaViya
Linux for x648.38.4ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.