Altair Analytics Workbench 5.0 Version Issue

Mary Presley

I have 5.0 installed and found out that one of fields only displaying the first letter of data. I have to rollback to 4.04.

Do I have to do this?

Thanks in advance.

Philip Holland

Hi Mary,

Please can you post the SAS program you are trying to run? It may not necessarily be an Altair-related issue.

............Phil

Mary Presley

Philip Holland said:

Hi Mary,

Please can you post the SAS program you are trying to run? It may not necessarily be an Altair-related issue.

............Phil

It took us a while to figure this out. First it was running at my machine which had 5.23 version installed. The table only has first letter populated. Then we ran at a different machine which has 4.4 version installed. It populated a full name. Therefore, IT uninstalled 5.23 and reinstalled 4.4. Now, I see the full name is populated. 

I just wonder there is a patch or something we can install to fix this issue instead of rolling back to 4.4 version. 

Hope this helps. 

Nico Chart_21517

Hi Mary,

As Phil says, it would be good to see the sas code that creates the table, if that is available?

Also, can you tell us the full version number that you tried, or the full name of the downloaded MSI file?

Thanks,
Nico

Mary Presley

Philip Holland said:

Hi Mary,

Please can you post the SAS program you are trying to run? It may not necessarily be an Altair-related issue.

............Phil

Thank you both. 

I can't show any sas code here because that will against our agency policy. 

However, I can show you two versions of Altair:

same sas codes. two different versions of Altair and we get two different results.

Philip Holland

Mary Presley said:

Thank you both. 

I can't show any sas code here because that will against our agency policy. 

However, I can show you two versions of Altair:

same sas codes. two different versions of Altair and we get two different results.

Hi Mary,

I understand why you can't post your failing production(?) SAS program, as I work in a regulated environment myself.

However, Nico and the Altair SLC developers will not be able to resolve your issue without a lot more detail on what your SAS program was actually doing. They can perform miracles, but can't with zero information and their hands tied behind their backs!

Can you create a simple non-business-critical SAS program that exhibits the same issue, but which can be posted here, or, at least, posted directly to Nico and the developers?

..........Phil

PS. I know Nico would like to tell you this too, but he's way too polite! J

Mary Presley

The code is just selecting data from database.

select distinct caseid,provname,...,LeadRole,LeadName,

It is the LeadName not fully populated.

 

Philip Holland

Mary Presley said:

The code is just selecting data from database.

select distinct caseid,provname,...,LeadRole,LeadName,

It is the LeadName not fully populated.

 

Hi Mary,

I have a few questions that may help us help you:

1. Does LeadName use a specified SAS format and variable length, or is it defaulting to something unspecified?
2. What is the length of the LeadName column in the database?
3. How long is the data in LeadName (as opposed to the length of the variable) in the first record being read? 
4. Is the database made up of SAS data sets, WPS data sets, or is it a relational database?
5. If the answer to Q1 is not a specified format and length, is it possible to test an updated SQL Select clause with FORMAT= and LENGTH= specified after LeadName in both 4.4 and 5.23?

I have been working with SAS programs and data sets since 1981, but sometimes the results can be counter-intuitive.

.................Phil