If you are trying to improve the performance of read queries then you could try the READBUFF option which can be set as high as 32767 (32K). You will need to experiment with different values to see what works best, if it has any impact at all. ... View more

That doesn't look like the type of command that would actually return anything, but perhaps you can try using the TABLE() function to convert what it does return into something that looks like a table you can query? select * from connection to oracle ( select * from table( dbms_stats.gather_table_stats('user', 'mytable', degree => 15) ) ); ... View more

That means your pie chart and summary table tasks are using a format other than SAS Report.  (Custom reports can only use results in the SAS Report format.)  For example, perhaps they are using HTML instead, or another format.  You can check which results formats you are using by default by looking in Tools->Options->Results->Results General->Results Formats.  If you want to create custom reports, check the "SAS Report" results format.  Or, rather than setting this global option (which will affect all items), you can set on an individual item by right-clicking the task, select Properties->Results->"Customize result formats, styles, and behavior", then check SAS Report, and re-run.   Casey ... View more

If CEDA (cross environment data access) is invoked, it is automatic. You do not have to specify it.   To know whether CEDA is invoked, check the SAS log.   Depending on what features you need, CEDA access might be sufficient. It has some restrictions. For example, indexes are not used, and update processing is not supported. See the CEDA documentation. ... View more

Hi @GeorgeSAS    A call direct to sas.exe would give you a "raw" SAS without the -config or autoexec settings defined in the EG workspace server, so you will be on your own and have to include these informations in your call. Using sasbatch.sh might not be a good idea either, as it might be modified for daily batch processing.   So talk to your administrator. It seems that she has a relaxed approach to server operation, since you have terminal access to the server and not only FTP, and she might be willing to tailor a special command for you.   If I was your administrator and you came with convincing reasons, I would make a userbatch.sh file using a setup similar to that found in the SAS EG environment, and set it to write -log and -lst files to the same directory as the -sysin file. Then you could just call the command with your program as argument. I would use nohup, so the job would continue when you signed out from your terminal session, and I might add a -termstmt macro to send a SMS to a number supplied as second argument to the command and passed as -sysparm, when the job is complete.   ... View more

@GeorgeSAS wrote: This is for recent files in the same SAS session.   If I open a new SAS session that will lost.   What I am looking for is even after my pc was started, when I open a new SAS base console, I can still find my recent opened more than 12 SAS programs I opened recently.   Thanks! If that did not work then you likely do not have the Preference set to Save preferences on closing. Tools>options>preferences on the General tab if the "Save Settings on exit" is not marked then none of your changes are kept.   Since I have maintained a 25+ file list for the last 5 or 6 SAS releases this does keep the settings across sessions IF you have the appropriate option to save the settings. ... View more

Hi @GeorgeSAS - the Matplotlib library isn't available in the SAS University Edition of JupyterLab nor can you install it yourself. I understand the thinking is that saspy contains enough graphing and charting facilities for most peoples needs.   If you want to see what modules are available enter the following code in a cell and run it.   help('modules') ... View more

I suggest you search through the Community posts using the keyword python. If you do you will find posts like this which may be helpful: https://communities.sas.com/t5/SAS-Procedures/Python/m-p/346640#M63567     ... View more

----To summarize all the great solutions,   /*1 filename extrnal file*/ filename raw01 "c:\test\raw01.txt" lrecl=1024 ; filename raw01 " 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05"; data rawread; infile raw01 ; input (id loc1 loc2 xxm trr x1-x20 y m1-m20 ) ( $ 4-9 $ 21-22 $ 29-30 $ 146-149 @ 163 f2.0 @165 $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. @ 341 f2.0 @344 20 * $ 5.) ; run; /*2 in stream*/ data rawread; input (id loc1 loc2 xxm trr x1-x20 y m1-m20 ) ( $ 4-9 $ 21-22 $ 29-30 $ 146-149 @ 163 f2.0 @165 $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. $ 7. @ 341 f2.0 @344 20 * $ 5.) ; datalines; 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05 ; run; /*3 filename tempfilename mydata temp;*/ data _null_; file mydata ; *put ' 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05'; put ' 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05'; run; filename mydata temp3; data _null_; file mydata ; *put ' 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05'; put ' 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05'; run;*/ data rawread003; infile mydata; input id $ 4-9 loc1 $ 21-22 loc2 $ 29-30 xxm $ 146-149 trr 163-164 @165 (x1-x20) ($7.) y 341-342 @344 (m1-m20) ($5.) ; run; /*4. pipe on pc*/ filename txt_pc pipe 'echo 0000001 11CA001CA0CAUSCA0010600031CA57750184NYUSNY 410102F1091 442411 1W609221911012020042003U UND 1 K743300 095 3090311R092 21J189 61K743 03 J189 K743 R092 101 11100 100 6YNNNNNNNNNNNNNN NNNN 05' lrecl=2048; data want; infile txt_pc; input id $ 4-9 loc1 $ 21-22 loc2 $ 29-30 xxm $ 146-149 trr 163-164 @165 (x1-x20) ($7.) y 341-342 @344 (m1-m20) ($5.) ; run;   .....to be updated... ... View more