There are free sas tutorials available, you can also refer that.   http://support.sas.com/training/tutorial/#s1=4 ... View more

I am not sure what are you looking for.   Whatever you code in Base SAS windows for data extraction, same code can be generated in Data Integration studio with very minimal effort.Using DI studio, mantanence of jobs become very easy. For example, if changes comes in source table, target table columns then DI really helps to know what are impacted jobs.   DI jobs are nothing but group of transformation so it become easy to understand logic of the jobs in short time.  ... View more

I agree that it is unclear what you need.    Below tip can help you to add multiple spaces      data _null_; put "START" 65*' ' "END"; run;     65* ' ' would insert 65 blank spaces between START and END ... View more

To be very specific how to create directory    I use following statement. Option dlcreatedir helps to create new directory if it is not present.    options dlcreatedir; libname temp "C:\users\New_folder"; libname temp;       ... View more

  1. When I have given advance certification, I had set target for every week and followed it religiously.    2. For me, number of hours do not matter, I identified which all topic I am good at and what all topics were new to me. For example, I was confident of proc sql so I didnt spend much time on proc sql related topics and devoted more time to macros and other topics.   3. Its difficult to say how many months would it require but read certification guide atleast two times.    ... View more

  Try to apply /order order= define Productivity / order order=internal analysis SUM 'Productivity' format=PERCENT10.1 missing STYLE={BACKGROUND=TRAFFIC_INDICATOR. just= center}; run; quit;   ... View more

  I have created a work dataset and comparing if any date is missing;   If date missing then give error message and abort. Data work.DATE_RANGE; format Event_dt date9.; do Event_dt = "&Week_Prompt_MIN."d TO "&Week_Prompt_MAX."d OUTPUT; end; RUN; proc sort data=work.SSW ; by Event_dt; run; Data Work.SSW; MERGE Cartel.preagent_telephony(IN=A) WORK.DATE_RANGE(IN=B); BY Event_dt ; Keep EVENT_DT PROGRAMME_NM SERVICE_NM CLUSTER CALLS_ANSWERED_CNT CALLS_ABANDONED_CNT TOTAL_ANSWER_TM MBL; Where Event_dt Between "&Week_Prompt_MIN."d and "&Week_Prompt_MAX."d and CALL_TYPE = 'External' and PROGRAMME_NM IN ("1.1 SSW"); IF B AND NOT A THEN DO; PUT "ERROR: DATE RANGE MISSING"; ABORT CANCEL; END; IF Cluster_ID in ('1' , '6', '9', '13', '18', '27') and Queue_Type IN ('A', 'B') THEN MBL = 'MBL'; ELSE MBL = 'Other'; Run;     ... View more

For the perspective of Advance certification, PROC SQL topics covers the most part of it.    In advance sas certification guide, there are only 4 chapters on macros that is what needed to clear the exam. These are well explained in the book.     ... View more