How do you want to display a value "within a bar" when the Bar is less than a single character thick? You also would need to consider contrast such as not attempting to display black text on a black (or other very dark color). ... View more

There is an option in GTL waterfall chart to turn off the final bar; but, unfortunately, we do not currently have it in SGPLOT. However, you can use the TMPLOUT option on the SGPLOT procedure statement to dump out the GTL template. Then, on the WATERFALLCHART statement after the "/", add this option:   display=(fill outline connect)   Run this template with PROC SGRENDER. This should give you your current appearance, minus the final bar.   Hope this helps! Dan ... View more

One way:   data want; set have; length new_name $ 100 letter $ 1; n_words = countw(name, '_'); if n_words <= 1 then return; do i=1 to n_words - 1;    letter = scan(name, i, '_');    new_name = catx('_', new_name, letter); end; new_name = catx('_', new_name, scan(name, -1, '_')); drop letter; run; ... View more

Using data for filenames always carries the risk of exceeding maximum lengths for names. In the case of files, once the complete filename (including the path) exceeds ~255 (depending on OS) characters, you'll run into a problem with the operating system.   In your example, I would skip the data step that creates the sub-dataset (which might be impossible because dataset names must not exceed 32 characters), and instead use a where= dataset option in the export step. This will work until the output filename cracks the OS limit. ... View more

You can use the isoalpha2 and isoalpha3 in mapsgfk.world_attr to do the mapping, something like this ...   proc sql;   create table a as select unique a.*, world_attr.isoalpha2 from a left join mapsgfk.world_attr on a.country=world_attr.isoalpha3;   create table a as select unique a.*, b.subj from a left join b on a.isoalpha2=b.country;   quit; run;     Obs country marks ISOALPHA2 subj 1 CAN 26 CA math 2 IND 20 IN phy 3 PHL 67 PH bio 4 USA 10 US sci   ... View more

As with anything like this, I always do manipulations outside the reporting procedure.  This keeps your dataset having everything needed (good for validation) and the reporting procedure simple (good for coding).  Plus you can manipulate things anyway you like then. data new; input name $ name1 $ marks1 marks2; datalines; abc1 abc 20 30 abc1 abc 40 10 abc2 abc 40 10 abc2 abc 40 10 bca1 bca 30 45 bca1 bca 26 28 bca2 bca 30 45 bca2 bca 26 28 ; run; data new (drop=name_sum); set new; by name; retain name_sum; if first.name then name_sum=0; name_sum=sum(name_sum,marks1); if not(last.name) then output; else do; output; name="Sum"; marks1=name_sum; output; end; run; proc print data=new; run; ... View more

Sanjay,   There are multiple products at SAS that produce word clouds.  For example, you can get them through SAS Visual Analytics as well as SAS Contextual Analysis.  What product are you wanting to view them in?   Thanks, Craig ... View more

TEMP contain the data from your txt file and make a group variable. WANT is aligning these wrong rows and get the final result you need. ... View more