How to import pivot table report data into PC SAS

[blyssz]

Hi,

I have a pivot table report and the output data for that report in MS excel.
I was wondering if I can import that data into SAS to create a SAS Dataset so that I can change the format of that report.

Thanks,
Blyssz

 

[dblan]

Are you trying to import the source data for the pivot table or the pivot table?

You should be able to import the source data with a proc import.

PROC IMPORT OUT= WORK.yourdata 
		DATAFILE= "C:\yourfile.xls" 
		DBMS=EXCEL REPLACE;
		SHEET="sheetname$"; 
		GETNAMES=YES;
		MIXED=NO;
		SCANTEXT=YES;
		USEDATE=YES;
		SCANTIME=YES;
RUN;
[/code/

Not sure about importing the actual pivot table report. However, if you have the raw data in SAS you should be able to recreate the same report in SAS.

 

[blyssz]

Thanks dblan for your response.
I am trying to import pivot table data in PC SAS as I do not have access to actual source data for the pivot table report. I need to change format of the report, so want to create SAS dataset from pivot table.

Thanks,
Blyssz