topic Re: How to export dataset into a pivot table in specified sheet? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179319#M34235 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><A href="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf" title="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf">http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf</A></P></BODY></HTML> Fri, 20 Dec 2013 13:00:31 GMT JatinBansal 2013-12-20T13:00:31Z How to export dataset into a pivot table in specified sheet? https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179318#M34234 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Pleas help me to export a data set into a pivot table.</P><P></P><P>Thanks ...</P><P></P><P></P><P>Regards</P><P>Karthik</P></BODY></HTML> Fri, 20 Dec 2013 12:56:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179318#M34234 KarthikSrivasthav 2013-12-20T12:56:49Z Re: How to export dataset into a pivot table in specified sheet? https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179319#M34235 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><A href="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf" title="http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf">http://www.sas.com/offices/NA/canada/downloads/UserGroups/CSUG-May2013/Eberhardt-PivotTables.pdf</A></P></BODY></HTML> Fri, 20 Dec 2013 13:00:31 GMT https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179319#M34235 JatinBansal 2013-12-20T13:00:31Z Re: How to export dataset into a pivot table in specified sheet? https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179320#M34236 <HTML><HEAD></HEAD><BODY><P>Hi Karthik,</P><P></P><P>summarize the data first and </P><P>Using autofilter='yes' option u can put filters to the variables using SAS Tagsets.ExcelXP.</P></BODY></HTML> Thu, 02 Jan 2014 08:54:41 GMT https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179320#M34236 Vish33 2014-01-02T08:54:41Z Re: How to export dataset into a pivot table in specified sheet? https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179321#M34237 <HTML><HEAD></HEAD><BODY><P>If you have already prepared your pivot table and only need to have data written into the data range of the pivot table there ils a simple way if you have a SAS/ACCESS product that will allow you to use an excel&nbsp; data range name like a sas dataset. It just needs a libname statement using SAS/ACCESS to ODBC&nbsp; or&nbsp; SAS/ACCESS to PC Files along with an excel range name addressing the data area of the pivot.</P><P>Would that help in this case?</P></BODY></HTML> Thu, 02 Jan 2014 22:37:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-export-dataset-into-a-pivot-table-in-specified-sheet/m-p/179321#M34237 Peter_C 2014-01-02T22:37:42Z