topic Re: create format using dataset as a base and then adding onto it in SAS Programming

create format using dataset as a base and then adding onto it

raddad34 — Mon, 04 Oct 2021 13:02:02 GMT

Hello, I have a dataset I want to create a format from, but then I want to add an 'other' clause to assign a value for things that are not included in the dataset. Sorry if this is a simple question but I don't know how to go about doing this. Thank you.

Re: create format using dataset as a base and then adding onto it

maguiremq — Mon, 04 Oct 2021 13:18:58 GMT

This page should help you: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/proc/n1e19y6lrektafn1kj6nbvhus59w.htm

The `if last then do` portion takes care of the `other` clause you mentioned.

Re: create format using dataset as a base and then adding onto it

ballardw — Mon, 04 Oct 2021 14:59:02 GMT

One of the best ways I found to "learn" the options for CNTLIN data sets is to create small example formats or informats and create an output data set with the CNTLOUT option. Then look at the values set for the variables.

HLO is variable that you set values for to indicate the key words "High", "Low" and "Other" for the format/informat value range (hence HLO)

Re: create format using dataset as a base and then adding onto it

Reeza — Mon, 04 Oct 2021 15:42:58 GMT

See Page 10 in this article
https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/001-30.pdf