I'm pretty sure I do not understand your question. But, try looking at PROC STP, I think this is what you're describing? ... View more

data terms; input term : $8. @@; cards; poor bad low negative neg lw ; run; %let terms=&sysnobs; %put &=terms; proc transpose data=terms out=terms_array(drop=_name_) prefix=term; var term; run; data have; str='Lady shows poor judgement. Has good credit.'; output; str='Good Credit'; output; str='This guy has terrible credit!'; output; str='Poor credit'; output; run; data want; set terms_array; array term[&terms]; drop term:; do until (done); set have end=done; do _n_=1 to countw(str); flag=(whichc(lowcase(scan(str,_n_)),of term[*])>0); if flag>0 then leave; end; output; end; stop; run; ... View more

@rogerdeangelis, this is a vertical split. User wanted a horizontal split. I made the same mistake originally. However, as many have already commented, splitting this file at all makes little sense and there are numerous ways the OP can approach their actual problem without splitting. ... View more

filename xx temp; libname acrp xmlv2 "C:\temp\acrp.xml" automap=replace xmlmap=xx; Using the free Xml Mapper tool from SAS instead of the automap will probably suit you better   https://support.sas.com/downloads/package.htm?pid=1278 ... View more

%let lib=SASHELP; %let data=CARS; %let keys=MAKE MODEL; %let splits=3; %macro qlist(list,dlm=%str( )); (%unquote(%str(%")%qsysfunc(tranwrd(&list,%str( ),%str("&dlm")))%str(%"))) %mend; data _null_; call streaminit(23463); array v[&splits] $ 32767 _temporary_; do until (done); set sashelp.vcolumn end=done; where libname="%upcase(&lib)" and memname="%upcase(&data)" and upcase(name) not in %qlist(&keys); i=(ceil(&splits * rand('uniform'))); v[i] = catx(' ', v[i], name); end; do i=1 to &splits; call execute('data ' || cats("&data",i) || ';' || "set &lib..&data (keep=&keys " || strip(v[i]) || ');' || 'run;'); call symputx(cats('keep',i),v[i]); end; run; ... View more

Sorry, I missed that. You should sort using tagsort if you are running out of space. https://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000146878.htm ... View more

https://gist.github.com/FriedEgg/79ad315afa1b315e8ac3#file-hmacsha1-sas ... View more

It's scientific notation, 1e6=1000000 In scientific notation, the number before the E is multiplied by the power of ten that is indicated by the number after the E. For example, 2E4 is the same as 2x104 or 20,000. For numeric constants larger than (1032 )-1, you must use scientific notation. Additional examples follow: http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000780334.htm ... View more

http://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/ ... View more

The most likely answer is simply that you are not using the correct name for the class in your import statement.  Versions are important and you are using version 3.8 of opencsv, whereas the code you copied was using version 2.3.  During the time between these versions the package name was changed making the class name you are looking for in the version 3.8 Jar file "com.opencsv.CSVWriter" ... View more