About M4XF - SAS Support Communities

‎05-12-2017

Calcite | Level 5

Member since

3 Posts
0 Likes Given
0 Solutions
0 Likes Received

Follow M4XF

Re: Setting a missing value to a variable using create format

1417

‎05-11-2017 02:26 AM

Re: Setting a missing value to a variable using create format

1441

‎05-10-2017 08:42 AM

Setting a missing value to a variable using create format

1457

‎05-10-2017 07:59 AM

Activity Feed for M4XF

Posted Re: Setting a missing value to a variable using create format on SAS Enterprise Guide. ‎05-11-2017 02:26 AM
Posted Re: Setting a missing value to a variable using create format on SAS Enterprise Guide. ‎05-10-2017 08:42 AM
Posted Setting a missing value to a variable using create format on SAS Enterprise Guide. ‎05-10-2017 07:59 AM

Hi Jag, I tried it the same way, but what happend was that for all other values I got two single quotation marks. If I use a format created like you did (named $Gender.) I get the results as shown in the provided picture. Code for column Gender_1: CASE WHEN t1.Gender_orig = 'W' THEN 'Weibl.' WHEN t1.Gender_orig = 'M' THEN 'Männl.' ELSE '' END Code for Gender_2: PUT(t1.Gender_orig, $Gender.) Code for Gender_3: use format $Gender. as output format

Online Status	Offline
Date Last Visited	‎05-12-2017 03:15 AM