How to Import Multiple EXCEL Sheets into SAS & R
Watch this video for tricks on how to import data from multiple sheets into SAS and R. I thought it may be interesting for folks who want to make a smooth transition from either of the platforms (SAS or R) to another.
The SAS import present two steps, either of which is fine depending on the number of sheets you want to import. If you have to import data from more than 7 sheets, I will recommend 'Step 2'. This step ensures you use minimal lines of code, and still do the import more efficiently.
As I mentioned in the video, there is not limits to what YOU can do.
--------------------------------------------------------------
Also check out these videos:
-------------------------
How to import CSV into SAS & R: • How to import CSV into SAS & R
How to Import Excel File into SAS & R: • How to Import Excel File into SAS & R
How to Import Multiple CSV into SAS & R: • How to Import Multiple CSV Files into SAS & R
How to Import Multiple EXCEL into SAS & R: • How to Import Multiple EXCEL into SAS & R
------------------------------------------------------------------------------------------
Check out the codes on GitHub: https://github.com/DataGymCenter/SAS-...