Go to your options and select the output you want. Maybe no destination is selected. ... View more

@suztang wrote: The real common variable isn't actually a Char., it's a Date8., and it's Date8. in both tables. I am perplexed as this is not my first rodeo with merging and concatenating tables. Print some of the date values with a non-date format. If some of the values have decimal portion this is could happen and will not be visible when a date format like DOWNAME3 used. Date8. doesn't display anything resembling Sun, Date8 would display something like 16Mar12 and be right justified in 8 characters making it appear to have a leading space. So why did you show values like Sun????? if that is the format data example; x= 22222.01; y= 22222; put x= downame3. y= dowwname3. ; put x= date8. y= date8.; /* but obviously the values of x and y are different*/ run; And not telling sufficient detail about your data does not let us help you. I still say there is something different in the values. ... View more

https://communities.sas.com/t5/Administration-and-Deployment/How-to-Change-Encoding-from-WLATIN1-to-UTF-8-in-SAS-Enterprise/td-p/597234   https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Windowing-Environment/ta-p/597621       ... View more

proc sort data=inputdata nodupkey; by _all_; run; ... View more

Hi @ballardw, You have guess it right. mistakenly i had written Staratum instead of Stratum,means Stratum is a character one. I've resolved that issue by modifying the code posted below. Pls check. option mprint mlogic symbolgen; %macro maxtime(); %do i=1 %to &stratumcount; proc sql; select max(time) into: macro%scan(&stratum,&i.) from plotdata where event >0 and stratum="%scan(&stratum,&i.)" ; quit; %end; %mend maxtime; %maxtime(); ... View more

Unfortunately there are no exact equivalents in SAS. The closest that come to edit distances are compged and speeds functions. You have to understand that the main difference in edit distances functions is the weight that is given to operations. Unless you have SAS text miner or SAS Viya. If you have SAS Viya you can leverage python and py_stringmatching package. (AnHai Doan, Alon Halevy, Zachary Ives, “Principles of Data Integration”, Morgan Kaufmann, 2012. Chapter 4 “String Matching” (available on the package’s homepage).). You can develop these functions by yourself in SAS if you have time and patience to write your own algorithm.  ... View more

Is this the one where you wanted to call a macro and run some other code to get a value the function can return? So it looks like you want to pass in three values to your macro.  The NAME of the variable to sum and the upper and lower limits for the value of ID variable to include in the sum. So an SQL query like this could be used to get the sum into the macro variable RESULT. proc sql noprint; select sum(&varname) format=best32. into :result trimmed from MYTABLE where ID between &LOWER and &UPPER ; quit; ... View more