Hello ,   How could i find dependency/importance/weightage between Dependent variables in SAS? Example: Var1 Var2 Result 1      2          5 3     2          7   in the above example weigtage of var2 is higher because the formala is result=var1+2var2   Thanks, Mushy ... View more

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