Please help...   Here is a very basic version of my problem (though what I'm actually trying to do is a lot more complicated, I think this shows my issue).    I have names with a single quote in them, and I can't seem to use them for anything because it messes with SAS.     data userlist; infile datalines delimiter=','; length user $ 20 name $ 50; input user $ name $; datalines; username, user na'me run; data _null_; set userlist; call symput("user", user); call symput("name", name); run; %put User is &user; %put Name is %str(&name);   This code doesn't actually cause an error for me in SAS EG 7.13 (SAS 9.4), but if you put more code after it you will get an error as it's treating everything after the &name as part of a string.     I can't for the life of me work out how to get the apostrophe to work, as to use %str I need to put a % by the ', and if I do this by inserting it into the string it doesn't seem to work.   The context is that I have names (some of which contain apostrophes) in a data set, and I'm looping through them and using a macro to display a title with their name in it, and a table for that person. I'm trying to pass the apostrophe'd names into the macro to be displayed, but I simply can't work it out.   Thanks in advance.   ... View more

Sometimes when using SAS EG 7.13 I try to run a program and the task status panel shows "Status: Connecting to server". I'm using a local server, connecting to data sets on a network drive. It gets stuck at this point and will not continue. I have tried restarting the PC but this does not help. I have tried multiple programs in different projects and none of them run. If I run the program from another PC it works fine.    What causes this problem and how can I fix it? Thanks in advance. ... View more

First off, I'm very new to SAS, and I've inherited a large program that creates all sorts of wonderful graphs. We upgraded to SAS 9.4 and now all the graphs are blurry (there are lots of other issues with this program, but let's take it one at a time).   The program uses ODS to output to HTML, with the setup looking like this:   ods graphics on / reset = all imagename = 'img1' imagemap = on ; ods listing close; * Close default output destination; ods tagsets.msoffice2k_x path = "&path" file = "graph.html" /* Destination file for output*/ gpath = "&path\GRAPHS" /* Location for graphic output*/ style = statistical /* ODS Style template */ options ( panelcols="1" /* Number of columns in sheet */ ); Note that although it is exported to HTML, the final dsestination is an Excel spread sheet (there is a later step that combines a bunch of documents into one excel book).   There is then lots of other code but I believe the step that actually outputs is the proc sgplot step, which appears to have nothing that changes formatting.   Basically, from what I can tell, it's using the "statistical" style without any changes.   The output is a vertical bar chart with the number for each bar being shown above the bar in small text (see attached image - zipped because PNG isn't an allowed format...). From searching on Google I have found that I can change the template, and I believe I need to be changing the GraphDataFont property. I have tested the other similar properties that affect the font and found that when I change them, I see a change in the graph. But when I change GraphDataFont, it does not change at all. Whether I set it to 1, 10, or 100, it looks exactly the same. Changing the other similar properties affects other areas but none that I could find affect this text.   Can anyone suggest what I could try to boost the size of this text? I set image_dpi on the ODS output to get the rest of the graphs larger but this text above each bar stays small and blurry. I have tried switching to using ODS EXCEL but this did not help.     ... View more