05-18-2016 12:13 PM
Could someone guide me to overcome this error? I ran this code in SAS EG 6.1 and it is connected to UNIX server.
147 proc sql ; 148 149 create table sasuser.&outfile as 150 select 151 mclu, 152 barcode, 153 cluster_num, 154 cluster_name, 155 offer_category, 156 cost, 157 units, 158 bar_code, 159 mclu_code, 160 start_date, 161 stop_date, 162 expire_date 163 from 164 plan_scrubbed 165 order by mclu 166 ; ERROR: User does not have appropriate authorization level for library SASUSER.
Thanks in advance for any guidance.
05-18-2016 12:37 PM
Run the this code
libname sasuser list;
It will give some details on SASUSER including the permission settings. this will explain the error you get.
Whether you can change the permission for the directory, this depends on the setup.
05-19-2016 03:16 AM
I think that SAS intelligence server default is setup with the -rsasuser option set.
talk to your SAS server admin to see if that can be changed, or perhaps you could be given an alternative permanent libref to store your personal results.