I have written the code to import the data from excel into the WORK libraray. Then looping trough each observation , i'm calling from the required macro. Thus passing values from excel cells to a SAS macro.   PROC IMPORT OUT= WORK.EXCELTABLE DATAFILE= "C:\file.xlsx" DBMS=xlsx REPLACE; SHEET="auto"; GETNAMES=YES; RUN; data want; set EXCELTABLE; array COL1 COL2 COL3 ; do over COL1; %<macro name>(COL1, COL2, COL3); end; drop COL1; run;   -Hope it helps. ... View more

in the case of missing values please have a look into, the place from which the column is getting imported from and applay the format at that level for avoiding any confusion.   SO at that level itself add:   input ( put (DateCol, Z8.) , yymmdd8.); ... View more

Hi BrianMc,   You can find your answer in the following link. http://support.sas.com/documentation/cdl/en/grstatproc/69716/HTML/default/viewer.htm#n0ka2y1m7pmaqdn1ijnwzp8jljoc.htm   -Let me know if it helps.     ... View more

hi R_Win,   You would like to base your decesion on the following.                                                                --> Do you have Enterprise Minner   or   SAS VA/VS   or   SAS EG                                                              --> The do you have hadoop integrated with SAS.                                                              --> What type of analysis are you looking to do in SAS. Is it reports with constant logic                                                                               and aggregation ? Or on the go analysis for various adhoc requests.   Based on the above if your request is consisting of adhoc request please don't go for the OLAP structure. But then again if it is having contant number which are bound to occour in the reporting system OLAP can be preffered.   Then if Hadoop is present the data processing capablity is already optimized. you will be able to process million of rows on the go.   Softwares such as SAS EM and SAS VA/VS is already integrated with high performance analytics. So you will not be worring about OLAP structure.   Still you are looking for performance on EG level you can use indexing it will require less time to implement OLAP on the longer run. To give a perspective 30 million rows can be sorted in 2mins with index applied, on the other hand it will take 12 min for the same without index.   To summarize the answer it OLTP has been working better for me.   -Hope it helps. ... View more

Can you eleaborate on the issue. Why you want weight By in ANOVA procedure ? ... View more

This should suffice.   data sample; input Values; datalines; 9.999 3.1245 919.0001 123.9999999 10 ; run; data sample; set sample; cc=(scan(Values,2,".")); if cc="" then count=0; else count=length(cc); drop cc; run; -Hope it Helps. ... View more

With SAS 9.4 you can apply for Base as well as advanced SAS Certification. If you are well versed with it go for Advanced Certification.   By  "Enterprise certificate" do you mean Enterprise Guide or Enterprise Minner. Different SAS Certification program signify differnt types of knowledge within SAS. For eg. Enterprise Guide certificate will not convey that you are a expert in Base SAS coding and vice versa.   So i would suggest to go for a sample test for both Advanced and judge you level. Then go ahead with the certification.       -- Hope this Helps.   ... View more

Can you expain the question ? ... View more

Yes, it is possible.   To execute the same on Enterprise Guide level. My team was able to do so. The frist thing that you need to check is that if all the PROC PROCEDURES are present in the EG or not. Usually in SAS EM the Procedures which are available inside EM is not made available in EG. So make sure you have it. To test the theory, you can export the score card when the decesion tree is in automatic mode. Make the required changes to the code and run the code in EG. Hope it works.     ... View more