BookmarkSubscribeRSS Feed
bbb_NG
Fluorite | Level 6

Dear All,

     I using excel to do a pivot using SAS data.

when using pivot table wizard in step 1 select "external data source";step 2 choose get data,

then from "OLAP Cubes",then "SAS olap data provider 9.2", then connnect

then data source "choose from tools-options-administration-connections-modify to read the address as

133.9.206.139" then put user name and password, and test ok.

but when it take to 4 select the cube that contains the data your want nothing appears. no data found.

Can anyone tell me how to select "external data source" with SAS in EXcel?

Thanks in advance.

my office version is 2003.

sas eg4.2

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 0 replies
  • 802 views
  • 0 likes
  • 1 in conversation