Hello,   I am hoping to replace the missing values in Description Variable with 'Unspecified'   Please help in identifying the cause of following error:   ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.   Proc SQL; Create Table Current2 AS Select *, Case when Description eq ' ' then Description eq 'Unspecified' else Description end as Description FROM Current1 ; QUIT;   P.S.Description variable is Character Type. ... View more

Hello, Please help me with the code for the following problem:   Data: MEMBER TABLE MemberID          Group        County           AddressType       A                    111           Newman              H       A                    111           Fritz                     M       A                    111            Damus                 I       B                    114           Holler                  H       C                    114           Boxing                H       D                    114           Dockers              M     I want to select observations on the following basis:   1.) When MemberID is same under a particular Group then select/get the observation with AddressType 'H' 2.) When MemberID is different under a particular Group then select/get all the observations.   Here is what I am hoping to get:   MemberID          Group        County           AddressType       A                    111           Newman              H       B                    114           Holler                  H       C                    114           Boxing                H       D                    114           Dockers              M   Thanks, Varun   ... View more

Hello,   I am getting the following errror  ERROR 22-322: Syntax error, expecting one of the following: MISSING, NOT, NULL, ^, ~. ERROR 76-322: Syntax error, statement will be ignored.   When  I run this code : proc sql; create table MEME as  select subscriber_id , subscriber_name ,(datepart(Subscriber_Termination_DT)) as Term_DT from sashelp.susbcriber_table where TERM_DT is ge today(); quit;   * Subscriber_Termination_DT is in Datetime22.3 format ... View more