topic Re: proc format in SAS Programming

proc format

Babloo — Mon, 09 Sep 2019 13:49:00 GMT

I'm trying to create a user defined format as follows, but I'm not seing the updated Format in the dataset dis_entity_id. Am I doing something wrong? In my final dataset I want to see the texts as 'Schaden/Unall' if the ENTITY_ID is 5801

proc format;
Value $ENTIT
'5801'='Schaden/Unall'
'60011'='Hestia'
'56002'='Lebn'
'60041'='Austria'
'6002'='Belgien'
'5401'='Köln'
'54009'='Segros'
'5400'='Belgen'
'test'='NULL';
run;

proc sql;
create table dis_entity_id as select distinct ENTITY_ID format=$ENTIT. from &_INPUT;
quit;

Re: proc format

PaigeMiller — Mon, 09 Sep 2019 13:53:58 GMT

Are there error messages in the log?

Is ENTITY_ID a character variable?

Does PROC CONTENTS show the expected format attached to variable ENTITY_ID?

What do you see in the data set? (SHOW US)

Re: proc format

Babloo — Mon, 09 Sep 2019 13:57:45 GMT

No error Messages in the log.

yes, ENTITY_ID is a character variable

Log says

NOTE: Format $ENTIT has been output.

Re: proc format

ballardw — Mon, 09 Sep 2019 14:51:09 GMT

@Babloo wrote:

In my final dataset I want to see the texts as 'Schaden/Unall' if the ENTITY_ID is 5801

And how are you "looking" at your data set dis_entity_id?

Re: proc format

PaigeMiller — Mon, 09 Sep 2019 15:00:28 GMT

@Babloo wrote:

No error Messages in the log.

yes, ENTITY_ID is a character variable

Log says
NOTE: Format $ENTIT has been output.

Please provide the answers to all the questions I asked.

Re: proc format

Babloo — Mon, 09 Sep 2019 15:04:44 GMT

Just opening the dataset in SAS EG after the execution of program.

Do you feel that my code is logically correct?

Re: proc format

Reeza — Mon, 09 Sep 2019 15:18:28 GMT

Your code is logically correct so either your data is not what you think it is or you have an error somewhere else. It could be as simple as you opening the input data set instead of the output data set or some other issue. What happens if you run a proc freq on the data with the format instead?