topic Re: how to import graphs,charts from excel(xls) file. in New SAS User

how to import graphs,charts from excel(xls) file.

j0andre1 — Mon, 01 Jun 2020 13:00:40 GMT

I have a xls file in which, one tab contains few graphs and charts and I want to import them(convert that tab into sas dataset)? how to do ?

Re: how to import graphs,charts from excel(xls) file.

ChrisHemedinger — Mon, 01 Jun 2020 13:05:21 GMT

Usually, the charts you build in Excel are based on data elsewhere in the sheet/workbook.

You can't import the chart per se, but PROC IMPORT DBMS=XLSX will allow you import the data, and then you would use SAS tools to replicate the charts as needed. You could use PROC SGPLOT with code, or tasks in SAS Enterprise Guide or SAS Studio to build these via point and click.

Re: how to import graphs,charts from excel(xls) file.

ballardw — Mon, 01 Jun 2020 13:46:30 GMT

Depending on the actual data layout used to create the graphs in Excel be prepared to massage the data because the way many people work with data in Excel is not the way the data should be structured to recreate graphs in SAS.

However without specific examples what may be needed can't be guessed at.