04-29-2016 09:03 AM
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.
05-03-2016 12:25 AM
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
05-03-2016 06:12 AM
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