I have two datasets, e and f.    data e; input cycle tot1 tot2; cards; 205 10 30 205 20 40 ; run; data f; infile cards missover; input cycle tot1 ; cards; 205 . 205 50 ; run;     The expected dataset would be:   cycle tot1 tot2 205 10 30 205 50 40   >>>>> Test code : data g; merge e(in=a) f(rename=(tot1=t1 tot2=t2)); by cycle; array t(2) t1-t2; array tot(2) tot1-tot2; do i=1 to 2; if t(i)^= . then tot(i)=t(i);  end; if a ; drop t1 t2 i; run;     ... View more

Hi All, I have attached sample sas dataset (human.sas7bdat). Below is my SAS code. Upon transposing, it truncates column name ( new_name column).  Proc Transpose truncates column name ! How do I show column name displayed completely ?     libname test "D:\test"; data test.human; set human; run; proc print data=test.human ; run; proc sort data=test.human out=test (where=(group ne ' ')); by group dept; run; data test; set test ; length new_name $ 32767; retain new_name; if not missing(qq) then new_name=qq; run; Proc Transpose data= test Out=Human2(drop=_name_ ) ; var response; id new_name ; by group dept ; run; proc print data=WORK.HUMAN2 ; Title1 'Proc transpose truncated column name'; run; >>>>> The "new_name" column is not being shown correctly in the print output.     ... View more

Dear SAS Communities Members:   Following SAS code encrypts Make and Model well. How can I apply Decryption to create Make_R and Mode_R variables from encrypted HASH field ?  ( P.S. I don't want to use MD5 encryption.)   data cars; length hash $ 32; format hash $hex64.; set sashelp.cars; hash = sha256(cats(make,model)); run;   OR I have alphanumeric variable and numeric variable. How can I encrypt and decrypt them without using MD5.   I have an alphanumeric variable and numeric variables. How can I encrypt and decrypt them without using MD5. Data a; input ID $ dept  SALARY; cards; ABC123 10020 45000 ; RUN; ... View more

I have three data sets: (1) S1 (n=441000 Unique records KEY (= ID) with 22 columns : ID and A1:A21) (2) S2 (n=1,467,661,903 records, with duplicate Key (= ID) records with 5 columns : ID, B, C, D and Action) (3) S3 (n=905 Unique records with 3 columns : X, Action and Action_Desc)   SQL query: ========== Proc SQL; Select S1.*,S3.Action_Desc from S1 Left join S2 on s1.id=s2.id left join s2.action=s3.action; quit;   HASH CODE: ========== DATA HASH_ACTION; IF 0 THEN SET s1; if _N_ = 1 then do; declare hash HASH_NAME(dataset: "s1", multidata: 'y'); HASH_NAME.defineKEY("ID"); HASH_NAME.defineData (ALL:'YES'); HASH_NAME.defineDone(); END; set s2(keep=ID B C D ACTIOn); IF HASH_NAME.FIND(KEY:ID) = 0 THEN OUTPUT; RUN; Question: (1) I got duplicate records HASH_ACTION dataset, how can I get only unique records. (2) How can I embed : left join s2.action=s3.action into HASH Code.   ... View more