If you don't have SAS software licensed, you may try to integrate the following command-line tool and MIT-licensed C library into your C# code   Hope this helps, Ahmed ... View more

@naveenraj, Few things to keep in mind when comparing between SAS Client Applications 1. The back-end/compute SAS Workspace Server settings/configurations  2. The user id running the task/job be it in batch or interactive    Here is why! Depending on your SAS Multi-Tier installation, Knowing the following would help in isolating the reason - Do you have multiple SASApps configured (Multiple Compute Tiers)   - if Yes, are all share the same settings? - Did both of your SAS Client Apps (DIS & Studio) run using the same SASApp instance? - Did both of your SAS Client Apps (DIS & Studio) run under the same user ID?   Typically, the SAS Workspace Server instance would look for sasv9.cfg file under the current user home directory, and apply/use those settings.   I would recommend adding the following to the top of the SAS Code/Program and then repeat your execution scenarios PROC OPTIONS GROUP=PERFORMANCE; RUN; %macro loginfo; data _null_; temp=datetime(); temp2=lowcase(trim(left(put(temp,datetime16.)))); call symput('g_datetime', trim(temp2)); run; %put LOG HEADER BEGIN; %put LOG HEADER os=&sysscp; %put LOG HEADER os2=&sysscpl; %put LOG HEADER host=&g_computeHostName; %put LOG HEADER ver=&sysvlong; %put LOG HEADER date=&g_datetime; %put LOG HEADER parm=&sysparm; %put LOG HEADER END; %mend loginfo; %loginfo; The results of the above code snippet will update your log file with information that could help with your quest.   Hope this helps, Ahmed  ... View more

Hi @promo_at_work   If you are using SAS 9.4, you may want to use Proc DS2 to process your ~28 Million Rows data set in a Multi-threaded way. Here is how you can do it proc ds2; /* Declare a thread that would split the long delimited string into 700 variables */ thread splitter/overwrite=yes; dcl double y count; dcl bigint thisThread; dcl vararray varchar(10) var[1:700] var1-var700; drop count; method run(); set test; do i = LBOUND(var) to HBOUND(var); var[i]=scan(row,i,'|','m'); end; thisThread=_threadid_; count+1; end; method term(); put '**Thread' _threadid_ 'processed' count 'rows:'; end; endthread; run; /* Use 6 threads to process the large ~28 Million rows */ data split/overwrite=yes; dcl thread splitter st; method run(); set from st threads=6; end; enddata; run; quit;   Credits to @SASJedi for posting this blog Jedi SAS Tricks: Warp Speed DATA Steps with DS2   Hope this helps with speeding up your processing, Ahmed ... View more

Here is another Base SAS approach using the APP functions   data have; array ct [20] $1 _temporary_ ; /* Changing the size of the array elements, allows you to compare 2,3,.. digits */ call pokelong ("000112010302",addrlong(ct[1]),length("000112010302")); max=max(of ct{*}); put max=; run; Thanks, Ahmed ... View more