About devi001

devi001 · ‎03-06-2025

Hello everyone, We have created workflow in Sas viya & executed the same. After successful completion of the workflow we want to download the Instances report along with its values in either PDF / CSV. Kindly assist on how to avail this functionality if it's there. Thanks in advance!

devi001 · ‎01-08-2025

Hello everyone, We are trying to read the table having one variable type as clob into SAS but the length is truncating. We want to create a table from Oracle to sas work library. Tried below options but didn't work : 1. Used pass through facility & created new table in Oracle. Changed the CLOB type to VARCHAR 2. Data step with new column creation & reading CLOB variable to it Data test; Length remarks1 $4000.; Set oradb.tbl; Remarks1 = remarks; Run; 3. Trying to print the Oracle table in sas, however remarks column is truncated. Proc print data= orada.tbl; run; We found one option dbmax_text to use in libname statement. But will that work while creating the table in sas work library? Please suggest the solution so that we can create the table in sas work library & able to read clob variable without truncation. Thanks in advance!

devi001 · ‎01-03-2025

Hi everyone, We have one table obtained from Sas model manager scoring section, which is in CAS PUBLIC library. We want to bring the same in work library. While executing data step, getting below error Error: The SAS system stopped processing this step because of insufficient memory. We have tried below options : 1. Selecting only 2 relevant columns 2. Reduced variable length Please note : Splitting of table is not possible as it will impact further processing. Kindly suggest. Thanks in advance

devi001 · ‎01-03-2025

Hi everyone, We have one table obtained from Sas model manager scoring section, which is in CAS PUBLIC library. We want to bring the same in work library. While executing data step, getting below error Error: The SAS system stopped processing this step because of insufficient memory. We have tried below options : 1. Selecting only 2 relevant columns 2. Reduced variable length Please note : Splitting of table is not possible as it will impact further processing. Kindly suggest. Thanks in advance!

devi001 · ‎09-23-2024

Hello everyone, In SAS Viya 4 model manager, while generating a scoring table, the default table name is too big (more than 32 characters length )can we rename the default table name? Or any suggestions to shorten the default table name? We are facing as issue while reusing the same in SAS VIYA such as to in set statement while creating the table in work library. Kindly help! Thanks in advance!

devi001 · ‎08-28-2024

Hello, We are trying to use the DQLOAD macro in the default 'Identify Gender' snippet within SAS Viya. However we get the below error. Is this because DQLOAD requires additional parameters as input such as the QKB location? In this case how do we identify the QKB location in our SAS Viya Environment? Code: %dqload(dqlocale=(ENUSA)); Data _null_; Length name$100; Length gender $20; Name='Mrs. Sallie Mae Pavlik' Gender=dqgender(name,'Name','ENUSA'); PUT GENDER; run; Log: NOTE: DQLOAD macro beginning WORK "SASGOPT ERROR: ERROR in the FILENAME statement NOTE: DQLOAD macro ending Thanks in advance!

devi001 · ‎03-28-2024

Hello Everyone, We wanted to migrate SAS 9.4M6 on prem deployed jobs to AWS Cloud environment. Kindly guide us on the migration steps. Is that same import & export of .spk files which we do normally? OR any other special things / mapping needs to incorporate while migrating to AWS Cloud environment? Thanks in advance!

devi001 · ‎03-22-2024

Hi All, We want to execute SAS Content Assessment (2024.02)version on windows environment "Network shared paths". We have tried to execute profiling application on one of the Network shared path but getting an error as "Obtaining SAS Metadata repository information : FAILED ". Kindly help in guiding on execution of SAS Content Assessment on windows network shared paths. Thanks in advance!

devi001 · ‎03-13-2024

Hi All, We have executed the summarizelogs application in Windows environment and used latest version of SAS Content Assessment (2024.02). This application assesses workspace server logs. In our case, we have very old logs (from 2010 & older) and large in size, so the final dataset has been generated in datamart folder is very huge in size. Is there any way or workaround to this so that while executing this application, we can limit the number of logs based on date. Please assist. Thanks in advance!

devi001 · ‎03-06-2024

Hi All, We installed latest version of SAS Content Assessment (2024.02) on the client's Windows environment, all applications executed successfully on metadata server. Getting an error for "SAS 9 Application Usage" in Workspace server while assessing ObjectSpawner logs. Error - Specified log config directory does not appear to contain accessible Object Spawner logconfig.xml file. We observed that folder name for Object Spawner is renamed in the environment. Does this impact execution of SAS 9 Application usage? Please assist in resolving this error so that we can execute SAS 9 Application usage exe successfully. Thanks in advance!

devi001 · ‎02-16-2024

Yes, its resolved few months ago. Apologies couldn't post the solution in time. Below steps worked in our case - During CLI set-up, we need to create profile by executing "./sas-viya profile init". In Service Endpoint option, we need to pass the value contains "https://...sas.com". Here we were passing incorrect values. (Although, passing incorrect values, profile was created successfully and was accepting the token so please check this step while creating service endpoint profile. ) Thanks!!

devi001 · ‎02-13-2024

One addition is we want to migrate SAS Datasets as well to AWS cloud. Is there any encoding difference which needs to be considered post migration? Thanks!

devi001 · ‎02-13-2024

Hello, We want to migrate artefacts from SAS9.4M6 to SAS9.4M8 AWS cloud based environment which include SAS Programs, EG Projects, E-Miner projects, Scheduled DI Jobs etc. Is there any restrictions / no compatibility with any SAS Step or procedure to AWS cloud env, can someone please assist on this? We got this link - https://docs.aws.amazon.com/prescriptive-guidance/latest/migration-sas-grid/welcome.html but it is for SAS Grid. Thanks in advance!!

devi001 · ‎11-23-2023

Hello everyone, We are importing SAS 9.4 EG projects in SAS Viya using CLI method as we want to import multiple EGP files at a time (bulk import). We have installed latest CLI version(1.21.23), created profile, profile authenticated successfully (Trusted CA certificates validation) and installed all the plug-ins. For transfer plug-in, used force option to update the same. Used below reference links. For CLI set up - https://documentation.sas.com/doc/en/sasadmincdc/v_046/calcli/n1e2dehluji7jon1gk69yggc6i28.htm For import EG project - https://communities.sas.com/t5/SAS-Communities-Library/Go-with-the-flow-migrating-Enterprise-Guide-Projects-to-SAS/ta-p/743627 We have executed below command (this is using folder path method as we have placed SAS 9.4 egp files at one location in Viya env and path is specified in --source-location option) in SAS Viya environment : - ./importEGProjects --sas-viya-path "/home/sasdemo/SASContentAssessment/sas-viya" --source-location "/home/sasdemo/SASContentAssessment/" Getting an error as import FAILED. The error that we are getting in the log is as follows : ---partial log start--- 2023/11/22 06:56:14.660502 cli.go:54: Executing: /home/sasdemo/SASContentAssessment/sas-viya transfer 2023/11/22 06:56:14.853180 main.go:304: The required plugin, transfer, is installed. 2023/11/22 06:56:14.853220 cli.go:54: Executing: /home/sasdemo/SASContentAssessment/sas-viya transfer --version 2023/11/22 06:56:15.038999 semver.go:47: The version of sas-transfer is 1.22.41 2023/11/22 06:56:15.039034 main.go:355: Validating the specified settings: SUCCESS 2023/11/22 06:56:15.039046 main.go:358: Command-line options in use: 2023/11/22 06:56:15.039056 main.go:359: Creating a profile for this SAS Enterprise Guide projects: false 2023/11/22 06:56:15.039066 main.go:360: Root folder for this SAS Enterprise Guide projects import: ConvertedEGProjects 2023/11/22 06:56:15.039076 main.go:361: Source file for this SAS Enterprise Guide projects import: 2023/11/22 06:56:15.039085 main.go:362: Source location for this SAS Enterprise Guide projects import: /home/sasdemo/SASContentAssessment/ 2023/11/22 06:56:15.039099 main.go:560: Enumerating SAS Enterprise Guide projects to import. 2023/11/22 06:56:15.039116 main.go:598: Processing the source location /home/sasdemo/SASContentAssessment/ to determine which SAS Enterprise Guide projects to import 2023/11/22 06:56:15.041362 main.go:607: Processed 5 SAS Enterprise Projects 2023/11/22 06:56:15.041393 main.go:622: Importing the specified SAS Enterprise Guide projects. 2023/11/22 06:56:15.041412 main.go:637: Processing 1 of 5 SAS Enterprise Guide project(s): /home/sasdemo/SASContentAssessment/EGModels 1.egp 2023/11/22 06:56:15.041437 cli.go:54: Executing: /home/sasdemo/SASContentAssessment/sas-viya transfer --quiet upload --file /home/sasdemo/SASContentAssessment/EGModels 1.egp 2023/11/22 06:56:15.265145 main.go:723: The project was uploaded successfully with the ID: 2023/11/22 06:56:15.265219 cli.go:54: Executing: /home/sasdemo/SASContentAssessment/sas-viya transfer --quiet import --id --f :SKIP_VALIDATION:/ConvertedEGProjects/home/sasdemo/SASContentAssessment 2023/11/22 06:56:15.537759 main.go:738: The project failed to import 2023/11/22 06:56:15.537819 cli.go:54: Executing: /home/sasdemo/SASContentAssessment/sas-viya transfer --yes-to-all delete --id 2023/11/22 06:56:15.898952 main.go:756: No package with the URI "/transfer/packages/" was found. ---partial log end--- Kindly assist in resolving this error. Thanks in advance!

devi001 · ‎11-14-2023

Hi All, We are trying to compare results generated in SAS Forecast Studio 15.3 & SAS Viya Model Studio. We have observed that in Forecast Studio, Fit Statistic is MAPE where as in Viya Model Studio it is WMAPE. Please refer to the attached snapshots in the document. Kindly assist on which Fit statistic we have to consider post migrating projects of SAS Forecast Studio 15.3 to SAS Viya Model Studio in order to maintain same accuracy in both Forecast studio and Viya Model Manager. Please Note - Source dataset used in both projects is same which is SASHELP.PRICEDATA. Thanks in advance!

Online Status	Offline
Date Last Visited	‎06-09-2025 07:58 AM

Sas viya Workflow Manager - how to download instances report

Unable to read full variable (CLOB type) from Oracle to Sas

Error: The SAS system stopped processing this step because of insuffic...

Error: the sas system stopped processing this step because of insuffic...

Sas Viya model scoring table

Sas viya 4 default snippet DQLOAD macro error

How to migrate SAS 9.4 on prem deployed Jobs to AWS Cloud

how to execute SAS Content Assessment on network shared path

SAS Content Assessment - summarizelogs application

SAS Content Assessment : SAS 9 Application usage - Failure

Sas viya Workflow Manager - how to download instances report

Unable to read full variable (CLOB type) from Oracle to Sas

Error: The SAS system stopped processing this step because of insuffic...

Error: the sas system stopped processing this step because of insuffic...

Sas Viya model scoring table

Sas viya 4 default snippet DQLOAD macro error

How to migrate SAS 9.4 on prem deployed Jobs to AWS Cloud

how to execute SAS Content Assessment on network shared path

SAS Content Assessment - summarizelogs application

SAS Content Assessment : SAS 9 Application usage - Failure

Re: Getting an error while bulk import EG projects in SAS Viya using C...

Re: SAS Programs Compatibility on AWS cloud env

SAS Programs Compatibility on AWS cloud env

Getting an error while bulk import EG projects in SAS Viya using CLI m...

Results comparison between SAS Forecast Studio 15.3 and SAS Viya Model...