Hi,   I want to compare the table1 column (‘Var’) values with another table2 variable name based on key. If match then update the values from table1 ‘new_values’ to table2 which match above column.   Table1: Key1 Var New_values 1234 Value1 1 4674 Value2 9 5732 Sim_ind 6 6342 Value3 3   Table2: Key1 Value1 Value2 Value3 Sim_ind 1234 3 2 2 3 4674 6 5 4 4 5732 2 3 6 2 6342 1   1 5   Output should be Key1 Value1 Value2 Value3 Sim_ind 1234 1 2 2 3 4674 6 9 4 4 5732 2 3 6 6 6342 1   3 5     Thanks ... View more

Hi ,   I want to replace the one column values into another column for selected PTYPE values.   For PTYPE FQHC,LAB Ii want to move the values from Sunday_Dir to Sunday_PO  and Monday_Dir to Monday_PO.   ptype Sunday_Dir Sunday_PO Monday_Dir Monday_PO FQHC 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM LAB 09:00AM-06:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM CHC 09:00AM-07:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM 09:00AM-07:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM PERS 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM   Need Data as below:   ptype Sunday_Dir Sunday_PO Monday_Dir Monday_PO FQHC 09:00AM-05:00PM 09:00AM-05:00PM 09:00AM-05:00PM 09:00AM-05:00PM LAB 09:00AM-06:00PM 09:00AM-06:00PM 09:00AM-05:00PM 09:00AM-05:00PM CHC 09:00AM-07:00PM 09:00AM-07:00PM 09:00AM-07:00PM 09:00AM-07:00PM PERS 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM 09:00AM-05:00PM 00:00PM-00:00PM 00:00PM-00:00PM 00:00PM-00:00PM   Thanks in advance.   ... View more

Hi,   I want to remove the string ' ,' from the column Code.   ID                      CODE 1 ,ABD 2 ,VBG 3 ,NMJ,KJH,LKJ 4 ,TYU,IOU,DEF 5 ,TYY 6 ,JKK 7 ,LKJ 8 ,MKL Output Should be as below: 1 ABD 2 VBG 3 NMJ,KJH,LKJ 4 TYU,IOU,DEF 5 TYY 6 JKK 7 LKJ 8 MKL   Thanks for your help ! ... View more

Hi ,   I have a data set that has the ID, Business,LOB,ACTSIZ. like below example   data DATA;   length id $ 5 Business $ 2 LOB $ 3; input id $ Business LOB $ ACTSIZ; datalines; 12340 01 RTY 23 12341 20 TYR 0 12341 30 1UY 8 12343 30 CBP 8 12343 30 MTS 8 12343 30 HPL 8 12343 45 HFI 6 12343 45 HFS 6 45673 01 RTY 40 45673 30 IUY 24 45673 30 CBP 24 45673 30 IUY 24 45673 30 CBP 24 ; run;   I was summing ACTSIZ column group by id to get the totalsize and output looks like below ,which is wrong (seprate each id by line for easy readability):: id Business LOB ACTSIZ Totalsize 12340 01 RTY 23 23 12341 20 TYR 0 8 12341 30 1UY 8 8 12343 30 CBP 8 36 12343 30 MTS 8 36 12343 30 HPL 8 36 12343 45 HFI 6 36 12343 45 HFS 6 36 45673 01 RTY 40 136 45673 30 IUY 24 136 45673 30 CBP 24 136 45673 30 IUY 24 136 45673 30 CBP 24 136   If the business id and actual size repeat more than once (LOB will be different) then count the actual size one time toward total size. Business want the output like below (seprate each id by line for easy readability): id Business LOB ACTSIZ Totalsize  12340 01 RTY 23 23 12341 20 TYR 0 8 12341 30 1UY 8 8 12343 30 CBP 8 14 12343 30 MTS 8 14 12343 30 HPL 8 14 12343 45 HFI 6 14 12343 45 HFS 6 14 45673 01 RTY 40 64 45673 30 IUY 24 64 45673 30 CBP 24 64 45673 30 IUY 24 64 45673 30 CBP 24 64   Note: actual dataset has 150 columns and we need all those column in the output, so we can't use nodupkey option.   Thank you so much for your help.   -Sudha. ... View more

Hi ,   I have a report that will run on first of the every month.I want to exclude the future month effective date from the report. April month report should not include members with effective date  April, May, etc.     Membno Effdat    Expdat 1        20140301  20141231 2        20170401  20170430 3        20170105  20170130 4        20170301  20170330 5        20170501  20170528   I have the format as YYMMDDN8. for the Effdat and EXPDAT field.   Output should be as below:   Membno Effdat    Expdat 1        20140301  20141231 3        20170105  20170130 4        20170301  20170330   Thanks for your help. ... View more

Hi ,   I have a dataset that needs to identify the office hours that has opened after 5 PM. If any of the office hour days that has opened after 5pm needs to create an Indicator Y ; if not indicator has to display as N.    data test; input Monday $1-15 Tuesday $16-31 wednesday $32-47 Thursday $48-64 Friday $65-79 Saturday $80-96 Sunday $97-111; datalines; 08:00AM-05:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-03:00PM 08:00AM-03:00PM 08:00AM-06:00PM 08:00AM-02:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:30AM-02:30PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-06:00PM 10:00AM-02:30PM 08:00AM-02:00PM 08:00AM-06:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 09:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 08:00AM-02:00PM 04:00AM-09:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-05:00PM 08:00AM-06:00PM ; run;   My code: data after_5pmHours; set test; Monday1 = input(substr(Monday,9,2), 8.); if Monday1 = 12 and substr(Monday,14,2) = 'PM' then Indicator = 'N'; else if Monday1 > 5 and substr(Monday,14,2) = 'PM' then Indicator = 'Y'; else Indicator = 'N'; run;   Thanks for your help       ... View more

Hi, I have requirement to compare two monthly extracts which has same varibales, but values may be changed between two datasets. I need to extract an observation that has different value in nay variable compare to last month dataset. For example below:      DATA SasConf; INFILE DATALINES; INPUT ID ConfName $ ConfYear ConfCity $ ConfST $ ; DATALINES4; 1 SUGI 2006 San Francisco CA 2 PHARMASUG 2006 Bonita Springs FL 3 NESUG 2006 newyork NY 4 WUSS 2006 Irvine CA 5 SESUG 2006 Atlanta GA 6 SCSUG 2006 Irving TX 7 MWSUG 2006 Dearborn MI 8 SUGI 2007 Orlando FL ;;;;   DATA SasConf2; INFILE DATALINES; INPUT  ID ConfName $ ConfYear ConfCity $ ConfST $ ; DATALINES4;  1 SUGI 2006 San Francisco CA 2 PHARMASUG 2006 Bonita Springs FL 3 NESUG 2006 Philadelphia PA 4 WUSS 2006 Irvine CA 5 SESUG 2006 Atlanta GA 6 SCSUG 2006 Irving TX 7 PNWSUG 2006 Seaside OR 8 NESUGI 2007 Orlando FL ;;;;   Compare these two datasets and the output datset should have following obervations: 3 NESUG 2006 Philadelphia PA 8 NESUGI 2007 Orlando FL   Note: there is primary key (ID) in the dataset, so any variable value can be different, so need to select the observation which is changed from the last month.  is the way that we can do this on the data step (don’t want to use proc compare).   Thank you for all your help.   ... View more