it returns another "tibble" instead of a vector. Like most people, you were probably not aware that when imported using this feature, your "File" is not a data frame, hence indexing does not work properly i.e. ![]() Choose a credential The Value of SAS Certification Prove your credibility. Would it be possible at least to give an option to import data as a data frame? You could still make tibbles the default, but at least people would be aware what class it This is the reason for your problem. SAS ® Global Certification Program Certification Manager SAS ® Certification Earning a SAS certification gets you one step closer to the future you’ve always envisioned. Of course it is always possible to convert the tibble to a data frame after import, but that rather destroys the convenience of this feature. I am sure that Camilla is not the first, and will not be the last to be tripped up by this. ![]() Specify the new table name with the CREATE TABLE clause. If the RENAME option appears in the DATA statement, then the new variable name takes effect only when the data are written to the SAS data set. Start the SQL procedure with the PROC SQL keywords. It is particularly insidious since tibbles appear the same as data frames in the environment pane, and this support article does not even mention that the data is imported as a tibble. This is how to change the name of a table in SAS with PROC SQL: 1. Search for jobs related to Sas rename variable in data step example or hire on the worlds largest freelancing marketplace with 22m+ jobs. One thing to point out is that there is an Argument called OPTIONS that has many SUB-OPTIONS, they are described in the SAS HELP under the Base SAS 9.4 (TS1M3) topic ODS EXCEL Statement. As shown, everything except ODS EXCEL is optional. Currently it imports files as one of these "tibble" things, which screws up a lot of legacy code and even some base R functions, often creating a debugging nightmare. The SAS ODS Excel destination syntax shown above is just the tip of the iceberg. ![]() The Import Dataset dropdown is a potentially very convenient feature, but would be much more useful if it gave the option to read csv files etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |