Hi, I want to import an excel file which has a column with hyperlink to a text or SQL file in such a way that SAS should read the file in hyperlink along with other excel columns. Can anyone help me with the code? For example Excel file codeid reviewid code objectid 123 32 "H:\My Documents\code1.sql" 12 321 34 "H:\My Documents\code2.sql" 13 234 54 "H:\My Documents\code3.sql" 14 The output I would like see codeid reviewid code objectid 123 32 Select Customerid ,Name From customer.customerdb Where name = ‘ab***’ 12 321 34 Select Customerid ,Name ,b.account From customer.customerdb a Left join a.account b on a.id= b.id 13 234 54 Select Customerid ,Name ,b.account ,Max(b.sale) sale From customer.customerdb a Left join a.account b on a.id= b.id Group by 1,2,3 Select Customerid ,Name ,b.account ,Max(b.sale) sale From customer.customerdb a Left join a.account b on a.id= b.id Group by 1,2,3 14 Thank you for your help
... View more