1 从SAS取文件,装到netezza机器
从SAS安装目录
/SASFormatsLibraryforNetezza/2.1/Netezza32bitTwinFin/ ,取文件accelnetzfmt-2.1-1_lax.sh
安装步骤
mkdir –p /nz/extensions
chmod 755 /nz/extensions
cd /nz/extensions
chmod 755 accelnetzfmt-2.1-n_lax.sh
path_to_self-extracting_tar_file/accelnetzfmt-2.1-n_lax.sh
2 执行以下宏,让宏在数据库中注册。
%indnzpj;
%let indconn=SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_JAZLIB
(DATABASE=[DBNAME]
,ACTION=replace
,OUTDIR=
);
quit;
%indnzpc;
%let indconn =SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_COMPILEUDF
(DATABASE=[DBNAME]
,ACTION=replace
,OUTDIR=
);
quit;
%indnzpm:
%let indconn =SERVER=[youIP] USER=[youUSER] PW=[youPassword] DB=[youDBNAME];
%INDNZ_PUBLISH_MODEL
(DIR=[you PATH]
, MODELNAME=[youMODELNAME]
, DATASTEP=score.sas
, XML=score.xml
, DATABASE=[youDBNAME];
, DBCOMPILE=[youDBNAME];
, DBJAZLIB=[youDBNAME];
, ACTION=REPLACE
, MODE=FENCED
, IDCASE=UPPERCASE
, OUTDIR=[youOUTPUTDIR]
);
quit;
分享SAS连接到netezza配置流程
分享好友
分享这个小栈给你的朋友们,一起进步吧。
订阅须知
• 所有用户可根据关注领域订阅专区或所有专区
• 付费订阅:虚拟交易,一经交易不退款;若特殊情况,可3日内客服咨询
• 专区发布评论属默认订阅所评论专区(除付费小栈外)
技术专家
查看更多- 飘絮絮絮丶专家