The name of the file must be in all lowercase because SAS University Edition is running on a Unix machine (virtual) and Unix treats the case of the letters in filenames as significant. Note that if the file is actually named DONOR.sas7bdat or Donor.sas7bdat then SAS will not be able to see it. SHEET 'Sheet1' tells SAS to import data from Sheet1. REPLACE is used to overwrite the age dataset if it exists already. It supports various formats such as excel file, csv, txt etc. OUT WORK.age tells SAS to create a dataset named age stored in WORK library DBMS XLSX tells SAS the XLSX (Excel 2007 and above) format file to read. You dont need to specify variable type and variable length to import an external file. Or data='/folders/myfolders/donor.sas7bdat' PROC IMPORT is a SAS procedure to import external files into SAS. Or just skip the libname statement and use: data='/folders/myfolders/donor' If you have a file named donor.sas7bdat in the folder you pointer DATA at then you can use either data=data.donor You also get access to: Free video tutorials that will teach you the basics of SAS programming and statistical analysis. Even if you're not affiliated with a college or university, you can sharpen your analytics skills with free access to SAS OnDemand for Academics: Studio. Instead you told PROC EXPORT to read the dataset named SAS7BAT from the libref named DONOR. Get free access to SAS OnDemand for Academics: Studio. You created a libref of DATA, but you don't use it. The lib statement runs successfully, but I still cannot expand it out when I'm under libraries so I cant select the export option. SAS University Edition is a free SAS software provided to faculty, staff & students.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |