SAS Support Communities

onpoint1 · ‎08-26-2013

Hi -- I've been programming HEDIS using SAS for years. I realize you posted this quite a while ago and you may be all set, but if not, let me know.

onpoint1 · ‎06-13-2013

This doesn't do what the bosses requested, but at least the data is available on the chart: proc sgplot data=figure2; yaxis label=' ' discreteorder=data valueattrs=(family='calibri' size=8pt style=normal) ; xaxis discreteorder=data label = ' ' valueattrs=(family='calibri' size=8pt style=normal) ; vbar group / response = col1 group = name grouporder=data barwidth=0.4 datalabel=col1 datalabelpos=bottom datalabelattrs=(family='calibri' size=6pt style=normal); keylegend / noborder location=outside position=top across=2 valueattrs=(family='calibri' size=7pt style=normal); run; It seems logical from the documentation that the datalabelpos=data option should label the data sections, it just doesn't. I've seen other similar questions on various Communities boards but no easy answers. Is Annotate the only option? If anyone knows a great simple solution, I'd still like to see it.

onpoint1 · ‎06-12-2013

Is there a command to put data labels in each bar of a chart? This is what I have: proc sgplot data=figure2; yaxis label=' ' discreteorder=data valueATTRS=(family='calibri' size=8pt style=normal); xaxis discreteorder=data label = ' ' valueATTRS=(family='calibri' size=8pt style=normal); vbar group / response = col1 group = name grouporder=data barwidth=0.4 datalabel=col1 datalabelpos=data; keylegend / noborder location=outside position=top across=2 valueATTRS=(family='calibri' size=7pt style=normal); run; Using this code gives me the value from the first segment of the stacked bar, at the top of the bar. Using datalabel by itself gives the grand total at the top. I need each segment to have it's own label, and some segments are too small for the value, so it would need to be off to the side. Is there a way to do this? Thanks

onpoint1 · ‎05-21-2013

The banner is a 1 inch section at the top of each page of the report. On the left is the logo, on the right are text values such as GROUP: &groupname LOCATION: &locname. Under the banner is a line delineating the banner from the rest of the document. Could you please show an example? There are so many ODS PDF references. Thanks

onpoint1 · ‎05-21-2013

I'm totally new to EG (ver 5.1) and need some help putting all the pieces of a Report together that will run multiple iterations. First I need to add a banner to the top of the report that will change with each iteration of the data: i.e Group: Acme Athletics Location: Smallville Type: Senior The data is being created by Group, but from multiple programs, and the Report is a combination of graphs and text. I feel like I need one big macro to bundle it all together, plus add the touches like Group name, Location, etc. Of course each part has to be a specific font and Color. There is also a logo in the Header area -- that was added by referencing a .jpeg file in the Image section of Report> Header/Footer. As each Group report is created, they need to be saved to a .pdf named for each group. Any help would be appreciated. Thanks

onpoint1 · ‎04-04-2013

Just curious....why do some procs (PRINT,FORMAT) use RUN; while others (SQL; DATASETS) use QUIT; ?

onpoint1 · ‎04-02-2013

Okay, the final, final answer and solution from Martin @sas.support: When invoking SAS, if you get notes such as the following: NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead. NOTE: All registry changes will be lost at the end of the session. NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead. NOTE: All profile changes will be lost at the end of the session. The cause is typically due to either corrupt profile files in SASUSER or incompatible profile files in SASUSER. For example, if you happen to be running the 64-bit version of SAS but you are using old profile files created with the 32-bit version of SAS (perhaps via a previous install), then you will get the notes above. In this case, your only option is to follow the steps I sent in my previous email to rename all of the files in SASUSER (so when starting up a new SAS session, SAS will recreate the profile files from scratch). Also note that you will get the note statements above when invoking multiple SAS sessions on the same Windows machine (since only the very first invocation of SAS will have write/update access to SASUSER). However, if you constantly get the notes above when only invoking a single SAS session, then you will have to rename all of the profile files in SASUSER. submit the following statements to SAS: proc options option=sasuser; run; Look in the SAS log and jot down the Windows directory that SASUSER points to. Then, exit SAS. Using Windows Explorer, open the Windows directory that SASUSER points to. In this directory, locate the following files: profile.sas7bcat profile2.sas7bcat profbak.sas7bcat templat.sas7bitm regstry.sas7bitm If any of the files above exist in this directory, rename them to: profile.old profile2.old profbak.old templat.old regstry.old Then, restart SAS and let me know if this does not resolve the original issue.

onpoint1 · ‎04-02-2013

Finally found a .txt file that thought it was still open, despite exiting SAS and rebooting multiple times. Once that file was deleted the Copy /Paste works again as normal.

onpoint1 · ‎03-29-2013

thanks Tom -- at first I was thinking that couldn't be the issue because the table only has 5 rows and 3 columns. However, I did have to abort a copy and paste yesterday (when the problem first happened) when I realized the table was too big. I'll bet something is still hung up from that ctrl/break, Cancel submitted statements, etc. Wonder why shutting SAS down didn't clear it out? I'll try rebooting and check my Temp space.

onpoint1 · ‎03-29-2013

For years, I've been able to Copy to Clipboard small datasets and Paste into Excel. The Copy part still seems to work, but Paste in Excel creates a table outline but no data. The log looks normal,although I've never paid much attention to it before: 51 filename _temp_ clipbrd; 52 ods noresults; 53 ods listing close; 54 ods html file=_temp_ rs=none style=minimal; NOTE: Writing HTML Body file: _TEMP_ 55 proc print data=Work.'Rx_output'N noobs; 56 run; NOTE: There were 5 observations read from the data set WORK.RX_OUTPUT. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 57 ods html close; 58 ods results; 59 ods listing; 60 filename _temp_; NOTE: Fileref _TEMP_ has been deassigned. Is there some setting that I've accidentally triggered in either SAS or Excel? When I paste into Notepad, I get the full text of html commands. I don't use ods, so not sure if there is something to change there. I've closed both SAS and Excel and restarted but no difference. Help would be appreciated!

onpoint1 · ‎03-14-2013

We don't yet have SAS/GRAPH and are considering purchasing. Can you describe the process (short version) to add vertical error bars around a series of points? These will be confidence intervals around the mean. Would this be GPLOT or GCHART or other? Anything else we should know? Thanks

onpoint1 · ‎04-12-2010

Yes, targcont has been taken out of the STRATA. The target group has already been defined - I'm trying to find a control group with the same characteristics. As I learn more about this PROC I doubt this is what I want to use, but it has been interesting. Thanks.

onpoint1 · ‎04-12-2010

I need to create a control group that has the same characteristics as the target population. I can use the following to get a random sample: PROC SURVEYSELECT DATA=sel OUT=target METHOD=SRS SAMPRATE=.5 SEED=2; STRATA momage gravidity fplgr smoke med_rsk lowwt bmi marstat; RUN; However, this is code from a different programmer and I don't really know what it's doing. This is the Target dataset, a second dataset has the universe of non-selected members for the Control group. Is there a better method? Is there anything I should adjust? Thanks

onpoint1 · ‎04-09-2010

I need to create a control group that has the same characteristics as the target population. I used the following: PROC SURVEYSELECT DATA=HOME.F0468_MOMS OUT=MOMSAMPL METHOD=SRS SAMPRATE=.5 SEED=2; STRATA TARGCONT MOMAGE GRAVIDITY FPLGR SMOKE MED_RSK LOWWT BMI MARSTAT; RUN; However, this is code from a different programmer and I don't really know what it's doing. TARGCONT is the flag that distinguishes Target and Control groups. Is there a better method? Is there anything I should adjust? Thanks

Online Status	Offline
Date Last Visited	‎06-25-2019 02:41 PM

SAS Support Communities

Re: HEDIS diagnosis and procedure codes/programs

Re: data labels in each section of sgplot stacked bar

data labels in each section of sgplot stacked bar

Re: Add a Banner to Report with dynamic variables

Add a Banner to Report with dynamic variables

basic question: Run; vs Quit;

Re: Copy to clipboard from Explorer window will not Paste

Re: Copy to clipboard from Explorer window will not Paste

Re: Copy to clipboard from Explorer window will not Paste

Copy to clipboard from Explorer window will not Paste

Re: HEDIS diagnosis and procedure codes/programs

Re: data labels in each section of sgplot stacked bar

data labels in each section of sgplot stacked bar

Re: Add a Banner to Report with dynamic variables

Add a Banner to Report with dynamic variables

basic question: Run; vs Quit;

Re: Copy to clipboard from Explorer window will not Paste

Re: Copy to clipboard from Explorer window will not Paste

Re: Copy to clipboard from Explorer window will not Paste

Copy to clipboard from Explorer window will not Paste

Graphing points with error bars

Re: Selecting comparable populations

finding comparable populations

Selecting comparable populations

Follow Us

What is...