Altair Analytics Workbench 5.0 Version Issue

Hi Mary,

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

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

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. 

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

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.

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

The code is just selecting data from database.

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

It is the LeadName not fully populated.

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