Hello SAS Community,   I am trying to read a number of .txt files into SAS. I am enclosing a sample of my data and a screenshot how the data end up in SAS. This is the code that I have used:   libname lib 'E:\LSE_Tick1'; %let dirname = E:\LSE_Tick1; filename DIRLIST pipe "dir /B &dirname\*.txt"; data dirlist ; length fname $256; infile dirlist length=reclen ; input fname $varying256. reclen ; run; data lib.LSE_tick (drop=fname); length myfilename $100; set dirlist; filepath = "&dirname\"||fname; infile dummy filevar = filepath length=reclen end=done DSD dlm= ' ' TRUNCOVER firstobs=3; do while(not done); myfilename = filepath; length TICode $12 TIDM $3 IssuerName $30 Cy $2 Cur $3 Segm $4 Sect $4 TT $2 I $1 TradeCode $10 SEDOL $7 P $1; informat PublTstmp CancTstmp TradeTstmp datetime. ; do until (done); input TICode TIDM IssuerName Cy Cur Segm Sect PublTstmp CancTstmp TradeTstmp TradeSize TradePrice TT I TradeCode SEDOL P; output; end; end; drop myfilename; run; After running the code, a list of error messages saying Invalid data for ...  in line ... on the log window.   I look forward to your suggestions and thanks in advance!   Best.   ... View more

Hello everyone,   I have a very wide dataset with 229 variables.  I am trying to change thoese variables' names into an enumerated sequence such that my final result will look like so: sq_1 sq_2 sq_3.... sq_227.   I tried this macro but it failed: %macro rename(lib,dsn,newname); proc contents data=&lib..&dsn; title 'before renaming'; run; proc sql noprint; %rename(WORK,call_qs1); from dictionary.tables where libname="&LIB" and memname="&DSN"; select distinct(name) into :var1-:var%trim(%left(&num_vars)) from dictionary.columns where libname="&LIB" and memname="&DSN"; quit; run; proc datasets library = &LIB; modify &DSN; rename %do i = 1 %to &num_vars.; &&var&i = &sq._&i. %end; ; quit; run; proc contents data=&lib..&dsn.; title 'after renaming'; run; %mend rename; %rename(WORK,call_qs1,call_qs2);     As always, Thank you for your help.   ... View more

Hello everyone, I am trying to run this code: proc logistic descending data = dir.liseuro_d; model treat = cap /lackfit outroc = ps_r; output out= ps_p XBETA=ps_xb STDXBETA= ps_sdxb PREDICTED = ps_pred; run; But I get back an error message about Java. I reinstalled Java but it's still not working. I have SAS 9.3 (32) ERROR: The Java proxy is not responding. ERROR: The Java proxy's JNI call to start the VM failed. ERROR: Unable to load the Java Virtual Machine. Please see the installation instructions or        system administrator. ERROR: Unable to load the Java Virtual Machine. Please see the installation instructions or        system administrator. Here are the details of Java: 12   proc options option=jreoptions; 13   run; SAS (r) Proprietary Software Release 9.3  TS1M2 JREOPTIONS=(             -DPFS_TEMPLATE=C:\Program Files\SASHome\x86\SASFoundation\9.3\tkjava\sasmisc\qrpfstpt.xml -Djava.class.path=C:\PROGRA~1\SASHome\SASVER~1\eclipse\plugins\SASLAU~1.JAR -Djava.security.auth.login.config=C:\Program Files\SASHome\x86\SASFoundation\9.3\tkjava\sasmisc\sas.login.config -Djava.security.policy=C:\Program Files\SASHome\x86\SASFoundation\9.3\tkjava\sasmisc\sas.policy -Djava.system.class.loader=com.sas.app.AppClassLoader -Dlog4j.configuration=file:/C:/Program%20Files/SASHome/x86/SASFoundation/9.3/tkjava/sasmisc/sas .log4j.properties -Dsas.app.class.path=C:\PROGRA~1\SASHome\SASVER~1\eclipse\plugins\tkjava.jar -Dsas.ext.config=C:\Program Files\SASHome\x86\SASFoundation\9.3\tkjava\sasmisc\sas.java.ext.config -Dsas.jre.libjvm=C:\PROGRA~2\Java\JRE16~1.0_2\bin\client\jvm.dll -Dtkj.app.launch.config=C:\PROGRA~1\SASHome\SASVER~1\picklist          -Xms128m -Xmx128m           )                    Java Runtime Environment options Any idea how to fix it?? As always, thank you very much. ... View more