cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nbav001
‎03-19-2023
  • 4 Posts
  • 0 Likes Given
  • 1 Solutions
  • 0 Likes Received

Re: IFN and IFC not working on missing character variables

by Fluorite | Level 6 in SAS Programming
‎03-14-2023 07:22 PM
‎03-14-2023 07:22 PM
Yes, I understand that. I also agree that using informants or other options such as using select when or if else are simple and easily understandable. Thank you for  your suggestion.  ... View more

Re: IFN and IFC not working on missing character variables

by Fluorite | Level 6 in SAS Programming
‎03-13-2023 08:47 PM
‎03-13-2023 08:47 PM
Thank you everyone for your replies and suggestions.  I tried the following code and it worked for me.   ... View more

Re: IFN and IFC not working on missing character variables

by Fluorite | Level 6 in SAS Programming
‎03-12-2023 11:29 PM
‎03-12-2023 11:29 PM
Reference1: https://www.lexjansen.com/wuss/2012/28.pdf Reference2: https://documentation.sas.com/doc/en/vdmmlcdc/8.1/lefunctionsref/n0l3n5z2h31h7wn1fmnqd33ibhap.htm Reference3: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/lefunctionsref/n0l3n5z2h31h7wn1fmnqd33ibhap.htm According to the above documentation there is a 4th optional argument that can is used for IFN and IFC for missing values.  But I my case it is not working.  ... View more

IFN and IFC not working on missing character variables

by Fluorite | Level 6 in SAS Programming
‎03-12-2023 10:53 PM
‎03-12-2023 10:53 PM
can someone please help me with this???   Example codes data test; input x $1; z=ifc(x='M','zero','one','missing'); datalines; M F M F ; run; data test1; input x $1; z=ifn(x='M',0,1,.); datalines; M F M F ; run; proc print data=test; run; proc print data=test1; run; Result:     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-19-2023 07:44 PM
Quick links