Hello I have a sample CSV file which has 2 tabs  future and Present both the Tabs contain IDs , funds and Elect, Here I need to identify the IDs that made a different elect for future than Present. can you please guide me to write a code . one can try the transpose,and then concatenate the funds or assigning a key variable in 2 data sets future and present and then comparing both. use a merge statement , with a retain statement.I tried but aI an unable to this is just a sample I have 100 Ids in my dataset.   ... View more

Hello, I have a data in CSV format where in the account ID and type are the sources, so I want the output as from account Id take the source as AB Post-Tax and CD PRE-TAX having the amount total but then from the type I need to take the Roth Deferral and SafeMatch also as the source with the amount so where I have    567-67-4444 AB Post-Tax Roth Deferral 1,234.77   The AB Post-Tax is not to be taken instead to take the Roth Deferral and the amount reflected for the same. Please advise. the same is true for SafeMatch. This is just sample data it has 1000 rows as such so I cannot hard code.  SSN AccountID  Type Amount 123-11-2222 AB Post-Tax   1,234.00 345-45-3333 AB Post-Tax   1,235.00 567-67-4444 AB Post-Tax Roth Deferral 1,234.77 789-01-5555 CD PRE-TAX   1,254.77 321-11-1111 CD PRE-TAX   1,734.77 543-22-6666 CD PRE-TAX SafeMatch  1,834.77 ... View more

Here is a sample data set where column 1 is the ID which has the employees name and number  I only want the numbers to be outputted    ID Date Amount Robert, Andrews 222-22-1234 2019 1,234.00 Albert, Sanders 123-45-6789 2018 2,34.67 Zack, Snyder 111-22-3333 2020 1,234.77     I need the following output ID Date Amount 222-22-1234 2019 1,234.00 123-45-6789 2018 2,34.67 111-22-3333 2020 1,234.77   input ID   : $12          Year : Year.         Amount: comma13. ;   Please let me know how to only the ID numbers in the output table no names.   Thanks ... View more

I am providing a sample excel where the category section is not coming in the output as there are spaces.   I tried the different functions but I think missing something. can someone please let me know how to get the output?   Thanks ... View more

I have two data sets in one data SSN zip code and address and city are provided and in other ssn and rank codes are provided after merging both the data sets I am not get all the zip code some are missing My code is merge Data 1(in=a) Data 2 (in =b) If a; I also tried with if b but that is not what I need I need a code so that I can get all the zip codes from data 1 Please suggest ... View more

I have a table  Delinquency which has about 10 columns, one of them has about numbers 0 to 120 I need them separated out as 0-29,30-69, 70-89, and 90-120 how to write the program to get the output. Where we have to find the Tot_days naming convention is 0-29 as 0-29 ,30-69 as 30-69, 70-89 as 70-89 and 90-120 as 90-120.   ... View more

I want to add a new var as Guarantor Dependent at origination (85) or after origination (95), How do I write the code.    select   b.mktDesc,   a.acctno,   a.acctSName,   a.balToday,   a.commitment,   a.restructFlg,   GuarantorDep = '',   a.PD,   ... View more

  Can you provide me with a code that shows only the end of quarter months March ,June, September, December and moves on in the future months my data stats from 2017.so That I can use it in the drop down menu, THIS IS FOR SAS VA ... View more

  I wish to get SAS output having formulas similar to excel file. Simple formulas like '=$A$1 (Month End Date)-K10 (pdDays - Days Past Due)is there in excel. How do I write in SAS to get a new column 'Paid to' with this column  Sending a sample code. I have everything, just need the paid to the column in SAS calculations   Market Branch Officer Name CIF Account Customer  Origination Amount   Balance  PD Past Due Days Past Due Paid To Bandra 889 Frances  AB_CDE123 1234567890 MR Kumar    95,000    12,345 8 90to119 93 1/27/2018 ... View more