proc olap data=mylib.newdata cube=cubeA add_data outcube=cubeB outschema=testSchema; metasvr host="myhost" port=8561 repository=myrepository olap_schema=prodSchema; run;
carscubecap
and the
suffix is da_DK
, then PROC OLAP looks
for a data set named carscubecapda_DK.sas7bdat
in the library that is specified by the CUBETABLELIBREF= option.
It is used in conjunction with the USER_DEFINED_TRANSLATIONS statement.
This specification is optional. If caption data sets are specified
but no caption is found, the default behavior is to use the captions
from the default language.
DATAPATH=('C:\data1' 'D:\data2')Then PROC OLAP places the first partition of each aggregation table into directory
C:\data1
, the second partition of each table into
directory D:\data2
, the third partition
of each table into C:\data1
, and so
on. It is also possible to have aggregation tables that use fewer
than the specified number of partitions. For example, your cube might
contain an aggregation table that fits entirely into C:\data1
.
PROC OLAP CUBE=MLSCARS DTLIBREF=OLAPLIB DTMEMPREF=CARS DTMEMPREFOPTS="obs=400";
Empty
, then the EMPTY_CHAR= option is specified as
follows:
empty_char='Empty'
Empty
, then the EMPTY_NUM= option is specified as follows:
empty_num='.'
Dictionary sort: PHONEBOOK sort: 1 Mader Ernst 1 Mader Ernst 2 Mader Fritz 2 Mader Fritz 3 Mader Josef 3 Mader Josef 4 Meder Bruno 4 Meder Bruno 5 Meder Regina 5 Meder Regina 6 Meier Hans 6 Meier Hans 7 Mlynek Mike 7 Mlynek Mike 8 Molitor Martina 8 Möller Ellen * 9 Möller Ellen 9 Möller Georg * 10 Möller Georg 10 Möller Sabine * 11 Möller Sabine 11 Molitor Martina * 12 Mras Cindy 12 Mras Cindy 13 Muller George 13 Müller Christina * 14 Muller Pam 14 Müller Heinz * 15 Muller Susan 15 Müller Max * 16 Müller Christina 16 Müller Renate * 17 Müller Heinz 17 Muller George * 18 Müller Max 18 Muller Pam * 19 Müller Renate 19 Muller Susan * 20 Mwamba Ed 20 Mwamba Ed 21 Myrzik Peter 21 Myrzik Peter 22 Mzyk Mary 22 Mzyk Mary * indicates names that changed position in the PHONEBOOK sort.
LINGUISTIC | sorts characters according to the Unicode Collation Algorithm and a specified locale. For more information on the algorithm, see http://www.unicode.org. |
UCA | is a synonym of LINGUISTIC. |
collation-options | specifies in parenthesis values for the COLLATION option and/or the LOCALE option. |
COLLATION=collation-rules | modifies the default UCA sort algorithm by applying one or more comma-separated collation rules from the following table. The default sort is based on the dictionary order of the specified locale. |
LOCALE=posix-locale-name | specifies a locale name other than the default locale, using 5-character Posix notation. As an example of Posix notation, the locale name es_AR identifies the Spanish language as it is used in Argentina. |
PROC OLAP CUBE=cubename DESCRIPTION="new description" UPDATE_DISPLAY_NAMES DT=newdtname; METASVR options; DIMENSION TIME DESCRIPTION="New TimeDescription" CAPTION="New TimeCaptions";
Drill-through tables | These can be updated with the UPDATE_DISPLAY_NAMES option. When you rename a cube, only the cube description or drill-through table name can be updated via the UPDATE_DISPLAY_NAMES option. |
NUNIQUE measures | When the UPDATE_DISPLAY_NAMES option is specified, the NUNIQUE measure's INCLUDE_CALCULATED_MEMBERS option can be toggled ON or OFF (with the addition of the NOINCLUDE_CALCULATED_MEMBERS option). |
RENAME | The only description that can change during a RENAME of a cube is the cube description (the drill-through table name can also be changed during a RENAME). Other descriptions and captions must be altered in a separate step after the RENAME is executed. |
ERROR: Cannot create temporary index for proc olap. NOTE: The SAS System stopped processing this step because of errors.In the