[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: note: using SQL to make proc Format CntlIn
From:       "Fehd, Ronald J" <rjf2 () CDC ! GOV>
Date:       2005-10-31 19:30:24
[Download RAW message or body]

yeah, Sig, once I posted
I put a note on my todo list:
show the data step code to create same data set.

I'm thinking that this is more or less correct.

data   hsfmt;
retain FmtName '$HSLong'
       Type    'C'
       max     48
       ;
do     until(EndoFile);
set    ftd.IEDITMAST(rename  = (
                     HS      = start
                     Lalpha  = label
                    )          )
       end = EndoFile;
output;
end;
hlo   = 'O';*Oh, not zero;
label = '***ERROR***';*or '**Other**';
output;
stop;

Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov

--> cheerful provider of UNTESTED SAS code from the Clue?Gee!Wrx <--

> -----Original Message-----
> From: owner-sas-l@listserv.uga.edu
> [mailto:owner-sas-l@listserv.uga.edu]
> On Behalf Of Fehd,
> Ronald J
> Sent: Monday, October 31, 2005 8:55 AM
> To: ___ SAS-L
> Subject: note: using SQL to make proc Format CntlIn
>
>
> I am polishing a Bureau of Census TestSuite
> and came across the following bit of code:
>
> proc sql noprint;
>          create table hsfmt as
>          select '$HSLong' as fmtname,
>                 'C'       as type,
>                 HS        as start,
>                 Lalpha    as label,
>                 48        as max
>          from   ftd.IEDITMAST
>         ;quit;
>
> proc format cntlin=hsfmt lib=work;
> run ;
>
> I am familiar with using SQL to create sQuoted text
> but had not seen a constant (48) selected into a numeric before.
>
> Ron Fehd  the macro maven  CDC Atlanta GA USA RJF2 at cdc dot gov
>

[prev in list] [next in list] [prev in thread] [next in thread]