I have a dataset like STUDENTNAME  DIVISION A                        firstdiv B                        secdiv C                        thirdiv D                        firstdiv F                        thirdiv I have to create a format like proc format $division; value 'firstdiv' =1         'secdiv'=2         'thirdiv'=3         'all'= '1','2','3','all'; Kindly help me how to create format Regards, Ashwini ... View more

Please explaine how di studio 4.21 is more advance feature than etl 3.3. Regards, Ashwini ... View more

I have a table like studentname   subject         mark  grade A                       ENGLISH     50      B A                       MATH           70      A A                       SCIENCE      80      A B                        ENGLISH     40      B B                        MATH           30      C B                        SCIENCE      40      C D                       ENGLISH     40      C D                       MATH           70      A D                       SCIENCE      80      A I want create a  a prompt in store prosess like       select stname A B C D ALL NONE selct sub ENGLISH MATH SCIENCE ALL If i select stname A and and SUB  MATH then it show below data A                       MATH           70      A if I select stname B and D  and SUB math then it show below data B                        MATH           30      C D                       MATH           70      A I iI select stname ALL and SUB MATH then it show like A                       MATH           70      A B                        MATH           30      C D                       MATH           70      A If I select stname ONLY A then it show below data A                       ENGLISH     50      B A                       MATH           70      A A                       SCIENCE      80      A Kindly help me how to write the code show that it easy create a prompt in stored process. Regards, Ashwini ... View more

I have a data set like EMP_Detail. Employe_ID     Emp_Country             Company                             Department                                             Section                               Job_Title                            Gender          Employee_Hire_Date 120101                  Australia                         Orion Australia                         Sales Management                      Sales Management                  Director                             Male            1-Jul-99 120102                  Australia                         Orion Australia                         Sales Management                      Sales Management                  Sales Manager                      Male            1-Jun-85 120103                  Australia                    Orion Australia                         Sales Management                       Sales Management                 Sales Manager                      Male            1-Jan-70 120104                  Australia                         Orion Australia                         Administration                                    Administration                         Administration Manager   Female          1-Jan-77 120105                  Australia                         Orion Australia                         Administration                                    Administration                         Secretary I                       Female          1-May-95 120106           Australia                    Orion Australia                         Administration                                    Administration                           Office Assistant II            Male            1-Jan-70 120107                  Australia                         Orion Australia                         Administration                                    Administration                         Office Assistant III            Female          1-Feb-70 120108                  Australia                         Orion Australia                         Administration                                    Goods Entrance                      Warehouse Assistant II    Female          1-Aug-02 120109                  Australia                         Orion Australia                         Administration                                    Goods Entrance                      Warehouse Assistant I    Female          1-Oct-02 120110                  Australia                         Orion Australia                         Administration                                    Goods Entrance                      Warehouse Assistant III   Male            1-Nov-75 120111                  Australia                         Orion Australia                         Administration                                    Security                                  Security Guard II               Male            1-Nov-70 120112                  Australia                         Orion Australia                         Administration                                    Security                                  Security Guard I                Female          1-Jul-86 120113                  Australia                         Orion Australia                         Administration                                    Security                                  Security Guard II               Female          1-Jan-70 120114                  Australia                         Orion Australia                         Administration                                    Security                                  Security Manager                   Female          1-Jan-70 120115                  Australia                         Orion Australia                         Administration                                    Service Center                        Service Assistant I                Male            1-Aug-01 120116                  Australia                         Orion Australia                         Administration                                    Service Center                        Service Assistant II               Male            1-Feb-76 120117                  Australia                         Orion Australia                         Engineering                                       Engineering                              Cabinet Maker III                Male            1-Apr-82 120118                  Australia                         Orion Australia                         Engineering                                       Engineering                              Cabinet Maker II                Male            1-Jul-80 120119                  Australia                         Orion Australia                         Engineering                                       Engineering                              Electrician IV                    Male            1-Jan-94 120120                  Australia                         Orion Australia                         Engineering                                       Engineering                              Electrician II                      Female          1-Jan-70 120121                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. II                     Female          1-Jan-70 120122                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. II                     Female          1-Jul-74 120123                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. I                     Female          1-Oct-81 120124                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. I                     Male            1-Mar-75 120125                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. IV                   Male            1-Mar-75 120194                  Australia                         Orion Australia                         Sales                                           Sales                                             Trainee                            Male            1-Feb-01 120195                  Australia                         Orion Australia                         Sales                                           Sales                                             Trainee                            Female          1-Jul-02 120196                  Australia                         Orion Australia                         Sales                                           Sales                                             Trainee                            Female          1-Jan-99 120197                  Australia                         Orion Australia                         Sales                                           Sales                                             Trainee                            Female          1-Jan-99 120198                  Australia                         Orion Australia                         Sales                                           Sales                                             Sales Rep. III                    Female          1-Dec-02 120199                  Belgium                           Orion Belgium                           Administration                             Administration                          Office Assistant I             Female          1-Jan-99 120200                  Belgium                           Orion Belgium                           Administration                             Administration                           Office Assistant II                Female          1-Jan-99 I have to make below like tabs in storeprocess . Employee_Hire_Date FROMDATE 01JAN99 TODATE 29JUL99 SELECT  Emp_Country Australia Belgium ALL NONE Select Gender     M F NONE Kindly help me how to write a query using base sas and sas macro .So that i have got above tab in front end of storepeocees. Thanks in advance , Regards, Ashwini ... View more

I have an data set like below student detail. rollno studentname  subject        mark  division 1         A                     English          60      1 2        B                      English          80      1 4        D                     English          40      2 5         E                     English          80      1 6         F                     English          10      FAIL 1         A                     Science        70      1 2        B                      Science         30      3 3       C                       Science         50     2 4        D                     Science         40      2 5         E                     Science         40      2 6         F                     Science         50      2 1         A                     Math            70      1 2        B                      Math             80      1 3       C                       Math              90    1 4        D                     Math             50      2 5         E                     Math            50      2 1         A                     History         60      1 2        B                      History         80      1 3       C                       History         30     3 5         E                     History         80      1 6         F                     History         10      FAIL I want to cteate a output table using above data as per student name . for example if I call studant name A then it show detail  of student A like rollno studentname  subject        mark  division 1         A                     English          60      1  1         A                     History         60      1   1         A                     Math            70      1 1         A                     Science        70      1      if i call student name B the it show detail B like rollno studentname  subject        mark  division 2        B                      English          80      1 2        B                      History         80      1  2        B                      Math             80      1 2        B                      Science         30      3 As so on there is no fix no of student . Kindly help me how to write a program in macro so that if cal student name then come individual student data. Regards, Ashwini  ... View more

  have a sas datasetcustomer detail like Customerno   Customerid customername  productname productcode  porchdate CN111          111               RAM              FREEZE        PD1             09JAN2012 CN112          112               HARI             TV                  PD2            10JAN2012 CN113          113               GOPAL          FAN               PD3            04JAN2012 CN111          111               RAM              TV                  PD2            12JAN2012 CN112           112               HARI             FREEZE         PD1            13JAN2012 CN113           113               GOPAL          TV                  PD2            15JAN2012 Productcode:-PDI is FR                       PD2 is T                      PD3 is  FN I have to create a stored process .In this storeprocess  I have to create 3 dropdown selection like Customername,Productname, productcode. 1.  select customername RAM  and TRUE .       It show below detaillike Customerno   Customerid customername  productname productcode  porchdate CN111          111               RAM              TV                  PD2            12JAN2012 CN111          111               RAM              FREEZE        PD1             09JAN2012 2. selectcustomername HARI and TRUE   Customerno     CN112 Then it show like Customerno   Customerid customername  productname productcode  porchdate CN112          112               HARI             TV                 PD2             10JAN2012 CN112           112               HARI             FREEZE         PD1            13JAN2012 3. selectproductcode FR only it show Customerno   Customerid customername  productname productcode  porchdate CN111          111               RAM              FREEZE        PD1             09JAN2012 CN112           112               HARI             FREEZE         PD1            13JAN2012 4.If we select customername  HARI and TRUE                    Customerno       CN112                   Productcode       FR It show like Customerno   Customerid customername  productname productcode  porchdate CN112           112               HARI             FREEZE         PD1           13JAN2012                   Kindly help me to create this program using macro and basesas and sas sql. Thanksand Regards, Ashwini ... View more

I  have a sas datasetcustomer detail like Customerno   Customerid  customername  productname productcode  porchdate  CN111           111                RAM               FREEZE         PD1              09JAN2012 CN112           112                HARI              TV                   PD2             10JAN2012 CN113           113                GOPAL           FAN                PD3             04JAN2012 CN111           111                RAM               TV                   PD2             12JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 CN113            113                GOPAL           TV                   PD2             15JAN2012 Productcode:-PDI is FR                        PD2 is T                       PD3 is  FN I have to create a stored process .In this store process  I have to create 3 dropdown selection like Customername ,Productname, productcode. If I     select customername RAM  and TRUE .       It show below detail like Customerno   Customerid  customername  productname productcode  porchdate  CN111           111                RAM               TV                   PD2             12JAN2012 CN111           111                RAM               FREEZE         PD1              09JAN2012 If  select customername HARI and TRUE               Customerno     CN112 Then it show like Customerno   Customerid  customername  productname productcode  porchdate CN112           112                HARI              TV                  PD2              10JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 If  select productcode FR only it show Customerno   Customerid  customername  productname productcode  porchdate CN111           111                RAM               FREEZE         PD1              09JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 If we select customername  HARI and TRUE                     Customerno       CN112                    Productcode       FR It show like Customerno   Customerid  customername  productname productcode  porchdate CN112            112                HARI              FREEZE          PD1            13JAN2012                    As per mention logic how we create drop down selection instored process .using sas macro, base sas and sas sql .Kindly help me . Thanks and Regards, Ashwini ... View more

I  have a sas datasetcustomer detail like Customerno   Customerid  customername  productname productcode  porchdate  CN111           111                RAM               FREEZE         PD1              09JAN2012 CN112           112                HARI              TV                   PD2             10JAN2012 CN113           113                GOPAL           FAN                PD3             04JAN2012 CN111           111                RAM               TV                   PD2             12JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 CN113            113                GOPAL           TV                   PD2             15JAN2012 Productcode:-PDI is FR                        PD2 is T                       PD3 is  FN I have to create a stored process .In this store process  I have to create 3 dropdown selection like Customername ,Productname, productcode. If I     select customername RAM  and TRUE .       It show below detail like Customerno   Customerid  customername  productname productcode  porchdate  CN111           111                RAM               TV                   PD2             12JAN2012 CN111           111                RAM               FREEZE         PD1              09JAN2012 If  select customername HARI and TRUE               Customerno     CN112 Then it show like Customerno   Customerid  customername  productname productcode  porchdate CN112           112                HARI              TV                  PD2              10JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 If  select productcode FR only it show Customerno   Customerid  customername  productname productcode  porchdate CN111           111                RAM               FREEZE         PD1              09JAN2012 CN112            112                HARI              FREEZE          PD1            13JAN2012 If we select customername  HARI and TRUE                     Customerno       CN112                    Productcode       FR It show like Customerno   Customerid  customername  productname productcode  porchdate CN112            112                HARI              FREEZE          PD1            13JAN2012                    As per mention logic how we create drop down selection instored process .using sas macro, base sas and sas sql .Kindly help me . Thanks and Regards, Ashwini ... View more

I have dataset as mention below accountno   costomername    productname  date AC111          RAM                   FREEZE             01NOV2011 AC222          HARI                   TV                   02DEC2011 AC333          GOPAL               COOKER         12NOV2011 AC444          NISHA                 FILTER             01JAN2012 AC111          RAM                    TV                   15JAN2012 AC333          GOPAL                FILTER             27JAN2012 AC222          HARI                    FREEZ              12JAN2012 Product code is 1 for freeze 2 for   TV 3 for filter 4 for cooker I have to create  a dataset like as below mention query 1.If account no is AC111 is true the it display all the data of same account no. 2.create a dataset selecting account no and product code 3.create dataset by name      wise . I have to write a macro using above condition in one macro code. Kindly help me. Regards, Ashwini ... View more

when delimeter is , or *,&,^ we are use dlm in input . If enter charecter is a delimiter how we remove from the data. Regards, Ashwini. ... View more