Good morning,
I am sure this is a simple problem but I can't seem to find an answer online. I am trying to query an SQL database that contains some protected columns (like a confidential phone number). When I use Proc SQL specifying the variables I want, none of which are protected, I get a describe error. Code and error below:
55 proc sql;
56 create table xx1 as
57 select userID, fname, lname,
57 ! email1, mailaddr
58 from OPSDB.useraccount;
ERROR: Describe error: IColumnsInfo::GetColumnInfo failed. : Deferred prepare could not be
completed.: The SELECT permission was denied on the column 'PHONENUM' of the object
'USERACCOUNT', database 'USERDB', schema 'dbo'.
59 quit;
Any thoughts? Thanks in advance.
Try an SQL Passthrough query to see if you get the same problem:
proc sql;
connect using OPSDB;
create table xx1 as
select * from connection to OPSDB
(select userID, fname, lname,
email1, mailaddr
from useraccount
);
quit;
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.