BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kuppusamy
Fluorite | Level 6

MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): proc sql noprint;
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): create table fcf_rpt.risk_classifier_report_data as select cc.risk_classifier_category_name
, cc.risk_classifier_category_desc , rc.risk_classifier_name , rc.risk_classifier_short_desc , rc.risk_classifier_desc ,
rc.risk_classifier_type_code , put(rc.risk_classifier_type_code,$classifier_type.) as type_desc format=$50. , rc.active_ind ,
rc.weight , rc.source_table , rc.source_column , rc.source_value , rc.classifier_fact_column, rc.operator_desc ,
rc.classifier_threshold , datepart(rc.create_date) as created FORMAT WORDDATE20., rc.create_user_id , rc.version_number from
seg_kc.fsk_risk_classifier_category as cc , seg_kc.fsk_risk_classifier as rc where cc.risk_classifier_category_id =
rc.risk_classifier_category_id and cc.logical_delete_ind = 'N' and rc.logical_delete_ind = 'N' order by
cc.risk_classifier_category_name , cc.risk_classifier_category_desc ;
NOTE: Optimization for the PUT function was skipped because the referenced format, $CLASSIFIER_TYPE, does not have an OTHER= range
defined.


ERROR: User does not have appropriate authorization level for file FCF_RPT.RISK_CLASSIFIER_REPORT_DATA.DATA.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): quit;


NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE| _DISARM| STOP| _DISARM| 2018-06-14T15:37:02,614+05:1800| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM|
| _DISARM| 90759168| _DISARM| 18968576| _DISARM| 10| _DISARM| 16| _DISARM| 131267| _DISARM| 1986228339| _DISARM| 0.078000|
_DISARM| 0.156000| _DISARM| 1844590022.459000| _DISARM| 1844590022.615000| _DISARM| 0.031200| _DISARM| | _ENDDISARM


NOTE: PROCEDURE SQL used (Total process time):
real time 0.15 seconds
47 The SAS System 15:36 Thursday, June 14, 2018

cpu time 0.07 seconds

MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
VERSION 6.3M1
ERROR: Unable create fcf_rpt.risk_classifier_report_data.
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
MPRINT(FCF_RISK_CLASS_LIST_EXTRACT): ;
4171 %fcf_system_admin_extract;

 

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Its a good idea to describe your problem.  Hence the answer I will give is the only thing I can get from what you posted:

ERROR: User does not have appropriate authorization level for file FCF_RPT.RISK_CLASSIFIER_REPORT_DATA.DATA.

 

Solution: Give user the appropriate permission to that file/folder/database.

 

View solution in original post

2 REPLIES 2
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Its a good idea to describe your problem.  Hence the answer I will give is the only thing I can get from what you posted:

ERROR: User does not have appropriate authorization level for file FCF_RPT.RISK_CLASSIFIER_REPORT_DATA.DATA.

 

Solution: Give user the appropriate permission to that file/folder/database.

 

Kurt_Bremser
Super User

Either dataset FCF_RPT.RISK_CLASSIFIER_REPORT_DATA already exists and the user in question does not have write permissions on it, and/or the user in question does not have write permission on the directory that library FCF_RPT points to.

If FCF_RPT is a library accessed with the META engine, SAS metadata permissions must also be checked.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 15597 views
  • 2 likes
  • 3 in conversation