Hello,   I am updating huge table using update statement in proc sql. Its taking very long time. I need to just blank/null few char/num fields in the tables based of the dataset that provides the fields to be blanked.  Is there an efficient way to deal with this?   Thanks, Mushy ... View more

Hello,   I have recieved three certificates root, intermediate and the server certificate to apply in the Linux server. How do i verify the validity/correctness of the existing certificate, before applying new certificates?   Thanks, Mushy ... View more

Hello All, I am using the below logic to update the fact table, but I am losing index... do we have a method where we repace the required rows and also retain index..?   data fact; if 0 then set dim fact; if _n_=1 then do; declare hash h1(dataset:'dim(where=( roll=1))'); h1.definekey('roll','roll1'); h1.definedata(all:'yes'); h1.definedone(); end; set fact; if roll<3 then do; if h1.find()=0 then h1.replace(); end; run;   Thanks, Mushy   ... View more

Hello,   Is there a way to import and export xlsm(macro enables) workbooks without the pc server?   Thanks, Mushy ... View more

Hi All, I have an issue where I am trying to export a dataset from EG to the sas server to access databse using export procedure. PROC EXPORT DATA=cars OUTTABLE='Acces' DBMS=ACCESSCS REPLACE; DATABASE='ss.accdb'; RUN; I get the following error: ERROR: Server Name is invalid or missing. Note that I have logged in to SAS server and executing the sas program.. so i dont need to  sepecify server details in proc export statement. also I have the license for sas/access interface to PC files could you help me fix the issue.   Thanks, Mushy ... View more

Hello,   I have an Oracle library where I have 2 tables. I use those tables in DI jobs. The same tables are now in sas server as sas datasets. Is it possible to change the library definition of the Oracle lib to point to sas datasets? Mushy ... View more