Desktop productivity for business analysts and programmers

User Access issue in Enterprise guide with no issue in Base SAS

Accepted Solution Solved
Reply
Contributor
Posts: 29
Accepted Solution

User Access issue in Enterprise guide with no issue in Base SAS

Hi All

 

I am a fairly new user to EG as I usually program in base SAS and then put scripts in a EG project to automate data runs.

I picked up this issue, and being unsure around EG, I am an not sure why its giving the error.

 

I have a macro that is called and creates table names using the following convention to create table names : "table_name". Code is given below. When I developed this in Base SAS, it gives no error. It writes these tables to a library called WC000001. When I put this in EG, it gave an error 'user access' (see screen shot below).

 

proc datasets library=work noprint;
 delete CDQ_CD_MOB;
run;

%macro run_CD_MOB(MOB);

	proc sql;
 		create table "CD_&MOB.MOB" as
			select *
			 from CDQ_monthly
			 where MOB = &MOB
			;
	quit;

 	proc append data="CD_&MOB.MOB" base= CDQ_CD_MOB;
	 run;

%mend run_CD_MOB;

%run_CD_MOB(3);
%run_CD_MOB(6);

user access issue.JPG

 

 

I'd appreciate input on two matters:

1. why does EG have this issue and how do I fix it.

2. how do I redirect this code to output the tables to a library of my own choosing (or to the work library). This will probably fix the issue anyway.

 

Thnx

 

GD


Accepted Solutions
Solution
‎02-27-2017 09:00 PM
Community Manager
Posts: 2,707

Re: User Access issue in Enterprise guide with no issue in Base SAS

I think SAS is interpreting the statement:

 

 create table "CD_&MOB.MOB"

 

As a reference to a filename, not a data set.  Try removing the quotes from the reference (in both the SQL and APPEND steps).

View solution in original post


All Replies
Esteemed Advisor
Posts: 7,301

Re: User Access issue in Enterprise guide with no issue in Base SAS

I'm confused! Where do you mention the library WC000001? And, should the various file names be in quotes?

 

Art, CEO, AnalystFinder.com

 

Contributor
Posts: 29

Re: User Access issue in Enterprise guide with no issue in Base SAS

because I use a macro variable in the table name, you need to put quotation marks around the name. Because of this, SAS puts it into a temporary library (some some silly reason).

Solution
‎02-27-2017 09:00 PM
Community Manager
Posts: 2,707

Re: User Access issue in Enterprise guide with no issue in Base SAS

I think SAS is interpreting the statement:

 

 create table "CD_&MOB.MOB"

 

As a reference to a filename, not a data set.  Try removing the quotes from the reference (in both the SQL and APPEND steps).

Contributor
Posts: 29

Re: User Access issue in Enterprise guide with no issue in Base SAS

wow now I feel really embarrased & stupid...
When I developed this it gave me an error...hence I put the quotation marks around.
Maybe there was something else wrong at that time.

Thnx though.. Smiley Very Happy
Community Manager
Posts: 2,707

Re: User Access issue in Enterprise guide with no issue in Base SAS

Happens to the best of us Smiley Happy  Glad it's working.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 155 views
  • 2 likes
  • 3 in conversation