I was practicing using R programming in Proc IML, specifically with loading an Excel file through R in Proc IML and then reading it back to the SAS session to work on via SAS. The program I have written does this correctly, but it produces a warning message as follows: WARNING: R: - | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ | / - \ This happens appears to be happening when I write the code to read in the Excel file. For reference, my SAS code is the following: *Assign macro variables;
%let filepath = C:\\datafolder\\Input Table.xlsx; %let sheet_name = Part 1;
*Start proc iml;
proc iml;
path = "&filepath."; sheet_select = "&sheet_name."; submit path sheet_select/ R; /*Start R Session*/ #Load Packages library(readxl) table <- read_excel("&path1", sheet = "&sheet_select", skip = 2) endsubmit; call ImportDataSetFromR("output_table","table"); quit;
I don't think this is a data issue because I don't get this error when I run the program in R Studio. Additionally, the actual dataset comes back fine, there's just this error that comes up with it and I have no idea what it means. Note: I'm aware of methods to read in Excel files just using SAS with proc import and the like. I'm mainly doing it this as way in order to practice using R code in SAS via Proc IML.
... View more