I want to repeat the entore row in a SAS data set based on the following condition :     If the 'duration' of the fund is lesser then equal to 4 and type of 'base_fund' is Platinum or blank value ( which implies platinum), I need to generate additional 4 rows same as platinum row values, but changing the "base_fund' to these 4 funds 'Add_Silver', 'Silver'. 'Bronze','Add_gold'. These needs to be repeated twice based on type 'RO' and 'OT'.   I have attached the screen shot on how the raw data looks like and what I need as output for Reg_number : 8765432:   Data I have:     Data I want   I tried using repeat function and SQL, however I was not fully successful, Appreciate your quick help on this. ... View more

Hello All,    I want to check consistency between two data sets, Suppose I receive data sets month on month I want to compare  the present received data sets with the previous received on following attributes 1. To check if there is attribute named 'gender' & 'DOB' for a user and it is consistent in both the months,   The issue over here is for some of the DOB fields for a few users it is been changed from DDMMYY to MMDDYY, suppose user 1 had 12.08.1976 in 2014M02 data now it has changed to 08.12.1976 in 2014M03, I need to Identify those users which have inconistency in 2014M03 data compared with 2014M02 ( the attributes in 2014M02 is correct)   I tried with subquery using proc sql, also some proc compare, However it was not a good result.   Can anyone help me on this.   Thanks in advance           Thanks in advance   Pra ... View more

I am getting error for this code, not knowing where I am missing.   data want; data have; if centre in ('Shai','Hub','imen') and Date_of_Birth between mdy(3,01,1953) and mdy(6,30,1974) then status = 'pass'; run;     Not sure where I am missing, I tried with where as well but not succeeding, apart from that also checked with do end , But could not get the required result, Can any one help on this Thanks         ... View more

I have a dataset where I should perform transpose, the data I have look like this( have ). Data have; input Fundnumr LP Region$ Cmr_lvl     Mass$     Goldfund     Silver     Platinum Goldpremval    SilverPremval    Platinumpremval; cards; 9090024    7    ME    1    CCNl     12000      1500      500000      145      233      1343 9090025    7    PL    2    CCNA     150000      3410      750000      146      234      1344 9090026    7    SK    1    DME     300000      4389      300000      147      235      1345 9090027    7    So    2    DPN     150000      2882      750000      148      236      1346 9090028    8    NE    3    DPN     150000      2398      750000      149      237      1347 9090046    8    NW    3    CCNA     150000      2882      750000      150      238      1348 9090048    7    No    3    CCNl     150000      2882      750000      151      239      1349 9090049    7    NE    4    CCNA     150000      3410      750000      152      240      1350 9090050    3    So    -    DME     300000      3993      300000      153      241      1351 9090051    9    So    1    DPN     150000      2882      750000      154      242      1352 9090052    7    NE    1    CCNl     150000      3410      750000      155      243      1353 9090053    7    NW    1    CCNA     300000      6710      300000      156      244      1354 9090055    7    NW    2    DME     150000      2398      750000      157      245      1355 9090056    7    ME    2    DPN     150000      2170      750000      158      246      1356 9090057    8    PL    2    NBF     300000      4270      300000      159      247      1357 9090058    8    SK    3    DPN     300000      2793      300000      160      248      1358 9090059    7    So    3    DME     150000      1834      750000      161      249      1359 run; Now here I want to transpose the gold fund, Silver and Platinum into single variable called Fund, that is I want to create two new columns Value and Fund , where value as the amounts for the respective fund. and followed by that the premval for gold platinum and Silver also needs to be transposed into a new column named premval for the appropriate funds. Something like this in SAS, ( want), here all the vairables from Lp to Mass remains same for each fund number( fund number 9090024 repeating thrice for each fund once having the fundvalue transposed as fund and premval of each funds transposed into premval). Data want; input Fundnumr LP       Region$    Cmr_lvl  Mass$     Value       Fund$      Premval;   cards; 9090024      7     ME            1     CCNl      12000      Goldfund   145 9090024      7     ME            1     CCNl      1500       Silver     233 9090024      7     ME            1     CCNl      500000     Platinum   1343 9090025      7     PL            2     CCNA      150000     Goldfund   146 9090025      7     PL            2     CCNA      3410       Silver     234 9090025      7     PL            2     CCNA      750000     Platinum   1344 9090026      7     SK            1     DME       300000     Goldfund   147 9090026      7     SK            1     DME       4389       Silver     235 9090026      7     SK            1     DME       30000      Platinum   1345 9090027      7     So            2     DP        150000     Goldfund   148 9090027      7     SK            1     DME       2882       Silver     236 9090027      7     So            2     DP        750000     Platinum   1346 run; How to proceed, I tried transposing and with some If statements but was not successful. ... View more