Help using Base SAS procedures

SAS Procedure

Reply
Occasional Contributor
Posts: 6

SAS Procedure

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)Smiley SadColumn).
      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

Super User
Posts: 19,785

Re: SAS Procedure

Posted in reply to laxmanpai

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.

Super User
Posts: 11,343

Re: SAS Procedure

Posted in reply to laxmanpai

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.

Ask a Question
Discussion stats
  • 2 replies
  • 251 views
  • 0 likes
  • 3 in conversation