Can anyone help me with the SAS equivalent of following code MERGE TABLE A USING (SELECT VAR1,VALUE1 FROM TABLE B) C ON C.VAR1=A.VAR1 WHEN MATCHED THEN UPDATE SET A.VALUE1= C.VALUE1
... View more
Surya , I am the same code and the data set is like Column Ais Bank_code B is PAN_Number C is party_name Here The problem is that some of the pan numbers are missing where where blank space is getting populated instead of null
... View more
I am creating CSV file from sas dataset using following code Data _null_; set dataset; File "filename" DLM=','; if _n_ eq 1 then do **** **** Put 'A,B,C'; End; PUt A B C; run; Problem is that a blank space is introduced in fileds with null values. Please help how to avoid that.
... View more