BookmarkSubscribeRSS Feed
AaronOani
Calcite | Level 5

Hi All,

 

Here's my SAS DB2 Job

 

//SASDB2   JOB (S9,D500,990,2000),'TEST',CLASS=A,                   
//         MSGCLASS=A,NOTIFY=&SYSUID,MSGLEVEL=(1,1)                 
/*ROUTE XEQ DB2F                                                    
//*                                                                 
//******************************************************************
//* DB2 COnnect THROUGH SAS                                         
//******************************************************************
//SASSTEP  EXEC SAS                                                 
//SYSOUT   DD SYSOUT=*                                              
//*                                                                 
//SYSIN    DD *                                                     
proc sql;                                                           
select epin,npi                                                     
    from IMSFCS90.PVTNPI;                                           
quit;                                                               
/*     

 

I got an error 'ERROR: Libref IMSFCS90 is not assigned.'.

IMSFCS90 is the creator name.

 

Please help me with my error.
                                                        

1 REPLY 1
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
  • 1 reply
  • 1298 views
  • 0 likes
  • 2 in conversation