How to upload import Excel data into SAS Studio
HTML-код
- Опубликовано: 4 ноя 2024
- 1. First login to your SAS Studio account
odamid.oda.sas...
2. Make sure you know where you saved your Excel data file on your computer
3. Under Server Files and Folders create a new folder, by right-clicking on "Files" and selecting "New then Folder". Let's name it MATH807
4. Right click on the folder "MATH807" and select "Upload Files". You'll get a dialog box, click on "Choose Files" then navigate until you choose your Excel file. Then hit "Upload"
5. Under "MATH807", find your Excel workbook and double click on it. This will show you the code that was used by SAS to import the file into SAS Studio. click on the "run" or F3 on your keyboard to generate the code to convert the Excel workbook into ctl extension file which is readable by SAS Studio. By default, this converts the file to WORK.IMPORT file under WORK Library.
6. Go to Libraries then My Libraries then WORK and find the file. Double click on the file to view its contents.
adayintheirlif...