i have a group of book seller and they have certain amount of books to sell by the end of year. We have already set monthly targets  i want to get how many books they have to sell every week to get to get to the monthly target. Example:They have a target of 35% for jan how many books do they have to sell every week to reach that target. The weekly predict number should as more or less books are sold. if the sold less than their expected book than their next weeks number should be higher and if they sold more than expected than their next week number would be lower.  data   Name ID Total Books unsold books  sold books Jon J55 456 426 30 Adam J79 386 357 29 Rob J34 523 476 47 Tom J91 350 332 18 Dustin J28 450 425 25 Nancy J44 343 324 19   Target:  Month Monthly_target january  35% february 50% march 62% april 71% may 78% june 84% july 88% august 92% september 94% october 96% november 98% december 100%   want: Name ID Total Books unsold books  sold books weeks  pred_sold  Jon J55 456 426 30 6-Jan …. Jon J55 456 426 30 13-Jan …. Jon J55 456 426 30 20-Jan … Jon J55 456 426 30 27-Jan … Jon J55 456 426 30 3-Feb   Jon J55 456 426 30 10-Feb   Jon J55 456 426 30 17-Feb   Jon J55 456 426 30 24-Feb   ... View more

I have a data set were few variables are repeating but i only want to keep info for a specific variable    Have:    Name      ID           Code       code_description    type Sarah      0007       A19            DM test                mining Sarah      0007       B45            DM test                 list  Jack        1111        F56            HPY type 1            mining Jack        1111        H78            HPY type 1            list    Want  Name      ID           Code       code_description    type   ..             ..            A19            DM test                mining Sarah      0007       B45            DM test                 list  ..               ...           F56            HPY type 1            mining Jack        1111        H78            HPY type 1            list    so i want to delete the name and ID or just place a zero or none  for mining when that data is repeated like this.  ... View more

proc sql; create table want as select * from have where MEM_ID not in (select MEM_ID from have1); run; i have MEM_ID and item_id in both tables the sas code deletes all MEM_ID however i want to match both MEM_ID and item_id not just MEM_ID as the code i have is delecting data i dont want to delete  ... View more

I have a long number in my data and when do Ods Excel to send out the excel in an email the number is shown as significant digits in excel, is there a formatting i can do to show the whole number  110001234567= 1.10001E+11   ... View more

I have a data set thats being created weekly however i need to use the last weeks data set before its updated again. Is that something i can do in the same SAS code??  ... View more