Hello, I am a new R software user and up to now I have been able to connect to our remote server using a ssh connection.
I am able to get the file listing of the default server directory.
After that step, many questions pop-up to my mind such as
Do we need to import the sas dataset from the remote server to a windows server to have the data available for treatment in R ?
Is there a way to read the dataset directly from the server and do data manipulation without importing it ?
Is there a way to set our working directory to a folder hosted on the remote server ?
The global idea is to bring some SAS datasets into Power BI using R in order to create nice dashboard.
What's the option read directly ? import ?
and how do we do that?
Code snippet are welcome.