BookmarkSubscribeRSS Feed
LM2022
Calcite | Level 5

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. 

1 REPLY 1
SASKiwi
PROC Star

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 542 views
  • 0 likes
  • 2 in conversation