Hello Everyone,    I have a dataset which contain 2 variable , Locality and Customer address, Due to some reasons, Some values for 'locality' in the dataset doesn't match with customer address.   For example in my dataset I have an observation where Locality mentioned as Borough Park ( NY) But the actual Customer location is Kensington (NY).   I need to read the data in Customer address and change the value for locality if it doesn't match with Locality.    How can I do it in sas programming?      ... View more

Hi, I need to use proc tabulate for creating a summary report, I’m having issues getting report to come out as desired, please do have check, bellow is the desired O/P.  Sample data is attaed as  datastep version, attached with this. Please do have a look.  The variables used in the output table is   probability= Probability Nbr_of_Optys = No of deals for probability level Tot_Budget  =sum( Total media values for Probability level) Tot_Forecast = Tot_ Budget * Probability /100   The desired output     Probability Nbr_of_Optys Tot_Budget Tot_Forecast 100 7 $171,675,000 $171,675,000 90 4 $205,000,000 $184,500,000 70 8 $264,000,000 $184,800,000 50 20 $127,040,000 $63,520,000 30 3 $2,450,000 $735,000 10 319 $333,729,670 $33,372,967           361 1103894670 638602967     Please help.  ... View more

Hi whomsoever it may concern;   I have a Large mobile usauge dataset with 400+ coloums and 10000 observations , from which I have to create a subset with varibles valuse corresponding to the months "June, July and august" using proc sql. How do I can do it? As I know it can be done using macros, But I'm having hard time to do it with proc sql. I do welcome any suggestions or Idea, thank you.  ... View more

Hi,  I need to update the variable from one dataset with another variable from second dataset, I have tried Proc SQL update command. but couldn't able to get it, I'm a beginner in proc sql.      I have 2 data sets with 2 variables in it,    DATASET_A.   ID   Value 1      10 1      11 1      23 2     11 2     98 2     54 3    10 3    30 4   44 DATASET_B   ID   Value 1      25 2     54 3    13   Now I need to update the values of DATASET_A with DATASET_B. So the desired output will be    ID   Value 1      25 1      25 1      25 2     54 2     54 2     54 3    13 3    13 4   44   I have tried with the code    proc sql; update DATASET_A  set value=(select value from DATASET_B  where DATASET_A .value=DATASET_B.value) where ID in (select ID from DATASET_B); quit;   Its giving me " ERROR: Subquery evaluated to more than one row."   what does it mean? Any help?   ... View more