Hi, i am trying to connect to Hortonworks using SAS/Access for Hadoop. I compared the jar files and they look good (versions slightly different as they were provided by the Hadoop admin). I am able to get a kilist from the SAS Client machine (server) and even ssh to the nodes. But when i run a libname from SAS EG, i am getting this:   libname zhdplib hadoop subprotocol='hive2' server='myserver' schema=myschema user='user123' pwd='test123';   ERROR: Unable to connect to the Hive server. ERROR: Error trying to establish connection. ERROR: Error in the LIBNAME statement.     thanks,  Alex ... View more

Naveen, Thanks a lot Naveen for your prompt and favorable guidance but my question is, having good knowledge is not enough to get an employment? I left my last job which was in a BPO(of 4yrs) just getting better sas skills and that is why I am trying for it by any means. In fact I have no issue in getting an employment as a fresher. I very well know that the way I have chosen is not correct but I am not left with any other way. If you may do something for me so plz reply me on rahul654k@gmail.com Patrick, Thanks a lot Patrick you as well for your valuable time. I would prefer your way to achieve the goal. I never lie neither in professional life or in personal life and was feeling awkward showing this fake experience in my resume. Most often I keep things transparent to everyone and that is why I shared it on this forum. I do have 4 years of BPO experience(in health Insurance and Telecom) but it wasn't working anymore and didn't find the better life as well so I decided to change the profile and did SAS. I would say that I am confident enough to answer most of the technical question except the ones are relate to the project only. I will try your suggestion also as I will feel more comfortable. All I need is a CHANCE. Once I get this opportunity, will never look back. If any of you wants to help me please advise me on rahul654k@gmail.com Thanks & Regards Rahul ... View more

You can do that..but if you do SAS won't be able to pass the query to Oracle for execution.  SAS would then pull all of the necessary information down locally to decide if a row met the datepart criteria.  ... View more

The proc sort and data step worked great.  I couldn't get the proc sql to work due to the other variables having distinct data. The proc sort and data set ignores all other columns and only looks at the field placed after the FIRST. CLAIMNUMBER, SUBCLM, SEQNUM, BEGSERVICEDATE, PROVNUM, PROVLOC, FACILITYNAME, FFSORCAPIND, CLAIMSTATUS, PAYMENTSTATUS ... View more

Hi, It rather looks much too simple and so I'm afraid perhaps my understanding could be wrong somewhere wrong. Is this what you really want? data rand; call streaminit(-1); do j=1 to 2000; /*modified here*/ do i = 1 to 100;    x = rand("Normal")*5+1; output; end; end; drop i; /*modified here*/ run; Proc sql; Create table Rand_means as Select j, mean(x) as A1 from rand group by j; quit; Please correct my understanding. Thanks. Merry Christmas, Naveen ... View more

Yes, it is there to rule out other possibilities.  In your initial question, you asked to use "previous year" in case of no-match. Consider the following slightly modified data, run the code with and without the additional condition. Data _2; input Firm$ Year RepMeasure; cards; 1004 1995 0.36 1004 1996 0.42 1160 1995 0.11 1160 1997 100 1235 1995 0.78 1235 1996 0.69 ; Haikuo ... View more