import formatted sas7bdat in Viya

Rajivk — Thu, 22 Oct 2020 06:36:03 GMT

All,

I am having tough time importing as sas7bdat in Viya, for a variable has been formatted using PROC format. The issue is so grave that data advisor fails to load; However, I could explore the data. For this particular case, the formatting is not even complex, we are just getting 4 Delinquency buckets : 0 ~3 (numeric values)

Viya simply denies to show the data advisor, let me choose alternate format, or even assigns a default formatting.

Did anyone else faced this issue? If yes, how it was handled?

Re: import formatted sas7bdat in Viya

ballardw — Thu, 22 Oct 2020 15:39:49 GMT

I don't have access to Viya so can't point to the specific approach.

However SAS has had an option FMTERR or NOFMTERR that treats unavailable formats as errors or not for a very long time. So you might look here:

https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=lesysoptsref&docsetTarget=p1djbl02hfnoe3n0zh2i3uu2aqrf.htm&locale=en

which has note where to check in Viya for the setting.

topic import formatted sas7bdat in Viya in SAS Visual Analytics

import formatted sas7bdat in Viya

Re: import formatted sas7bdat in Viya