Hello everyone, I want to merge two datasets, having a common variable. However, I don't want them to merge completely. For example, the first dataset is like this: Table 1 StudentID Date Test_Score1 TEST_score2 test_score3 * * * * * The other dataset contains these variables: Table 2 StudentID Field_of_interest Undergradute_field Master_field $ $ $ $ The studentID is the common variable. But I want to add just one variable (Field_of_interest) from table 2 to table one. Is there any way to not merge two tables completely? I appreciate any suggestion. ... View more

Hello everyone, I have 180 delimited datasets and want to import them. These files are named monthly. For example: Stockprice_1998_01, Stockprice_1999_02, ... , Stockprice_2014_06. My question is that how I can write a macro statement or even a do loop to import all the datasets and not write the proc import statement for each dataset. Any suggestion would be greatly appreciated. Thanks ... View more

Dear everyone, I tried to merge two datasets, using "proc sql". Two datasets have two common variables: ID and Sharetype. Below is my code: proc sort data=Institution by ID Sharetypr; proc sort data=Stock; by ID sharetype; run; proc sql; create table Institution_Stock as select L.*, R.* from Institution as L LEFT JOIN Stock as R on L.ID=R.ID and L.sharetype=R.sharetype; quit; The sort part is run without any error, but when I run the proc sql I receive this error: "ERROR: Sort execution failure." I have no idea what's the problem. I appreciate if you help me. ... View more

Dear all, I want to find the mean of different group in my data set and create a variable for the mean. I would appreciate if you suggest a solution to my problem. Suppose I have the below data set: Name of Company Class of Stocks Date Stock Price XXX A 10/20/14 100 XXX A 9/20/14 110 XXX A 8/20/14 105 XXX B 10/21/14 120 XXX B 9/21/14 122 XXX B 8/22/14 124 XXX B 11/21/14 127 XXX C 10/20/14 130 XXX C 9/20/14 133 XXX C 8/20/14 137 YYYYY A 10/20/14 102 YYYYY A 9/20/14 108 YYYYY A 8/20/14 104 YYYYY B 10/21/14 115 YYYYY B 9/21/14 113 YYYYY B 8/22/14 110 YYYYY B 11/21/14 118 YYYYY C 10/20/14 121 YYYYY C 9/20/14 126 YYYYY C 8/20/14 122 As you see, I have the stock price of different class of stocks for some firms, at different time. Now I want to find out the average stock price for each class of stocks ( and create a separate variable for the mean amount. In other word, I need to reach to the below table: Name of Company Class of Stocks Date Stock Price Averageprice XXX A 10/20/14 100 105 XXX A 9/20/14 110 105 XXX A 8/20/14 105 105 XXX B 10/21/14 120 123.25 XXX B 9/21/14 122 123.25 XXX B 8/22/14 124 123.25 XXX B 11/21/14 127 123.25 XXX C 10/20/14 130 133 XXX C 9/20/14 133 133 XXX C 8/20/14 136 133 YYYYY A 10/20/14 102 104.6666667 YYYYY A 9/20/14 108 104.6666667 YYYYY A 8/20/14 104 104.6666667 YYYYY B 10/21/14 115 114 YYYYY B 9/21/14 113 114 YYYYY B 8/22/14 110 114 YYYYY B 11/21/14 118 114 YYYYY C 10/20/14 121 123 YYYYY C 9/20/14 126 123 YYYYY C 8/20/14 122 123 In table above for different dates of each type of stocks is shown in the averageprice column. I tried the following code: proc sql; create table Average_price as select *, mean (Stock price) as Averageprice from Stock_price; quit; However, the result just shows the total average, not the average price for specific class of a certain company's stocks. Thanks for your help. ... View more

Hi everyone, I have what is probably a very easy question, but I can't seem to find the solution after searching for a while. I would appreciate any and all suggestions to my problem below: I have two data sets and want to merge them with the common variable they have, date. In one data set the year includes the year month and date, the other data set includes just the year and month. For example Data Set 1 would have 196801 for January 1968, and Data Set 2 would say 19680131 for January 31, 1968. What I need to do is "chop off" the dates in the second data set, so that it only shows 196801 instead of 19680131. I want to do this because I want SAS to know that these two data sets have a common variable, so that I can merge them into one. Thanks in advance! ... View more