Hello everyone! First off, I'm using SAS v6.100 for 1-2 weeks and have only brief understanding of SAS structure and approach to data mining, analysis etc. Also, I hope my questions are not very often seen (at least I've found none similar) and I'm not creating another discussion with the same question. Is it possible to connect an Excel PivotTable directly to data sets (not OLAP cubes!), which are created as a result of any kind of Projects? I suggest the answer is yes. However, I lack of knowledge in different kind of drivers, which should be used in Excel to connect to those SAS Data sets (for example, I have a result saved as "cds.sas7bdat" and in Excel I have these: SAS IOM Data Provider 9.4 SAS Local Data Provider 9.4 SAS OLAP Data provider 9.4 SAS SHARE Data Provider 9.4). I've found a lot of different codes, which create Excels and Pivots from SAS data. But it would be nicer to have Template-PivotTables, which are refreshed manually after a Project completed in SAS - this way I would save a lot of time spent for formatting Excel-file. Please, give me some links with more information about creating connections between Excel and SAS. Thank You in advance! Cheers, Aleksejs
... View more