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;
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.