I'm trying to upload to VA an user-defined format i paste the .sas7bcat file in the directory /sasconfig/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/AutoLoad/Formats
i try to run the runsas.sh but the log tells me it didnt find any new format. I also set my user defined format in my sasv9_usermod.cfg so that it can be insert in the fmtsearch, now i see my log and it shows me this but i have 0 observations on the format scan.
NOTE: FMTSEARCH=(FORMAT APFMTLIB WORK LIBRARY DBFORMAT.FORMATS/LOCALE)
NOTE: SCANNING INPUT FOLDERS
NOTE: There were 0 observations read from the data set WORK.SCANADDF.
NOTE: The data set WORK.SCANADDF has 0 observations and 7 variables.
How about trying the preferred method as described here:
The preferred method for making user-defined formats available to a SAS® Application Server is to name the format catalog formats.sas7bcat and to place it in
What is the name of your FORMATS catalog? Is it one of the ones listed in your FMTSEARCH option? To confirm:
proc options option=fmtsearch; run;
Also since you are using Unix I think both the catalog name and the FMTSEARCH name need to be uppercase.
The name of my format catalog is FORMAT you can see it in the part of the log of fmtsearch that i've post, i run the proc options and yes the result is the same that i post already.
FMTSEARCH=( FORMAT APFMTLIB WORK LIBRARY )
Specifies the order in which format catalogs are searched.
NOTE: PROCEDURE OPTIONS used (Total process time):
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.
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.