1 The SAS System 12:11 Thursday, June 11, 2015
;*';*";*/;quit;run;
OPTIONS PAGENO=MIN;
%LET _CLIENTTASKLABEL='UOM Conversions';
%LET _CLIENTPROJECTPATH='';
%LET _CLIENTPROJECTNAME='';
%LET _SASPROGRAMFILE='A:\Audits and Compliance\Audit Queries\UOM Conversions.sas';
ODS _ALL_ CLOSE;
OPTIONS DEV=ACTIVEX;
GOPTIONS XPIXELS=0 YPIXELS=0;
FILENAME EGSR TEMP;
ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue
! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE
! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
GOPTIONS ACCESSIBLE;
/*UOM conversions*/
libname pwdlib '/import/sas/work01/prod/Contract_Pricing/pwd';
NOTE: Library PWDLIB does not exist.
/* Read in the CALMS dump file from SQL server 01dV */
data _null_;
set pwdlib.pwd;
ERROR: Library PWDLIB does not exist.
If DbServer='SQL_Server' then do;
call symput("uname", username);
call symput("pwd", pwd);
end;
run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
22:27 23:25
NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
WARNING: Apparent symbolic reference UNAME not resolved.
WARNING: Apparent symbolic reference PWD not resolved.
%put &uname**&pwd;
&uname**&pwd
PROC SQL;
connect to ODBC as myconn (user=&uname password=Xpwd datasrc=ITASQL01PR);
WARNING: Apparent symbolic reference UNAME not resolved.
WARNING: Apparent symbolic reference PWD not resolved.
ERROR: The ODBC engine cannot be found.
ERROR: A Connection to the ODBC DBMS is not currently supported, or is not installed at your site.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
CREATE TABLE UOMs as
select * from connection to myconn
(select * FROM prc_misc.pmktngsvc01.cutuomco
order by n_numrc_item
);
2 The SAS System 12:11 Thursday, June 11, 2015
NOTE: Statement not executed due to NOEXEC option.
disconnect from myconn;
NOTE: Statement not executed due to NOEXEC option.
quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.01 seconds
PROC TRANSPOSE DATA=UOMS OUT=UOM_CONV;
ERROR: File WORK.UOMS.DATA does not exist.
VAR C_RTL_UOM C_SELL_UOM1 C_SELL_UOM2 C_SELL_UOM3 C_SELL_UOM4
C_SELL_UOM5 A_FCTR_UOM1 A_FCTR_UOM2 A_FCTR_UOM3 A_FCTR_UOM4 A_FCTR_UOM5;
BY N_NUMRC_ITEM;
RUN;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.UOM_CONV may be incomplete. When this step was stopped there were 0 observations and 0 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
PROC TRANSPOSE DATA=UOM_CONV OUT=OUT1;
VAR COL1;
ERROR: Variable COL1 not found.
ID _NAME_;
ERROR: Variable _NAME_ not found.
BY N_NUMRC_ITEM;
ERROR: Variable N_NUMRC_ITEM not found.
RUN;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.OUT1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
NOTE: PROCEDURE TRANSPOSE used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
GOPTIONS NOACCESSIBLE;
%LET _CLIENTTASKLABEL=;
%LET _CLIENTPROJECTPATH=;
%LET _CLIENTPROJECTNAME=;
%LET _SASPROGRAMFILE=;
;*';*";*/;quit;run;
ODS _ALL_ CLOSE;
QUIT; RUN;
My question is could someone solve the errors which have been reported here and help me out.
Regards
Laxman Pai
Fix the first error and most likely the rest will resolve.
ERROR: Library PWDLIB does not exist.
Make sure the path is correct, exists and you have access to it via EG.
Most of your problem comes from
libname pwdlib '/import/sas/work01/prod/Contract_Pricing/pwd';
NOTE: Library PWDLIB does not exist.
something in that path is incorrect in your setting.
If you have a server install then the path to the data from the server may not be correct. If this running local then it is likely to be looking for that path starting subordinate to the currently active SAS location.
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.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.