topic Re: Warning when loading Excel file in R using Proc IML in SAS Programming

Warning when loading Excel file in R using Proc IML

alwayslearning — Wed, 02 Feb 2022 18:02:47 GMT

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.

Re: Warning when loading Excel file in R using Proc IML

ballardw — Wed, 02 Feb 2022 18:18:39 GMT

That looks like the text sequence for an "in progress" indicator, i.e. text equivalent of a spinning wheel.

Re: Warning when loading Excel file in R using Proc IML

Reeza — Wed, 02 Feb 2022 18:27:47 GMT

Agree with @ballardw

While R is loading a file, depending on the code used, you get the progress bar showing in the console and that's what's being shown there.

Re: Warning when loading Excel file in R using Proc IML

alwayslearning — Wed, 02 Feb 2022 19:07:35 GMT

Ahh, that makes sense. Is there any way to suppress the warning or is it just something I need to accept if I wish to use this piece of code?

Re: Warning when loading Excel file in R using Proc IML

Reeza — Wed, 02 Feb 2022 20:05:39 GMT

I took a quick look through the documentation and didn't see an option to suppress the status in the console. So I think you need to accept it if you want to use this specific code. However, not all all R packages generate this type of progress bar so using a different package to import XL may avoid the issues (but in my experience you usually get other issues).

https://community.rstudio.com/t/unwanted-console-output-from-readxl/36738