BookmarkSubscribeRSS Feed
Rajivk
Calcite | Level 5

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?

 

1 REPLY 1
ballardw
Super User

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

 

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

SAS INNOVATE 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 407 views
  • 0 likes
  • 2 in conversation