Again, it is really the time for you to contact SAS sale reps or tech support directly. Like @LinusH suggested, without a in-depth onsite analysis, there is no way to tell for sure which license you will really need. Also, keep one thing in mind, saving too much right now may cost you more down the road, you will need to factor in the the future growth of your institution in the big equation.   Here is my impression and wild assumptions: 1. Most likely you will  need SAS integration technology regardless your Java implementation. From my past deployment experience, without it, many clients will be stop working, sometimes include EG. I am not sure about Framework data server without the knowledge of your system, but often when they are listed separately in term of license, they are actually bundled in term of functionality. 2. "should we opt for SAS Workspace Server for Enterprise Access".  That was what we did in the past to save cost. It would be a double investment if you have the server license and pc license at the same time. However, we still keep couple of pc license running for the following reason: 1. The data is highly sensitive that you don't want it processed on a remote server. 2. You pc SAS has more product licence than your server version, but only a few people will use the additional license (in our case it is the SAS/OR and some). 3. In the case of catastrophic event (network/server down), you still maintain certain analytic capacity. ... View more

If your data came in as numeric as you presented:   data main; input sample; cards; 23 24 25 26.7 28 28.1 28.2 28.3 ; run; data want; set main; length result $ 10; z=sample=int(sample); result=ifc(z=1,'success', 'no success'); run;   ... View more

Here are some sample code based on your data. data sat; input client $; datalines; 531 620 531 908 143 run; data main; input keys $; datalines; 530 620 532 909 620 142 run; data _null_; if _n_=1 then do; dcl hash sat(dataset:'work.sat(keep=client)', multidata:'y'); sat.definekey('client'); sat.definedone(); length client $ 3; dcl hash uni(); uni.definekey('keys'); uni.definedone(); end; set main end=last; if sat.check(key:keys)=0 then do; rc=uni.check(); if rc ne 0 then do; unique+1; rc=uni.add(); end; duplicate+1; end; if last then do; call symputx('dupcnt',duplicate); call symputx('nondupcnt',unique); end; run; %Put Total Matched count: &dupcnt.; %Put Total Matched Distinct count: &nondupcnt.; Notice that I have used "Total Matched count" and "Total Matched Distinct count" at the final output. Dup or nondup is a bit confusing. Good Luck and Happy Learning!    ... View more

data have; input name:$10. Num_Chances; cards; Carmen 5 Sue 2 Jack 3 John 1 ; data want; set have; do _n_=1 to num_chances; output; end; keep name; run; ... View more