Hi sandip, Check this link...it describes step by step.... http://support.sas.com/techsup/technote/ts714.pdf Thanks, Shiva ... View more

Hi, In extract transformation , where clause you can mention like this... StartDate <= &last_updated < EndDate and you can pass the last_updated date value in pre code(as this would be changing as per your requirement). Thanks, Shiva ... View more

Hi, It would have been helpful if you have showed the error message screen shot or log errors. Work around would be to restart your services in proper order and check your web applications open properly. Only E miner is having problem or all other web applications are having the same problem. Thanks, Shiva ... View more

Hi, I guess you might have not registered the out=&output dataset in metadata...try registering the output dataset. Thanks, Shiva ... View more

Hi, Once you can create library in SAS MC and register the tables then users can see those tables in SAS EG/Eminer(if the user have proper credentials to that library). In EG it would be in SASAPP->library->librarynames In Eminer when you create a source data then you need to metadata table to access the data from library or in project start up code they can directly mention the libref and path using simple libname statement. If you are creating the library other than BASE SAS (for eg oracle library then you need to create the user and oracle server to access that library) Thanks, Shiva ... View more

Hi sunil, Try this.. data x1; input num id $ name $; datalines4; 1 id1 name1 2 id2 name2 3 id1 ee ;;;; run; proc sort data=x1 nodupkey noequals;by id ;run; Thanks, Shiva ... View more

Hi, Check this link.. http://www.zencos.com/2012/04/column-level-security-for-web-reports/ Thanks, Shiva ... View more

Hi, initialdt = &Load_Dt.; change this to and try... initialdt = "&Load_Dt"d; Thanks, Shiva ... View more

Hi, How about using third party tools like...winscp or filezilla to trasfer the files from one server to other. Thanks, Shiva ... View more

Hi, Try this link... http://sascodeblog.wordpress.com/read-in-an-excel-sheet-in-sas-data-integration-studio-4-2/ Thanks, Shiva ... View more

Hi, You can try this code...not tested in DI... %let dd=%sysfunc(weekday(%sysfunc(today(),DDMMYY10))); %put &dd; options minoperator; %macro test/mindelimiter=','; %if &dd in 3,4,5,6 %then %do; data want; set &syslast; where date between "&sysdate"d-3 and "&sysdate"d-1 ; run; %end; %else %if &dd =2 %then %do; data want; set &Syslast; where date between "&sysdate"d and "&sysdate"d-1 ; run; %end; %mend test; %test; Thanks, Shiva ... View more

Hi, Check this link http://support.sas.com/documentation/installcenter/93/index.html http://support.sas.com/documentation/installcenter/en/ikdeploywizug/64204/PDF/default/user.pdf What exactly you want to install.if it is just Base sas then setup.exe ->sas Foundation will suffice your requirement,but if you want to install sas EBI then you require third party tools as well. If you want to install any product specific to you site(which in not covered in standard deployment then you need to raise a request to Sas support for PLAN file depending upon you requirement.) Thanks, Shiva ... View more