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

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

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
  • 548 views
  • 0 likes
  • 2 in conversation