Hi Lucas!
In order to import an excel file into SAS Studio, you should first upload it into the SAS remote server. These are the steps:
1) create a folder to upload the file: On the top left, go to the section "Server files and folders". there is a square with an asterisk, go to the arrow headed down and select folder. You will see a square where you can choose a name for the new created folder.
2) upload your file: In the "Server files and folders" section, under "Files (Home)" you can find the newly created folder. Select it and go up, in the line immediately after the "Server files and folders", and select the upload icon. Now you can navigate to your file and upload it.
3) write a libname to link your file to the program editor, this is the code:
libname Name_file " Path_file";
To know the Path_file: go to your file, left click on it, go to properties and copy the location.
I hope this is helpful.
Have a nice day 😉
... View more