Hello everyone,
I am having an issue with a format. In a dataset in one system, say system A, a format named product is used. I need to use the same format & dataset in another system, say B. So how can I know how the format in system A has been defined so that I can use this in system B.
Please help me, I am having this issue for a long time, but cannot find a solution.
first use
proc format cntlout=x
make a dataset named X .
transfer X into B system.
then run
proc format cntlin=x
Ksharp
Hi.
Can you try this?
*--- enter name of format -----*;
%let format = product;*possibly $product
proc format library = work.formats fmtlib;
select &format.;
run;
quit;
Let me know.
Hi,
You can also use proc contents procedure to check the type of format used in dataset A. Proc contents procedure will display the attributes, engine, variables(length,type,format,label etc.,), and on which variable the dataset is sorted.
Here is the syntax
Proc contents data=A;
run;
if there are no formats used for the variables it will not display anything.
Hope this helps you.
Thanks,
Jagadish
first use
proc format cntlout=x
make a dataset named X .
transfer X into B system.
then run
proc format cntlin=x
Ksharp
The other issue you might need to check is the FMTSEARCH option so that you know where the format is stored.
Tom,
The catalog holding each user format is defined in SASHELP.VFORMAT
PeterC
(I think Ksharp has the correct answer)
Can you please help me in giving below information?
I get mail saying that "you have not set a status update". Where to set the update?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: