PROC IMPORT Excel hyperlink to a SAS data set

Dick_Pickett — Wed, 07 Jul 2021 20:10:48 GMT

Is this possible?

Example: An Excel cell contains: =HYPERLINK("[mailto:SNFVBP@rti.org]", "SNFVBP@rti.org")

PROC IMPORT does not import the cell contents.

PROC IMPORT datafile = "report" out = &tabnamecon
dbms = XLSX REPLACE ;

sheet = "&tabname" ;
getnames = NO ;
%IF &columnheadline = NA %THEN %DO ;
datarow = 1
%END ;
%IF &columnheadline ^= NA %THEN %DO ;
datarow=&columnheadline
%END ;
;
RUN ;

Re: PROC IMPORT Excel hyperlink to a SAS data set

Reeza — Wed, 07 Jul 2021 20:24:18 GMT

When importing from Excel, it reads the value of the cell, not the formulas of the cell.
I'm not aware of any method to retrieving the formulas beyond parsing the XML file which is very cumbersome.

topic PROC IMPORT Excel hyperlink to a SAS data set in SAS Procedures

PROC IMPORT Excel hyperlink to a SAS data set

Re: PROC IMPORT Excel hyperlink to a SAS data set