something like this   data med; set med; array country{13} Chile Cuba US UK Finland Germany SaudiArab Ethiopia  Botswana India  Australia China Japan ; do i = 1 to 13; if country{i} = "" then country{i} ="No" end; drop i; run; ... View more

I am not very sure, but from what I have read it, it implies first record as enetered in MS access. Personally I feel this is tough to emulate. for example , say there are multiple values of sales_distict_code  and  they are 123, 421, 223. The first functions picks up the first value entered in MS access and this could be anything as it depends on entry of that value in MS access. A min or max function will help you achieve similar results by picking one value but might not be same result as  in MS Access. I would try to use min or max function instead of first and then compare the results. Probably you may need to contact business user and ask, what is that he wants to see in output. ... View more

Something like this. What we are doing is making three groups. Anything mentioned in parentheis is group.1 st group is alphabets 2nd group is anything with 0 i.e. in midddle third group is from 0-9. We are replacing everything with last group that is third group mentioned as $3 data abc; input var $50.; datalines; ABC00000012365948952321 ABC00000000000948952321 ABC00000000025369214558 ABC000000000253692145580 ; data bde; set abc; var1 =prxchange('s/([A-Z]+)(0+)([0-9]+)/$3/i', -1, var); run; .  ... View more

you can do this by defining libname as shown below or by doing explicit pass through LIBNAME SQL ODBC DSN=’sql server’ user=sasjlb pw=pwd;   Below two papers will be to give lot of info on this https://support.sas.com/techsup/technote/ts765.pdf http://analytics.ncsu.edu/sesug/2002/DM10.pdf   ... View more

Rank over and others are known as Order analytical functions and  are not available in Proc SQL. But you can use proc sort and use first.variable concept to give rank data have; input id; datalines; 10 10 10 23 25 45 50 50 65 ; proc sort data = have; by id; run; data want; set have; by id; if first.id then rank =1; else rank+1; run; and then use first.ID to get the desired result in sas datastep   ... View more