If you got your dataframe result to a SAS dataset, you can formats to the columns you need to have a specified numger of decimals: proc datasets lib=library-name; modify sas-dataset-name; format variable-name 22.16; run; quit; ... View more

You could try using OR in the join criteria. You might end up with duplicates that way, but I know too little of your data to give more specific advice. Is it possible to post test data as datalines in a data step? ... View more

SCAN function works for this kind of scenarios: SAS Help Center: SCAN Function ... View more

My SAS FIles is a folder in the Metadata server, and is set-up by default for each metadata user. It has nothing to do with SASUSER. The purpose is to have a playpen for you to store SAS content for your own needs, like testing/development. Typical object to store here could be Stored Processes, EG projects etc. ... View more

You mean running in batch vs running inside DI Studio application? Please share logs. ... View more

Gotcha, no, I can't explain that. Another way to see statements executed in a target dbms is to: options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; Unfortenately this doesn't work for my OLEDB engine with DELETE, but perhaps it works better for you? 51 proc sql; 52 delete from oeldb.table 53 where id = 5254; SAS_SQL: Unable to convert the query to a DBMS specific SQL statement due to an error.   ... View more

From the documentation: "The FEEDBACK option expands a SELECT * statement into a list of columns that the statement represents." ... View more

I think that SQLOBS reacts to the no of records from the select statment. Have you tried SQLXOBS (still undocumented ASFAIK)? ... View more

Oh, I thought your comparison with PC SAS meant your were doing a "migration". That said, I would recommend to use SAS Viya pay-as-you-go (Azure, full Viya environement) for product evaluation scenarios. Could be easier to deploy. Microsoft Azure Marketplace Or, as I mentioned earlier, Viya Workbench (AWS, more suited for team/single users). SAS Viya Workbench | SAS ... View more

I can't help you with this error, but as you phrase it "I want to report", I suggest you direct this issue to SAS tech support. ... View more

If you execute using debug, you <might> get some more information out: options sastrace=',,,d' sastraceloc=saslog nostsuffix msglevel=i; What cloud does Snowflake reside on? And out of curiosity, what i SAS Fusion? I stumbled upon this , not sure if it's applicable: Multi Row Insert fails with "Failed to decrypt. Check file key and master key." · Issue #374 · snowflakedb/snowflake-connector-nodejs · GitHub A track to SAS tech support could be a good idea.     ... View more

If you are used to single user 9.4 installation, yes, Viya can seem like a nightmare. First, I think you need a Kubernetes specialist that can prepare the environment and guide you. IMO the default migraiton path for single users is SAS Viya Workbench. ... View more

And of course thee are multiple ways of doing it in SAS: data have; length text $20; input text; datalines; abcd15ppppp bvcsf24dsfd cadadada30fdsfdsf ; run; data want; set have; col1 = scan(text,1,,'D'); col2 = scan(text,1,,'AI'); col3 = scan(text,2,,'D'); run; ... View more

Since you mention EG I assume you are in 9.4 (even though EG is supported for Viya4). If you consider upgrading to Viya at some point, SSO is supproted there: SAS Help Center: Authenticate to Microsoft Azure Using Single Sign-On Ortherwise I think the AUTHDOMAIN option as already mentioned is the best method. ... View more