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.
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.
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.
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)
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.