In SAS^® 9.2, the Data source and Data source item SAS^® Stored Process prompts are available. These new prompts are documented in the SAS® 9.2 Stored Processes: Developer's Guide in the Macro Variables That Are Generated from Prompts section.

The %metadata_getDatafileFromPath macro can be used in your SAS Stored Process code to retrieve metadata information for the prompt values. The following example SAS Stored Process code illustrates the use of this macro. Here are some comments about the SAS Stored Process code.

• A Data source prompt called datasrc needs to be defined for the SAS Stored process using SAS^® Management Console since this is the name that is used in the example SAS Stored Process code ( referenced as &datasrc ).
• The datasrc_type parameter is automatically created and passed to the SAS Stored Process. This parameter is associated with the datasrc prompt. Note that the first portion of the name is the same, followed by _type.
• Possible datasrc_type values (which represent the type of the data source).

  • datasrc_type=1 represents a SAS Table

  • datasrc_type=2 represents a Cube

  • datasrc_type=4 represents a Relational Information Map

  • datasrc_type=8 represents an OLAP Information Map

• The output is stored in a SAS^® data set called mytable.
• The assignlib=y parameter is required.
• You can retrieve metadata information about a Data source item prompt in the same manner as a Data source prompt.

/* This SAS Stored Process retrieves metadata for a Data Source */
/* and saves the output in a SAS® data set using the         */
/* %metadata_getDatafileFromPath macro.                     */
/*                                                          */
/* Input Parameters: &DATASRC, &DATASRC_TYPE                */
/* Output Parameters: MYTABLE                               */

*ProcessBody;

%METAAUTO;

%metadata_getDatafileFromPath(path=&DATASRC,
                              type=&DATASRC_TYPE,
                              assignlib=y,
                              outvar=MYTABLE, 
                              debug=y);

%stpbegin;

  proc print data=&MYTABLE(obs=25) label; 
  run; 

%stpend;

Operating System and Release Information