I have .sas7bcat format catalog. when i run the proc catalog the output is as below.
I want to make it to .sas7bdat and what to see the data inside how can i do that?
We can't help if we don't see entire log printout. Also from the proc.
Run the following:
options fmtsearch = (FMT); proc catalog c=FMT.formats; contents; run;quit; data _null_; ASD_orig = "test"; APR_name_orig=put(ASD_orig, $APR_NM.); run;
and share the log. BTW. proc catalog ends with "QUIT;"
Generic idea is to use Proc Format to point to the location and use CNTLOUT option to create a data set.
That would require a libname where the format catalog resides
The basic code would look like
Proc format library=YOURLIB cntlout=yourdatasetgoeshere; run;
Caution: Catalogs can be a bit version specific, SAS release and operating system, but if proc contents isn't complaining then you may be good to go.
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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.