BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
j0andre1
Fluorite | Level 6

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

View solution in original post

2 REPLIES 2
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
ballardw
Super User

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.

 

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1251 views
  • 0 likes
  • 3 in conversation