Task1:

Followingis a raw file contains variables as below:

         1) Account ID;

         2) Revenue;

         3) Segment;

         4) N_var1;

         5) C_var1;

         6) Transaction Date;

         7) Transaction Location;

8) Transaction Code;

         9) Transaction Amount;

10001,5,G1,.,,2014-10-23,CHINA,APP_001,100

10002,6,G1,.,,2014-10-23,CHINA,APP_002,110

10003,.,G1,.,,2014-10-23,CHINA,APP_003,50

10004,10,G2,.,,2014-10-23,CHINA,APP_004,90

10005,15,G2,.,,2014-10-23,CHINA,CAN_005,12

10006,13,G2,.,,2014-10-23,CHINA,MAN_006,10000

10007,.,G2,.,,2014-10-23,CHINA,APP_007,10

10008,20,G3,.,,2014-10-23,CHINA,APP_008,100

10009,25,G3,.,,2014-10-23,CHINA,APP_009,200

10010,.,G3,.,,2014-10-23, ,REJ_010,100000

10010,.,G3,.,,2014-10-23, ,REJ_010,100000

10010,.,G4,.,,2014-10-23, ,REJ_010,100000

10010,.,G5,.,,2014-10-23, ,REJ_010,100000

10003,7,G1,.,,2014-10-24,CHINA,MAN_003,50000

10004,9,G2,.,,2014-10-24,CHINA,APP_004,90

10006,6,G2,.,,2014-10-24,CHINA,MAN_006,1000

10007,.,G2,.,,2014-10-24,CHINA,APP_007,10

10008,8,G3,.,,2014-10-24,CHINA,APP_008,100

10009,9,G3,.,,2014-10-24,CHINA,APP_009,200

10010,.,G3,.,,2014-10-24,CHINA,APP_010,100

10010,10,G4,.,,2014-10-24,CHINA,APP_011,101

10010,20,G5,.,,2014-10-24,CHINA,APP_012,102

Pleasewrite SAS codes to perform the following tasks:

1.     Importthe raw file and create a SAS dataset;