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.

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

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.

SAS Training: Just a Click Away

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

Browse our catalog!

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