RETRIEVE_DATASET

Arguments

entryId

identifies the data set entry.

Type:	Numeric
Direction:	Input

libname

specifies the SAS library that will contain the retrieved data set.

Type:	Character
Direction:	Input

memname

names the retrieved data set.

Type:	Character
Direction:	Input

rc

receives a return code.

Type:	Numeric
Direction:	Output

properties

identifies a comma-separated list of optional property names. Valid property names are as follows:

• DATASET_OPTIONS

• CSV_SEPARATOR

• CSV_FLAG

Type:	Character
Direction:	Input

propValue1, ...propValueN

specifies one value for each specified property name. The order of the property values must match the order of the property names in the properties parameter. Valid property values are defined as follows:

DATASET_OPTIONS

character parameter SAS data set options that are to be applied to the retrieved data set. For a complete list of data set options, see the SAS Data Set Options topic in the SAS Online Help, Release 8.2.

CSV_SEPARATOR

character property that applies only when the RETRIEVE_DATASET CALL routine is called on a CSV file entry. When this occurs, the CSV file is transformed into a SAS data set. A binary CSV file is identified by a MIME type of application/x-comma-separated-values. Use the CSV_SEPARATOR property to indicate the separator to be used when creating the CSV file. The default separator is a comma. If the CSV file was created at publish time by transforming a SAS data set into a CSV file, then the separator used to create the CSV file will always take precedence. If the CSV file was not created at publish time, then the CSV_SEPARATOR property can be used to specify the separator value used. If the CSV file was not created at publish time and no separator property is specified, then the separator is specified as a comma, by default.

CSV_FLAG

character property that only applies when calling the RETRIEVE_DATASET CALL routine for a binary file entry. A binary CSV file is identified by a MIME type of application/x-comma-separated-values. This property is a CSV override flag. By default when converting this binary CSV file into a SAS data set, the first line will be processed as variable names. The second line will be processed as variable label names. All remaining lines will be processed as data. To override this default behavior, the CSV_FLAG value must be NO_VARIABLES or NO_LABELS. To specify both values, specify two CSV_FLAG properties, one with a value of NO_VARIABLES, the other with a value of NO_LABELS. By default, when a CSV file is converted into a data set, the variable lengths are determined by the first row of data. If subsequent rows have greater lengths, then the variable data is truncated. To override this default behavior, specify the CSV_FLAG with a property of NO_TRUNCATION. When this flag value is specified, truncation will not occur, but multiple passes of the data might be necessary in order to perform the resizing.

Type:	Character
Direction:	Input

If the MEMNAME parameter is blank, then the RETRIEVE_DATASET CALL routine creates the data set using the original member name as it was defined at publish time.

The following example retrieves the data set WORK.OUTDATA entry from the package.

lib = 'work';
mem = 'outdata';
CALL RETRIEVE_DATASET(rid, lib, mem, rc);

The following example specifies two CSV_FLAG properties.

prop='CSV_SEPARATOR,CSV_FLAG,CSV_FLAG';
separator='/';
flag1 = 'NO_VARIABLES';
flag2 = 'NO_LABELS';
CALL RETRIEVE_DATASET(entryId, libname, memname,
   rc, prop, separator, flag1, flag2);

Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.