Implementing User Defined formats

[balraj]

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

[balraj]

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

[SASKiwi]

This link may be helpful:

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

[balraj]

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