So, there are few issues with the code...but here is something that works data _null_; set sashelp.class;   if name = "Philip" then call symput("%sysfunc(cat(RSQ,23))",age); run; %put &rsq23.; So, I think you need to modify your code...something like this (see in red): data _null_; set macro_name(firstobs=1 obs=10); n+1;       call execute('proc reg data=macro_var outest=out EDF; model dPD='||name||'/noprint; run;          Data _null_;          call symput("NN",trim(left(n)));          run;          Data _null_;          set out(keep=_RSQ_ name);          call symput("%sysfunc(cat(RSQ,&NN.))",_rsq_); ... View more

I understand now. So, you could use a verison of this: proc sql;   create table want as   select a.id, a.place_time, b.remove_time,(b.remove_time - a.place_time) as diff, a.counter   from table1 a join table2 b   on table1.id = table2.id   where b.remove_time > a.place_time;   having diff le min(diff); quit; and then...take out the records you don't want... ... ... View more

So, to understand correctly, why did you pick two records for this one ID? The closest place-to-remove time would be the 11JUN2013:19:38:000    to this remove_time 11JUN2013:13:35:000, I don't understand, from your example, why the 6th of June was included? Well, here is what I had in mind: data table1; format place_time EURDFDT.;   id = 101;   counter = 1;   place_time = '06JUN2013:04:50:000'dt;   output;   id = 101;counter = 2;   place_time = '06JUN2013:04:57:000'dt;   output;   id = 101;counter = 3;   place_time = '11JUN2013:17:45:000'dt;   output;   id = 101;counter = 4;   place_time = '11JUN2013:19:38:000'dt;   output; run; data table2; format remove_time EURDFDT.;   id = 101;   remove_time = '11JUN2013:13:35:000'dt;   output;   id = 101;   remove_time = '15JUN2013:14:30:000'dt;   output; run; proc sql;   create table want as   select a.id, a.place_time, b.remove_time,(b.remove_time - a.place_time) as diff, a.counter   from table1 a join table2 b   on table1.id = table2.id   where b.remove_time > a.place_time   having diff le min(diff); quit; I am confused :smileyconfused: ... View more

Hi. You could try in SAS Tools/Options/Preferences/ The fourth Tab that says "Results", uncheck the "Create listing" button. If you want to print output to the listing file, either go back and check the button, or in your code write: ODS LISTING; Anca. ... View more

Hi. How about this: data in;   input Storm $     Value;   cards; VVV        1 AAA        2 CCC        3 BBB         4 ; data want; set in; if value ne ' '; sum+value; run; ... View more

ok, it's a bit hard for me to understand the  meaning of "mode" for categorical variables. So, what about this: DATA TEMP;   SET SASHELP.CLASS;   IF NAME = "Janet" THEN NAME = "Jane";   IF NAME = "James" THEN NAME = "Jane";   IF . <AGE < 12 THEN AGE_GRP = "< 12 yrs  ";   ELSE IF 12 <= AGE <= 13 THEN AGE_GRP = "12-13 yrs";   ELSE AGE_GRP = "> 13 yrs"; RUN; PROC FREQ DATA = TEMP;   TABLES SEX AGE_GRP;   ODS OUTPUT ONEWAYFREQS = MY_F(KEEP = F_: FREQUENCY); RUN; PROC UNIVARIATE DATA = MY_F;   VAR FREQUENCY;   WHERE F_AGE_GRP NE " "; RUN; PROC UNIVARIATE DATA = MY_F;   VAR FREQUENCY;   WHERE F_SEX NE " "; RUN; In the first step, I modify the data SASHELP.CLASS to create another categorical variable, age_grp. Then you run a frequency for the categorical variables...output a data set that will give you no:of distinct categories. Then run a univariate on it...and you get the mode (if it exists)... ... View more

Supersonic, You cannot use PROC UNVIARIATE to calculate statistics on categorical variables. However, PROC FREQ or PROC SQL can give you this information: proc freq data = sashelp.class;   table sex;   ods output OneWayFreqs = my_count; run; *in this case the 'mode' will be sex= M, since it has the highest number of occurrences? proc sql; select sex from (select sex, count(1) as count_sex from sashelp.class group by sex) having count_sex = max(count_sex); quit; ....oh,well. ... View more

Hi Eva. I, too, used the GPLOT, GCHART, and annotate for all of our graphs, and became fairly fluent with all possible options and tricks. When SG came along, I resisted switching over until I slowly got more familiar with some of the possible options in proc template. What I found to be the most useful tool is the ODS Graphics Designer, which is a menu driven tool that allows you to select the type of plot you want, the various options and what not, and provides the SAS code that produces the given plot. Once I have that code, I then adapt it more to what I need (increase the font, change colors...). I don't know of SAS plans to not use SG, but I wonder I the GPLOT, GCHART procs will become unusable with future releases?? In summary,  I would invest the time to learn the new way of graphing. Regards, Anca. ... View more

Here is a piece of code that will get what you want, but it obviously needs to be more generalized: data in; input temp_name $ temp_salary $ temp_company $10.; cards; John       $20,000 Microsoft $30,000  George  Oracle SAS       Daniel   $50,000 Sam       IBM      $60,000 ; data want; length company salary name $10.;   set in; * your data set example;   if substr(temp_name, 1, 1) = "$" then salary = temp_name;   else if substr(temp_company, 1, 1) = "$" then salary = temp_company;   else if substr(temp_salary, 1, 1) = "$" then salary = temp_salary;   if scan(temp_name, 1, " ") in ("IBM", "SAS", "Oracle", "Microsoft") then company = temp_name;   else if scan(temp_company, 1, " ") in ("IBM", "SAS", "Oracle", "Microsoft") then company = temp_company;   else if scan(temp_salary, 1, " ") in ("IBM", "SAS", "Oracle", "Microsoft") then company = temp_salary;   if substr(temp_name, 1, 1) ne "$" &   scan(temp_name, 1, " ") not in ("IBM", "SAS", "Oracle", "Microsoft") then name = temp_name;   else if substr(temp_company, 1, 1) ne "$" &   scan(temp_company, 1, " ") not in ("IBM", "SAS", "Oracle", "Microsoft") then name = temp_company;   else if substr(temp_salary, 1, 1) ne "$" &   scan(temp_salary, 1, " ") not in ("IBM", "SAS", "Oracle", "Microsoft") then name = temp_salary; run; The experts will hopefully use this (poorly written) code and make it awesome! Good luck! Anca. ... View more

If you copied that line from some PDF file or what not, sometimes hidden characters are in there that SAS won't know what to do with it. ... View more