Hello, Can anyone advice me how to transpose the following data? I have this data: data have; input Claim_ID CODE $5; datelines; 10001       90651 10001       90670 10001       90680 10001       90698 10001       91170 10002       92405 10002       90710 10003       90715 ; I want to have this data; Claim_ID  Code_1  Code_2  Code_3  Code_4  Code_5 10001     90651    90670    90680     90698    91170   10002     92405     90710           10003     90715 ; The number of Code can be more than five per claim but I want to consider the maximum number of distinct Code by claim as my columns. Thank you in advance!   ... View more

Hello, I was writing DATE macro  while connecting to SQL server using ODBC.  I wrote the following code:  data _null_; START_DATE= intnx ('month',today(),-2,'B'); END_DATE= intnx ('month',today(),-1,'E'); call symput ('S_DATE', START_DATE); Call Symput ('E_DATE', END_DATE); run; proc sql; connect to odbc as ALIAS (datasrc=SQLSERVER user=USER password=PWD); create table DATASET as select * from connection to ALIAS (SELECT distinct * FROM DATABASE.dbo.TABLE WHERE DOS_FROM >= &S_DATE ) ; QUIT; I got the following error: ERROR: CLI describe error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Operand type clash: date is incompatible with smallint : [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. Note: the variable  DOS_FROM in the sql database is a format of date9.(DDMMMYYYY type).  Any help is appreciated.  Regards,   ... View more