cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
Jason1122
Calcite | Level 5 Jason1122
Calcite | Level 5

Excel hyperlink import into sas

Posted 01-03-2021 08:17 AM (628 views)
Can I import the hyperlink (For example, by clicking in the link in excel, it will show a photo) from excel into sas. Which means I can click the link in sas to show the photo as well.
0 Likes
Reply
1 REPLY 1
Tom
Super User Tom
Super User

Re: Excel hyperlink import into sas

Posted 01-03-2021 11:12 AM (578 views)  |   In reply to Jason1122

Are you saying the content of some cell in your Excel file is the text of a URL that points to an image?  If so then the corresponding variable in the imported SAS dataset will have the same text.

But if the hyperlink is an attribute of the cell then that will NOT be imported into the SAS dataset.  The same way that the color or the font is not imported into the SAS dataset.

0 Likes
Reply

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

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.

Watch Mastering the WHERE Clause in PROC SQL on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎01-03-2021 08:17 AM
  • 629 views
  • 0 likes
  • 2 in conversation