BookmarkSubscribeRSS Feed
foxrol94
Fluorite | Level 6

Hi,

 

I have one table called ENC (same table are in file attached):

 

PAYS   | Header |CD2  |VAL1|VAL2| COEF

BRE    | MATLAB | 11  |.   |500 |-0,9561
BRE    | MATLAB | 11  |500 |.   |0
BRE    | MATLAB | 2   |.   |550 |-1,2212
BRE    | MATLAB | 2   |550 |.   |0

 

and I would like to create a SAS Format by using this code(missing signify to be "lowest or highest possible value") :

data WORK.FMT_ENC(keep=START END FMTNAME LABEL);
    length FMTNAME $32;
    retain FMTNAME ;
    set ENC (rename=(VAL1=start VAL2=end   COEF=label)) end=eof;
    FMTNAME = lowcase(compress('$' !! PAYS !! Header !! put(CD2,2.)!!'_flgperso'));
    /*retain fmtname "test" type "C";*/
    output;
    if eof then
    do;
        hlo = "O";
        label = "Autre";
        output;
    end;
    run;
    proc format library=WORK cntlin=WORK.FMT_ENC;
run;

 

and I get this error:

 

ERROR: Cannot mix missing and nonmissing values in the same range: .-500.

Plase could you tell me what is wrong in my code.

 

 

Thanks a lot fro your reply.

5 REPLIES 5
Shmuel
Garnet | Level 18

If val1 = . define it as "LOW";

if val2 = . define it as "HIGH";

That means that you need define START and END fields as alphanumeric, eventhough

you want to creat FORMAT and not FORMATC;

foxrol94
Fluorite | Level 6

Hi,

 

How can i do that?

Thnaks

Shmuel
Garnet | Level 18

Your code with changes:

 

data WORK.FMT_ENC(keep=START END FMTNAME LABEL);
    length FMTNAME $32;
    retain FMTNAME ;
    set ENC (rename=(COEF=label)) end=eof;
length start end $16;
if VAL1 = . then start='LOW'; else start=left(VAL1);
if val2 = . then end = 'HIGH"; else end = left(VAL2);
FMTNAME = lowcase(compress('$' !! PAYS !! Header !! put(CD2,2.)!!'_flgperso')); /*retain fmtname "test" type "C";*/ output; if eof then do; hlo = "O"; label = "Autre"; output; end; run; proc format library=WORK cntlin=WORK.FMT_ENC; run;

 

Astounding
PROC Star

The error message tells you one of the problems.  But even if you were to fix that one, there would be more.  The ranges in your format appear to overlap.

 

Try sketching out the complete VALUE statement that would be equivalent to what you want PROC FORMAT to execute for this data.  That would clarify enough of your intentions that the code can be fixed.

ballardw
Super User

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.

 

Better for posting example data is data step code to allow recreating your example data set. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

SAS Innovate 2025: Call for Content

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!

Submit your idea!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2801 views
  • 0 likes
  • 4 in conversation