Hi All,   Need suggestion on creating new variables from an existing variable which is delimited. foir example i have values in the variable VAR_A as &PRODUCT=AXCV12345&sState=ABC&year_det=2014&TELEPH=1234567890.   i need to create new variables from variable "VAR_A". product                 State      year_det   Phone_Number AXCV12345           ABC          2014      1234567890   the delimiter appears "&,? and =" appear more than once for the variable  "VAR_A".   Please suggest.       ... View more

Hi,   I am trying to create an indicator based on the value contributed from the tables while merging i need to merge the 3 tables in order to generate an output.   i need to create an indicator column with the values 1 , 0 in it   the output should look as below from the three tables merged.   Data TableA; Input A B C; 1 1 2 3  2 4 5 6 7 8 9 ;   Data TableB; Input A B C; 12 11 2 3 34 4 5 6 1 71 8 9   Data Tablec; Input ID A B C; 1 10 2 3 2 41 5 6 3 7 8 9 ID   tableA  tableB  TABLEC 1      0          1           0 12   1           0           1 3   1            1            1     I hope i am clear on this   ... View more

Hi  I am trying to Write a SAS code which would trigger an email when the disk size reaches 75%. Kindly help me on this. ... View more

Hi All ... I am trying to execute a Data Step based on the availability of a signal file. The  SAS Data Step  should execute after the file is available at a location, the SAS program should check the availablity of file for every 10-15 and for Max time of 3 hours and if the file is available then execute the DATASTEP. The SAS programs will be called in Cron's Please suggest me on this. /*DATE VARIABLES FOR THE CURRENT ORPHAN RUN...BASED ON THE SIGNAL FILE*/ Data _Null_;   Rept_date= INTNX('DAY',"&SYSDATE."d,0);   Mnth=Month(Rept_date);   Year=Year(Rept_date);   Days=Day(Rept_date);   if Mnth<=9 Then   do;   Mnth_N=Put(Mnth,Z2.);   End;   Else  Mnth_N=Mnth;   if Days<=9 Then   do;   Days_N=Put(Days,Z2.);   End;   Else  Days_N=Days;   Put  Days_N;   NewDte= Compress(Cats(Year,Mnth_N,Days_N),'/');   Call Symput ('New_dte',Newdte); Run; %put Days====>&new_dte.; %LET myfilerf=<"FILE PATH........">; %PUT File=====>>> &myfilerf.; %LET fname= %trim(SALES_&new_Dte.).txt; %PUT Filename=====>>> &fname.; %let Entity= %scan(&myfilerf.,-1); /*Name of the Entity or region for SALES extracted from the File path */ %put Entity======>> &Entity.; %global counter max; %let counter=0; %let max=60; /* Minutes To Check */ options Nomlogic Nomprint Nosymbolgen; ******************************************************************************; *** RUN JOB ******************************************************************; ******************************************************************************; %MACRO FILE_WAIT();   %if (%sysfunc(fileexist(&myfilerf.\&fname.))=1 )% then   %do;   %PUT NOTE: "SIGNAL FILES EXISTS, ORPHAN DATA PROCESSING....";   *INCLUDE THE PROGRAM TO BE EXECUTED IF THE ABOVE CONDTION IS TRUE;   %end; /*1*/   %else   %do;   %PUT WARNING: WAITING ORPHAN SIGNAL FILES: &myfilerf.\&fname.;   %do %until (%sysfunc(fileexist(&myfilerf.\&fname.))=1 or (&counter+0 > &max+0));   Data _Null_;   Sleep= SLEEP(5,1);   Run;   %put MAX====>>>  &max.;   %let counter=%eval(&counter.+1);   %put COUNTER===>>>>> &counter.;   %if &counter+0 > &max+0 %then   %goto EXIT;   %if (%sysfunc(fileexist(&myfilerf.\&fname.))=1 ) %then   %do;   %put Note: Orphan File Processing...;   %end;   *2;   %end;   *3;   *** Stop program if time out ***;   %end;   %EXIT: %mend FILE_WAIT; %FILE_WAIT(); ... View more