About devi001

devi001

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!

devi001 · ‎11-01-2023

Thank you very much for both of your comments!! We are trying to create below node wise mapping of E-Miner nodes and its Viya alternative. Basis on your inputs, updated the same for Append, SOM/Kohonen and Partial Least Squares. Also could you please validate this list for nodes to which we found mapping in Viya and explain for some nodes there is not direct mapping available but can be done in another way in Viya, is it possible to share that information (procedure/steps) over here? Please Note - In below list, some nodes are in Magenta color is because we don't find it's direct Viya mapping but feature wise we feel that it could be alternative (we might be wrong in mapping some of those) E-Miner Node Viya node Append Not available Data Partition File Import Score Code Import Filter Filtering Input Data Merge Sample Association Cluster Clustering DMDB Graph Explorer Link Analysis Market Basket MultiPlot Path Analysis SOM/Kohonen Not available StatExplore Data Exploration Variable Clustering Variable Clustering Variable Selection Variable Selection Drop Impute Imputation Interactive Binning Transformations Principal Components Replacement Replacement Rules Builder Transform Variables Transformations AutoNeural Neural Network Decision Tree Decision Tree Dmine Regression Linear Regression DMNeural Ensemble Ensemble Gradient Boosting Gradient Boosting LARS MBR Model Import Neural Network Neural Network Partial Least Squares Not available Regression Linear Regression, Logistic Regression Rule Induction TwoStage Cutoff Decisions Model Comparison Score Score Data Segment Profile Segment Profile Control Point End Groups Ext Demo Metadata Open Source Integration Open Source Code Register Model Reporter SAS Code SAS Code SAS Viya Code Open Source Code Save Data Save Data (Data Mining & Machine Learning) Score Code Export Start Groups HP BN Classifier Bayesian Network HP Cluster HP Data Partition HP Explore Data Exploration HP Forest HP GLM GLM HP Impute Imputation HP Neural Neural Network HP Principal Component Feature Extraction HP Regression Linear Regression, Logistic Regression HP SVM Feature Extraction HP Text Miner Text Mining HP Transform Transformations HP Tree HP Variable Selection Variable Selection Incremental Response Survival Text Cluster Text Filter Filtering Text Import Text Parsing Text Mining Text Profile Text Rule Builder Text Topic Categories TS Correlation TS Data Preparation TS Decomposition TS Dimension Reduction TS Exponential Smoothing TS Similarity Thanks once again for your help!

devi001 · ‎10-26-2023

Hi All, We are doing comparison of SAS E-Miner projects to SAS Viya VDMML pipeline. We found that there is no node-to-node mapping available. Please refer attached snip for reference taken from Migration status document 2023.09. Can someone please tell us what will be alternative in Viya VDMML for these E-Miner nodes - Append, Data Partition, Principal Components etc (there are few more but listed down here limited nodes). If there is any mapping available? Thank in advance!!

devi001 · ‎09-11-2023

Hi All, In AML 7.1, we know that in fcf_agp.sas (location - ../SASFoundation/9.4/antimnycmn/ucmacros) all the macros are getting called and alerts are published on the triage page. On the similar lines, in AML 8.3, we found till prep codes fcf_aml_prep_vi_daily, fcf_aml_prep_vi_weekly etc (location - /SAS Content/Products/SAS Anti-Money Laundering/Jobs). We are not able to find any code or job post this that will execute AGP, or which macro will execute AGP in AML 8.3 and publish the alerts on Visual Investigator. Is there any sequence or flow that we need to follow to execute AGP in AML 8.3? Kindly assist. Thanks in advance!

devi001 · ‎07-05-2023

Hi Team, Please assist me on compatibility of VA reports built in VA 7.52 are compatible with VA 7.1 as well. Do we need to follow additional steps to make it compatible, please guide those steps. Thanks in advance!!

Online Status	Offline
Date Last Visited	Wednesday

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...

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...

Re: SAS Enterprise Miner projects to SAS Viya VDMML pipeline (node wis...

SAS Enterprise Miner projects to SAS Viya VDMML pipeline (node wise) c...

To run AGP in AML 8.3, what is the sequence of macros / sas programs

SAS VA 7.52 compatible in SAS VA 7.1