Custom Rich-Text Page

Index Document SAS   SAS Questions SAS Main Frames Example. Data Warehousing C Programs Trouble Shooting  Favorite Sites Informatica  Blog



     
Text1 contains the follwing code:

satish 26695_IN  9393944950
raju 35955_IN 9566667866
king  45666_IN 9944446455

Text2 contains the following code:

rajan 26795_IN  9393944950
rani 35855_IN 9566667866
Ravi  35676_IN 9944446455

Control card PATHFILE.SAT.FCC.DATA(KDA) contains the following code.

data Text1;
infile INPUT1;
input name $ KINID $ mobilenumber;
run; 

data Text2;
infile INPUT2;
input name $ KINID $ mobilenumber;
run; 

data Text3;
set Text1 Text2;
by KINID;
FILE OUTPUT1;
put name $ KINID $ mobilenumber;
run;

//jobname job(ACCOUTNINFORMATION),'uSERNAME',MSGCLASS=H,CLASS=B,MSGLEVEL(1,1)
//EXENAME EXE SAS
//WORK    DD   DSN=&&WORK,&STORE1,UNIT=SYSDA 
//SASLOG DD SYSOUT=&SAR2
//INPUT1 DD DSN=TEXT1FILEPATH
//     DISP=SHR
//INPUT2 DD DSN=TEXT2PATH
//     DISP=SHR
//OUTPUT1 DD  DSN=SASD.FDFD.FDFD.FILENAME
//  DISP(NEW,CATELOG,DELETE) 
//  DCB=(LRECL=100,BLKSIZE=0,RECFm=FB)
//  SPACE(TRK(3000,30),RLSE)
//  UNIT=SYSDA
//SYSIN DD DSN=PATHFILE.SAT.FCC.DATA(KDA)
//    DISP=SHR 
//SYSOUT=*
//
//* &Store1 is noting but a macro variable where we can stroe the prefined space details
//* QFI8060 PROC GEN0='+0',                                              
//*              STORE1='SPACE=(CYL,(750,350),RLSE)',