Hi, I have a SAS dataset which contains data in the following pattern: A_id A_Amount A_Stage A_week 1 2123 first wk_1 2 234324 first wk_1 3 232 first wk_1 4 1 first wk_1 5 1123 first wk_1 1 3242 second wk_2 2 324255 second wk_2 3 2342 second wk_2 4 4324 second wk_2 1 242424 third wk_3 2 43242 third wk_3 3 424 third wk_3 4 242 third wk_3 1 4 fourth wk_4 2 243 fourth wk_4 3 2 fourth wk_4 I want the following view: A_id A_week_1 A_Stage_1 A_Amount_1 A_Week_2 A_Stage_2 A_Amount_2 A_week_3 A_Stage_3 A_Amount_3 A_week_4 A_Stage_4 A_Amount_4 1 wk_1 first 2123 wk_2 second 3242 wk_3 third 242424 wk_4 fourth 4 2 wk_1 first 234324 wk_2 second 324255 wk_3 third 43242 wk_4 fourth 243 Can you kindly provide me the proc sql code or data set step for this. Thanks in advance! Best Regards, Mrinal ... View more

Hi All, It would be of great help if you can help me with this, please. I am trying to export an xls file using SAS using the the below code, but am getting the following error. The file has 13 variables and 78 observations. The code is as follows: libname SAS "C:\Users\mrinal\Desktop\test"; filename test "C:\Users\mrinal\Desktop\test\Badahar.xls"; data SAS.z1; infile test truncover dsd firstobs=2; informat Amount_outstanding 5.2; informat Collateral_category $18.; informat Comments $15.; informat F13 $6.; informat Formal_informal $8.; informat Household_number best8.; informat Interest_category best8.; informat Interest_outstanding 6.2; informat Loan_number best8.; informat Principal_outstanding best8.; informat Type_of_loan $11.; informat UPDATETIME $255.; informat Village $6.; format Amount_outstanding 5.2; format Collateral_category $18.; format Comments $15.; format F13 $6.; format Formal_informal $8.; format Household_number best8.; format Interest_category best8.; format Interest_outstanding 6.2; format Loan_number best8.; format Principal_outstanding best8.; format Type_of_loan $11.; format UPDATETIME $255.; format Village $6.; input Amount_outstanding Collateral_category $ Comments $ F13 $ Formal_informal $ Household_number Interest_category Interest_outstanding Loan_number Principal_outstanding Type_of_loan $ UPDATETIME $ Village $ ;run; proc print data=SAS.z1;run; Error I am getting is: NOTE: The infile TEST is:       Filename=C:\Users\mrinal\Desktop\test\Badahar.xls,       RECFM=V,LRECL=256,File Size (bytes)=30720,       Last Modified=28Aug2008:10:24:49,       Create Time=27Aug2008:08:09:59 NOTE: Invalid data for Amount_outstanding in line 1 1-6. RULE:    ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9-- 1  CHAR ÐÏ.ࡱ 6     ZONE DC1EAB     NUMR 0F1011 Amount_outstanding=. Collateral_category=  Comments=  F13= Formal_informal= Household_number=. Interest_category=. Interest_outstanding=. Loan_number=. Principal_outstanding=. Type_of_loan= UPDATETIME=  Village= _ERROR_=1 _N_=1 NOTE: 1 record was read from the infile TEST.       The minimum record length was 6.       The maximum record length was 6.   NOTE: The data set SAS.Z1 has 1 observations and 13 variables Thanks in advance for your support. ... View more