Date: Fri, 10 Jul 1998 10:37:43 -0600
Reply-To: Jack Hamilton <jack_hamilton@HCCOMPARE.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Jack Hamilton <jack_hamilton@HCCOMPARE.COM>
Subject: Re: Answers: HLO option in CNTLIN
Content-Type: text/plain; charset=US-ASCII
Ray Pass <raypass@WORLDNET.ATT.NET> wrote:
>As usual, SAS-L comes through. Bernard's response was enough to get me
>successfully jump-started, and then Ian sent me a treatise privately
>(enclosed below) which as usual gave me what I needed, with some
>value-added stuff. Damn, this list is good!
Yup! I didn't know about the F value in HLO, or if I did know I'd forgotten it.
As a general rule, though, I don't rely on the documentation for
learning about what can go in a CNTLIN dataset. I would create a format
similar to what I want using regular PROC FORMAT code, then create a
CNTLOUT dataset and look at it. So, if I had wanted know most of the
possible values for HLO and other variables, I would code:
----------
168 proc format cntlout=test;
169 value one (max=10 min=1 default=2 fuzz=.1)
170 low- 1 = 'A'
171 2 - 3 = 'B'
172 4 <- 5 = 'C'
173 6 -< 7 = 'D'
174 8 - high = 'F';
NOTE: Format ONE has been output.
175
176 value two
177 low-high = 'A'
178 other = 'B'
179 . = 'C';
NOTE: Format TWO has been output.
180
181 value three
182 '01Jan1998'd - high = [date9.]
183 other = "Too early"
184 . = "Unknown";
NOTE: Format THREE has been output.
185
186 *****; run;
NOTE: The data set WORK.TEST has 11 observations and 17 variables.
NOTE: The PROCEDURE FORMAT used 0.05 seconds.
187
188 proc format cntlout=fmts;
189
190 *****; run;
NOTE: The data set WORK.FMTS has 11 observations and 17 variables.
NOTE: The PROCEDURE FORMAT used 0.05 seconds.
191
192 proc print data=fmts;
193
194 *****; run;
NOTE: The PROCEDURE PRINT used 0.0 seconds.
----------
and the result would be:
----------
OBS FMTNAME START END LABEL MIN MAX DEFAULT
1 ONE LOW 1 A 1 10 2
2 ONE 2 3 B 1 10 2
3 ONE 4 5 C 1 10 2
4 ONE 6 7 D 1 10 2
5 ONE 8 HIGH F 1 10 2
6 THREE . . Unknown 1 40 9
7 THREE 13880 HIGH DATE9. 1 40 9
8 THREE **OTHER** **OTHER** Too early 1 40 9
9 TWO . . C 1 40 1
10 TWO LOW HIGH A 1 40 1
11 TWO **OTHER** **OTHER** B 1 40 1
OBS LENGTH FUZZ PREFIX MULT FILL NOEDIT TYPE SEXCL EEXCL HLO
1 1 0.10000 0 0 N N N L
2 1 0.10000 0 0 N N N
3 1 0.10000 0 0 N Y N
4 1 0.10000 0 0 N N Y
5 1 0.10000 0 0 N N N H
6 9 0.00000 0 0 N N N
7 9 0.00000 0 0 N N N HF
8 9 0.00000 0 0 N N N O
9 1 0.00000 0 0 N N N
10 1 0.00000 0 0 N N N LH
11 1 0.00000 0 0 N N N O
----------
There are additional options for INVALUE and PICTURE formats.
