12-02-2016 06:52 PM
I have a password protected SAS dataset. I have been provided the READ password, but not the WRITE or ALTER passwords.
If I try subsetting the dataset, then I encounter the following error,
I can execute some procdures (e.g. PROC Freq) using the READ password in the procedures statement, but not other procedures (e.g. PROC sort). I need to recode the variables in this dataset for my analyses.
12-02-2016 06:56 PM
This has nothing to do with the password portion of the dataset, but with the fact that you're working on different systems. Either Unix vs Windows.
You can avoid this by transfering data via a CPORT/XPORT file instead of as a SAS dataset.
12-02-2016 07:00 PM
I am working on a Virtual Windows on my MacBook, and the dataset in a sas7bdat format. I have analyzed other databases in this format as well without any errors. Let me know your thoughts.
Thank you for your response.
12-02-2016 07:02 PM
It depends on where the SAS7bdat file originated. You're using SAS UE which is actually a UNIX box.
Most likely this file was created on a Windows machine.
It doesn't matter that you've used other files, it depends on where the file originates.
If this is from a source you've used without issue previously, and think it should work without issue, contact them for specifications on the file.
12-02-2016 07:20 PM
Thank you for your quick response. Two more questions,
Sorry for bugging you, but I’m a beginner. Thanks!
12-02-2016 08:44 PM
By file specs, I meant what OS, bit (32/64 bit), and encoding was used to create the file. These are more system settings. I can't recall if encoding matters for a SAS dataset or just text files.
AFAIK when you get the truncation error there isn't a workaround except to recreate the data.