About ANLYNG

ANLYNG · ‎09-08-2023

Hi, Has anyone tried upgrading Redhat from 7 to Redhat 8 in-place with Viya 3.5 installed? The easiest is to do in-place but will the Viya software/SAS run afterwards? Thanks in advance for all comments.

ANLYNG · ‎09-04-2023

Hi, We have a huge metadata respository SAS 9.4 (40 GB) and we have tried to use analyze/repair but no reduction in size. Could you share some code which makes is possible to see the size of the objects in out metadata repository. Thanks in advance.

ANLYNG · ‎04-25-2023

Hi all, We runs SAS 9.4 M6 server installation on LINUX. The server installation was hotfixed last month by SAS Institute. I was wondering if it is needed to hotfix the SAS clients (SMC, SAS DI, Enterprise Guide) as well ? We are planning to go to SAS 9.4 M8 later this year (octocber/november) and it could be nice if we could wait with the update of the clients. The clients was latest hotfixed October 2021. As far I know it is possible to run with newer (software release) clients on an older (software release) server. But it needs to be very controlled when we moved to M8 release from M6. Thanks for all inputs and ideas. Look forward to hear from you. Regards, Ann

ANLYNG · ‎05-19-2022

Thanks for your answer. The suggestion with intermediate datasets/steps in the SAS DI Job do you mean that it there should be outputted as a work table (and not create as view) ?

ANLYNG · ‎05-19-2022

Hi, When we execute our sas di flows we see a huge sas work usage (1 TB) even though we generally enable the "Create as View" option on transformation output ports in DI Studio? and in the end/table loader write output to SQL database. Our system has crashed several times because of insufficient space in work area. My question is why "create as view" seems to use a lot af SAS work space? what is best practice using "create as View" or options to effective write to a SQL database via Standard Table loader? What is best practice ? We are running 9.4 M6 on Linux Thanks in advance.

ANLYNG · ‎12-03-2021

Hi Community, we have large dataset processed via defined subflows in one flow in SAS Management console. We use SAS DI to define the deployed jobs. Sometimes the batch flow result in an error and stop processing because of memory exhaust. I was wondering if it would help if I scheduled only one flow at a time instead of one flow contaning 6 subflows? or is there a option where I can reset the memory use in the sas di jobs? Thanks in advance. I look forward to hear from you and the best practice for minimzing memory use during batch running via SAS SMC. Regards, Ann

ANLYNG · ‎10-14-2021

We need to transfer from Enterprise Guide/SAS code from local SAS/Linux server to a SFTP site. We want to recursive put files and directories from a folderpoint on linux to same structure below a folderpoint on a SFTP. How is that done most easily ? I prefer a command to execute from enterprise guide eg. OS Linux command by x command? Thanks in advance.

ANLYNG · ‎09-15-2021

How can I see the default sorting applied on out sas system. I use enterprise guide connected to a server. I can fine define a sortseq but when I want it back to default I do not know what default is. I checked the options and it is not set directly: SORTSEQ= Specifies a language-specific collating sequence for the SORT and SQL procedures. LOCALEDATA=SASLOCALE LOCALE=EN_US Specifies a set of attributes in a SAS session that reflect the language, local conventions, and culture for a geographical region. Thanks in advance.

ANLYNG · ‎07-30-2021

here is some of the log - hope the errtos can be avoided. I get however data out when I run it now. 211 /*---- Start of User Written Code ----*/ 212 213 data &_OUTPUT1.; 214 length 215 fref dref $8 216 fname $200 217 ; 218 rc = filename(dref,'/sas/config/compute/Lev1/SASLogs'); 219 did = dopen(dref); 220 if did 7 The SAS System 08:53 Friday, July 30, 2021 221 then do; 222 do i = 1 to dnum(did); 223 fname = dread(did,i); 224 rc = filename(fref,’/sas/config/compute/Lev1/SASLogs/' !! fname); 225 fid = fopen(fref); 226 if fid 227 then do; 228 size = finfo(fid,foptname(fid,6)); 229 modified = finfo(fid,foptname(fid,5)); 230 output; 231 rc = fclose(fid); 232 end; 233 rc = filename(fref); 234 end; 235 rc = dclose(did); 236 end; 237 rc = filename(dref); 238 keep fname size modified; 239 run; INFO: Character variables have defaulted to a length of 200 at the places given by: (Line):(Column). Truncation can result. 228:7 size 229:7 modified ERROR: Resource is write-locked by another user. File /sas/config/compute/Lev1/SASLogs/XXXX_2021.07.30_05.56.26.log. System Error Code = 11. ERROR: Resource is write-locked by another user. File =/sas/config/compute/Lev1/SASLogs/XXXX_2021.07.30_05.56.30.log. System Error Code = 11. ERROR: Resource is write-locked by another user. File =/sas/config/compute/Lev1/SASLogs/XXXX _2021.07.30_06.16. 25.log. System Error Code = 11.

ANLYNG · ‎07-29-2021

It is a nice solution. however it display an error with this message Code = 11. - ERROR: Resource is write-locked by another user. File ****System Error Code = 11. I thinks it has problems reading information for files which is in use. it is log files on a running system. is there an easy way to exclude the running files and display the rest?

ANLYNG · ‎07-28-2021

I need to a list of files in a specific directory with names and timestamps. I have the below code. But it only outputs filenames and not other wanted information eg. created or changed timestamp. Nice to have as well size of the files. data &_OUTPUT1.; length fref $8 fname $200; did = filename(fref,'/sas/data/Logs'); did = dopen(fref); do i = 1 to dnum(did); fname = dread(did,i); output; end; did = dclose(did); did = filename(fref); keep fname; run; Thanks in advance.

ANLYNG · ‎01-17-2021

I managed to get things working by including everything in one job. Thank you for your contribution.

ANLYNG · ‎01-16-2021

H

ANLYNG · ‎01-16-2021

The loop is in the outer job in sas di. The code above is from the inder job and has name parameters which should run it in a loop.

ANLYNG · ‎01-16-2021

Hi, I am trying to unzip a bundle of zip files in SAS DI/SAS 9.4. I use the name of files as input to the loop and below is my code for the job which should run in the loop. However it does not work. It Unzip the first file and the process do not stop and do not unzip the other files. So somehow the loop is not pushing forward from the first value of name. Can you help? Here is my code: options noxsync noxwait; data _null_; %put &name.; X """C:\Program Files\7-Zip\7z.exe"" e ""E:\SAS\Mydata\&name."" -oE:\SAS\MyData\Data\"; run;

Online Status	Offline
Date Last Visited	‎09-12-2023 06:32 AM

Opgrade OS in place with Viya 3.5

size of metadata objects sas 9.4

Hotfix server and/or sas clients

Re: SAS data Integration minimize ressource use

SAS data Integration minimize ressource use

Use subflow - SAS Management Console optimizing memory use

sas(linux) command code to put recursive and multiple files on an SFTP...

sortseq information server client

Re: List of files in a directory filename, timestamp, size

Re: List of files in a directory filename, timestamp, size

Re: Opgrade OS in place with Viya 3.5

Re: Opgrade OS in place with Viya 3.5

Re: size of metadata objects sas 9.4

Re: unzip files from SAS in a loop

Re: unzip files from SAS in a loop

Anti-virus exclusions recommendation Viya Windows

Re: Replace emty char variable with a text string

folder architecture and security -recommendations

Re: SAS visual analytics autoload data in subfolders

SAS visual analytics autoload data in subfolders

Opgrade OS in place with Viya 3.5

size of metadata objects sas 9.4

Hotfix server and/or sas clients

Re: SAS data Integration minimize ressource use

SAS data Integration minimize ressource use

Use subflow - SAS Management Console optimizing memory use

sas(linux) command code to put recursive and multiple files on an SFTP...

sortseq information server client

Re: List of files in a directory filename, timestamp, size

Re: List of files in a directory filename, timestamp, size

List of files in a directory filename, timestamp, size

Re: unzip files from SAS in a loop

Re: unzip files from SAS in a loop

Re: unzip files from SAS in a loop

unzip files from SAS in a loop