i have dataset with columns from R1 to R70 along with additional columns. Values from R1 to R70 are grouped based on certain filters Like group A will be combination of R5_chk R5a_chk R5b_chk R6_chk R6a_chk Like group B will be like R7_chk to  R22_chk  and so on. if values in group is not null then i need to create a flag in below example chk_grp_a and concatanate values as shown in chk_grp_a_desc.   The below code works but i was wondering is there a efficient way to do below task using arrays?. So i dont have to specify variable names for group B or C which comprise of 15 to 30 variables.   data groupa (keep= R5_chk R5a_chk R5b_chk R6_chk R6a_chk chk_grp_a chk_grp_a_desc )  ; set wk.input_chk_rules_ed; if R5_chk ne '' OR R5a_chk ne '' OR R5b_chk ne '' OR R6_chk ne '' OR R6a_chk eq '' then do; chk_grp_a = 'Yes'; chk_grp_a_desc = CATX (' : ', IFC( R5_chk eq  '' , ' '  , vvalue(R5_chk)), IFC( R5b_chk eq '' , ' ' ,  vvalue(R5b_chk)), IFC( R5a_chk eq '' , ' ' ,  vvalue(R5a_chk)), IFC( R6_chk eq  '' , ' ' ,  vvalue(R6_chk)), IFC( R6a_chk eq '' , ' ' ,  vvalue(R6a_chk)) ); end; run; "R5_chk"  "R5a_chk"  "R5b_chk"  "R6_chk"    "R6a_chk"     "chk_grp_a "                          "chk_grp_a_desc"   abc          abc             bgcbs          jfhfg           shdg                  Yes                           abc:abc:bgcbs:jfhfg:shdg:   abc                             bgcbs                           shdg                  Yes                           abc:bgcbs:shdg   abc          abc             bgcbs           jfhfg                                   Yes                            abc:abc:bgcbs:jfhfg ... View more

Hello i have data which is combination of character, numeric and date value. i want to export this dataset in csv format. i want to enclose all character values in double quotes, numeric and date values just seperated by comma. data will also have null values for all character/numeric/date values. First line of file will have title/heading   Example data has columns like Name-Character, DOB date format mmddyy10. and Age is number format.   Desired output file   title/heading of file "Name"           ,      "DOB"        ,  "Age" "john, kalan"   ,     1/1/2017     ,     3 "john kalan"    ,                        , " "                   ,      1/1/2017    ,     3       ... View more

Hello,                     i have input file which i need to read and check the format of column in the file should be MM/DD/YYYY. If it is any other format like MM-DD-YYYY i need to flag it to remove it. What will be best possible solution?. i am using informat mmddyy10. but it reads both format which is expected. ... View more

i have to perform percent calculation using numerator and denominator. But to do that i have to calculate Numerator and Denominator first,   Sample Data   YrQtr           Metric    Month03  Month06 Month09 Month12 .......................Month60 2012Q3       deltaA        11           25            36          46                                   2012Q3       deltaB        15           40            36         24   2012Q3       deltaC        23           45            34         45 2012Q3       deltaD        23           33             44         76 2012Q4       deltaA        13           27            38          47                                   2012Q4       deltaB        18           42            38         28   2012Q4       deltaC        26           47            36         48 2012Q4       deltaD        28           36             46         78 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ...................................................................................... 2016Q1      DeltaA         4           15               23         .   So to calculate the numerator i have Logic as if month06.DeltaA <0 then 0 else Month06.DeltaA=Month06.DeltaA-Month03.DeltaA if month09.DeltaA <0 then 0 else Month09.DeltaA=Month09.DeltaA-Month06.DeltaA   So My Numerator after subtraction should look like below   YrQtr           Metric     Month06   Month09        Month12 .......................Month60 2012Q3       deltaA     25-11            36-25          46-36                                     2012Q4       deltaA      27-13            38-27          47-38                                       .   To Calculate Denominator its bit More complicated   IF 2012Q4.DeltaC,Month03 <> .[null] then  2012Q3.DeltaD,Month03-(2012Q3.DeltaB,Month03+2012Q3.DeltaA,Month03)+2012Q3.DeltaC,Month06   So it will be like 28 <>[Null] then 23-(15+11)+45       Denominator for Month06 will be 42 36 <>[null] then 33-(40+25)+34 Denominator for Month06 will be 2   YrQtr           Metric              Month06      Month09    Month12 .......................Month60 2012Q3       Denominator      42                    2                                     Percentage will    YrQtr           Metric              Month06                    Month09                   Month12 .......................Month60 2012Q3      Percentage         25-11/42                   36-25/ 2                                  ... View more