topic Re: how to apply prefined formats in New SAS User

how to apply prefined formats

Jannie_D — Wed, 07 Apr 2021 12:39:15 GMT

I have a very big data set on a secure server, hence I can not copy paste codes og logs.

I have no been spending days trying to apply on my predefined codes. so What i did so far:

libname fmt "path...";

options fmtsearch=(fmt.uddannelser fmt.diced);

proc format;

value audd_niveau_L1L2_KT

0="90 uoplyst"

1="10 grundskole"

....goes on for several 100 lines.....;

run;

data udda1

set udda;

format hfaudd default= audd_niveau_L1L2_Kt;

run;

but it do not work what do I do?

Re: how to apply prefined formats

Kurt_Bremser — Wed, 07 Apr 2021 12:49:14 GMT

Look at the log (Maxim 2). The FORMAT statement does not need an equal sign, and actually rejects it.

PS get an account on SAS on Demand for Academics. There you can recreate code that causes problems and copy/paste code and logs without restrictions.

Re: how to apply prefined formats

PaigeMiller — Wed, 07 Apr 2021 12:51:56 GMT

The only thing I see wrong is in the FORMAT statement.

The syntax of the format statement is:

FORMAT variablename formatname. ;

Note, there must be a dot at the end of the formatname. There is no equal sign.

If you fix that and it still doesn't work, show us the LOG of this DATA step so we can see both your code that is being used and the exact ERROR message. Do not chop out parts of the LOG for this DATA step, we need to see it verbatim, copied as text and pasted into the window that appears when you click on the </> icon. This preserves the formatting and makes the log more readable — do not provide the log any other way.

Re: how to apply prefined formats

Reeza — Wed, 07 Apr 2021 13:42:04 GMT

You don't indicate what you mean by 'predefined' formats. If you mean that you have a format for a variable name and need to apply them, if they're listed in a data set that can be automated. If there's a pattern it can also be automated. And if you have a lookup file that has the original & new values you can also automate the creation of the format.

This paper is a good read on formats IMO.
https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/001-30.pdf