SAS Support Communities

Could somebody please give me some thoughts what do loop I should code to extract the data between String PROF so basically the output dataset should have records which are between "PROF" string as many time as it appear until it reach End of file..   TESTING DATA WHICH IS NOT VALID TESTING DATA WHICH IS NOT VALID TESING DATA             PROF YES THIS IS A RECORD YES THIS IS ANOTHER RECORD DXXXXXXXXXXXXX XXXXXXXXXXXXXXX TESTING DATA           PROF YES THIS IS A RECORD YES THIS IS ANOTHER RECORD DXXXXXXXXXXXXX XXXXXXXXXXXXXXX TESTING DATA WHICH IS NOT VALID TESTING DATA WHICH IS NOT VALID ... View more

I have two datasets and below is simple example where two datasets exist "dataset a" and "dataset b" now my objective is to do lookup using a pattern string from "dataset b" and look for matches in "dataset a" ...Tried with SQL  as below however doesn't seems to work   PROC SQL;                                   CREATE TABLE LOOKUP AS                      SELECT A.*                                  FROM TMS A,                                 FILT B                                      WHERE A.DSN LIKE B.DSN;                     QUIT;                                         Dataset A (variable name is DSN) ZZZZ.TESTRV.CATT.LENGTH.WORMTEST Dataset B(Variable name is DSN) zzzz.TEST%%.CATT.LENGTH     ... View more

Can somebody give a thought how it will be easier to get below output... I have input data as below : -------------- Input Data -------------- 53809,09,01-SEP-2015,0:15,8,1MA,1,1MB,1,1ME,2,1MF,1,2MC,1,2MD,1,2MG,1,2MH,2     53809,09,01-SEP-2015,0:30,8,1MA,1,1MB,1,1ME,2,1MF,1,2MC,1,2MD,1,2MG,1,2MH,2     53809,09,01-SEP-2015,0:45,8,1MA,1,1MB,1,1ME,3,1MF,1,2MC,1,2MD,1,2MG,1,2MH,3     53809,09,01-SEP-2015,1:00,8,1MA,1,1MB,1,1ME,3,1MF,1,2MC,1,2MD,1,2MG,1,2MH,2   And I am looking if I could have output something like below:   --------------------- Output Desired: --------------------- SUBSYS,Month,Date,Time,#Blades,1MA,1MB,1ME,1MF,2MC,2MD,2MC,2MH 53809,09,01-SEP-2015,0:15,8,1,1,2,1,1,1,1,2 53809,09,01-SEP-2015,0:30,8,1,1,2,1,1,1,1,2 53809,09,01-SEP-2015,0:45,8,1,1,3,1,1,1,1,3 53809,09,01-SEP-2015,1:00,8,1,1,3,1,1,1,1,2   So basically as you see the 1MA,1MB etc get the heading and then corresponding values get at the bottom of those 1MA,1MB ...   I see there's possibility to have it done using the Proc transpose or array can be done however don't seems to come out exactly... ... View more

  Could somebody give me idea I have following variables :     COUNT        8.                                   DATE         8.                                   MONTH        8.                         SUBSYS       8.                         TIME         8.                         VSP_DAY      8.                         VSP_MONTH    8.                         VSP_YEAR     8.   ;                                              Which I am using in below PROC Report and below report output is produced However what I am looking is to color the Cell which match the MAX column so that that clearly give me indication which month is maximum out of all those months.s   PROC REPORT DATA=BASEVSP.BREACHES  NOWD                              STYLE(REPORT)={CELLSPACING=2                                                  BACKGROUND=CXEEEEEE                                            BORDERWIDTH=3                                                  BORDERCOLOR=CX003399} /* BOFA BLUE */           STYLE(HEADER)={FONT_SIZE=4                                                    FONT_WEIGHT=BOLD                                               FOREGROUND=CX003399}                                  STYLE(COLUMN)={BORDERCOLOR=BLACK                                                    FONT_SIZE=2                                                          JUST=CENTER                                                          BORDERCOLORLIGHT=BLACK                                               BORDERCOLORDARK=BLACK};                           COLUMN SUBSYS FLAG MONTH COUNT ;                                     DEFINE FLAG     / Computed NoprinT ;                                 DEFINE SUBSYS   / GROUP 'SubSys' WIDTH=10 ;                          DEFINE MONTH    / ACROSS 'MonTh' F=mn_name. WIDTH=10 ;               DEFINE COUNT    / ANALYSIS MAX 'Max Of Months Breach' WIDTH=10;                                                                         COMPUTE COUNT;                                                       IF COUNT.MAX = COUNT THEN DO;                                        CALL DEFINE(_COL_,'STYLE','STYLE={BACKGROUNDCOLOR=RED}');                                 END;                                            ENDCOMP;                                                                 MonTh   SubSys Aug Feb Sep Max Of Months Breach 53809 N 1 N 1 55793 N 1 N 1 65239 1 N N 1 ... View more

                                                                                                          SUBSYS REPORT DATE TIME SubSys Blades Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util Blade Name Blade Util 28FEB2015 8:30 12345 4 1MA 0 1MB 46 2MC 67 2MD 49   .   .   .   . 26FEB2015 8:30 12345 4 1MA 0 1MB 27 2MC 66 2MD 55   .   .   .   . 21FEB2015 8:30 12345 4 1MA 0 1MB 41 2MC 60 2MD 44   .   .   .   . 20FEB2015 10:30 12345 4 1MA 0 1MB 46 2MC 57 2MD 60   .   .   .   .   Above is an output of the PROC REPORT after processing the data and after the "Blade Name" the next column represent the "Value for that Blade .. I was wondering if it's possible via PROC REPORT to print this data something like where we have Blade name as column heading and then Blade value...I guess similar kind of question I asked before However none of the solution work...I have requirement to use PROC REPORT becuase I am using that in the MACRO and then printing output in ODS HTML ...   ... View more