Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Implementing User Defined formats

Reply
Frequent Contributor
Posts: 80

Implementing User Defined formats

Hi Community,

 

I would like to implement a user-defined format in SAS VA Data Builder. I got the snippet of the format.

Now, where and how I need to configure so that the format name will appear in SAS VA Data Builder.

Please guide me the steps for implementation.

 

Kind Regards,

Balraj.P

Frequent Contributor
Posts: 80

Re: Implementing User Defined formats

Hi Community,

 

still looking for solution, let me tell you what all I've done

Step1: In SAS EG I've written my SAS Code for Billion to INR conversion. Below is the code

 

libname dir 'C:\SAS\Config\Lev1\SASApp\SASEnvironment\SASFormats';
proc format library = dir;
	picture INR low-high='00,00,00,00,000.00';
RUN;
/*data test1;
	a=35353521212;
  format a INR.;
run;
*/
options fmtsearch=(dir);

Step2: In "c:\\sas\config\lev1\sasapp\sas_usermods.cfg" I've added the following statements, when I'm trying to use them in SAS DataBuilder I'm getting an error. Plz refer the attachment

 

 

-set fmtlib1 "\\D1234\SAS\Config\Lev1\SASApp\SASEnvironment\SASFormats\"
-fmtsearch (fmtlib1.formats)

 

Guide me if I'm going wrong anywhere

 

Kind Regards,

Balraj.P

 


UDError.PNG
Super User
Posts: 3,240

Re: Implementing User Defined formats

This link may be helpful:

 

http://support.sas.com/kb/47/100.html

 

Frequent Contributor
Posts: 80

Re: Implementing User Defined formats

Hi @SASKiwi,

 

I've followed the document using the same above code which I posted earlier I was able to create the catalogue and the output is coming correctly in the SAS EG, but when I'm trying use the same format name in Databuilder, Query is executing but the Table is not generated on to the SAS LASR Server.

 

Do I've to register catalogue anywhere? so that It will appear in the "Format" options list

 

Kind Regards

Balraj P

Ask a Question
Discussion stats
  • 3 replies
  • 383 views
  • 0 likes
  • 2 in conversation