topic Re: Using format in SAS Programming

Using format

sandrube — Thu, 13 Apr 2023 04:20:17 GMT

Hello friend,

I was trying to incorporate formats into the data and used the following code:

libname unos "E:\Data sets\UNOS data\SAS Dataset 202209\Thoracic";
data thoracic_data_1;
set unos.thoracic_data;
options fmtsearch=(unos.formats);
run;

formats.sas7bcat and thoracic_data.sas7bdat are in the above folder path.

But it didn't work. Can someone guide me please?

I appreciate your help!

Rube

Re: Using format

andreas_lds — Thu, 13 Apr 2023 06:22:32 GMT

What do you expect to happen?

The statement "options fmtsearch" extends the catalogs sas uses to find the formats you want applied, but does not assign a format to a variable.

Re: Using format

Kurt_Bremser — Thu, 13 Apr 2023 08:30:50 GMT

What does the log sayß?

Please copy/paste the complete (all code and messages) of your DATA step into a window opened with this button:

Also, look at your source data. Run PROC CONTENTS on dataset unos.thoracic_data to see if any special formats coming from unos.formats.catalog are associated with any of the variables in the dataset.

Finally, run PROC CATALOG to see what's in the catalog.

SAS catalogs are version- and platform-specific, so your catalog might not work in your environment; and SAS file names must be all lowercase in the filesystem.