Applying a dataset of multiple format labels to another dataset

EmilyAV — Wed, 01 Dec 2021 21:11:53 GMT

I am working with a dataset that contains more than 100 different categorical variables, some with up to 10 possible categories. The data manager provides separate .DAT files with labels for each category, using the following structure:

data format;
input label $ formatname $ type $ code;
datalines;
Not reported RESULT N 999
Positive RESULT N 1
Negative RESULT N 2
Missing RESULT N .
Small SIZE N 1
Medium SIZE N 2
Large SIZE N 3
Missing SIZE N .
...

I'm able to import these .DAT files to create a format datasets as follows:

PROC IMPORT OUT= formats (RENAME=(VAR1=LABEL VAR2=FMTNAME VAR3=TYPE VAR4=CODE))
			DATAFILE="C:\\..."
            DBMS=TAB REPLACE;
     GETNAMES=no;  
     DATAROW=1; 
RUN;

Is there a way to apply all labels in this formats dataset to the dataset I'm using for the project, without manually writing each entry using proc format?

Re: Applying a dataset of multiple format labels to another dataset

Reeza — Wed, 01 Dec 2021 21:17:55 GMT

You can create a format from a data set.
An example and some basic details are here:
https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1e19y6lrektafn1kj6nbvhus59w.htm

And if you're not sure how to structure your data set, make a small example using proc format and then have it saved to a data set using the CNTLOUT option.

topic Re: Applying a dataset of multiple format labels to another dataset in New SAS User

Applying a dataset of multiple format labels to another dataset

Re: Applying a dataset of multiple format labels to another dataset