If successful, the Log window should tell us how many observations and variables the new dataset contains.Īdditionally, you can preview the dataset in the Output Data tab. Once you’ve executed the code, check the Log to see if any errors have occurred. To run the code, click the Run button (running man icon) to execute the code. SAS will populate the file information and generate code for importing. Once you’ve chosen the Excel file with the data, click Open. If you do not see any data files in this window, you most likely need to upload them see the previous section on uploading data to SAS ODA.) (Remember: when using SAS OnDemand for Academics, your data must be uploaded into the Server Files and Folders tab. In our case, the Excel file with the sample data is located in our Sample data folder. You can decide to drag and drop your files or select a file to import. This will create a new tab in the work area, titled Import Data 1. The easiest way to do so is to use the Import Data task:Ĭlick Tasks and Utilities in the Navigation pane, then click Import Data. After uploading *.sas files to your account, you can open and edit them just like a SAS script created directly in ODA.Īfter your datafiles have been uploaded to your SAS OnDemand for Academics account, you can import the data into a SAS data step. If you have SAS code files (*.sas) on your computer that you want to use in SAS OnDemand for Academics, you can upload them to your account using these same steps. If successful, you should see the data file(s) appear in the directory you selected in step 2:Īt this stage, if you have uploaded a SAS dataset file (*.sas7bdat) and have already mapped a library to the folder where the data file is located, you can skip the next part of the tutorial and start working with the data right away! However, if you have uploaded a text, CSV, Excel, SPSS, or other non-SAS format, you'll need to proceed to the next step: importing your uploaded data. SAS will show the name(s) and size(s) of the file(s) you selected.Click Choose Files, then choose the data file on your computer to upload. (Note that the Upload button will not be clickable until a folder location is selected, so if it's greyed out, make sure you've selected a folder.) Left-click on the folder you want to upload the data file to (usually "Files (Home)" or a folder within that directory). In the Navigation pane, click Server Files and Folders.This goes for ANY dataset you want to work with in SAS ODA, including "native" SAS datasets (*.sas7bdat) or other formats such as Excel and CSV. If you are using SAS OnDemand for Academics and have data files you want to work with in the program, you will need to upload data to your account.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |