Thank you @Tom  The string is exactly what I needed - first example you gave me.  Much appreciated.  ... View more

data have; input ID Greetings; datalines; 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 10 1 11 1 12 2 13 2 14 2 15 3 16 3 17 3 18 3 19 3 20 3 21 3 22 . 23 . 24 . 25 2 ; Proc format; Value Gre 1 = 'Hello' 2 = 'Hi' 3 = 'Dear' ; axis1 label=none minor=none order=(0 to 60 by 20) offset=(0,0); axis2 label=('Type of Greeting') offset=(9,9); pattern1 color=cyan; title1 h=6pct font='albany amt/bold' "Customized 3d Chart"; proc Gchart Data=have; Format Greetings Gre. ; vbar3d Greetings / discrete space=7pct width=5pct raxis=axis1 autoref cref=gray33 lref=33 maxis=axis2 type=percent outside=percent statfmt=comma5.0 ; ... View more

Thank you again @Tom This is exactly what I needed. ... View more

@Mscarboncopy - I suggest you also include @ChrisHemedinger 's link: Changes to SAS Authorization Codes (SETINITs) in your response. The important thing to note is you get your licence files at the START of your invoicing process (the Purchase Order step) and not at the END when it is actually paid, saving several weeks.  ... View more

The code for mysas was not shared. Between the first question in the thread from @paige2 thank you!  and your answer, I figured out the issue was exactly what you mentioned. I was not aware I could call files the way you showed me. Thank you so much @Tom  ... View more

@Mscarboncopy wrote: I transformed VAR1 that is being collected as character into numeric to solve my issue with leading spaces for the code you suggested I use for the merge/re-coding of the var ID. This is fake data I am entering, the data is coming from a REDCap form that is being exported as a SAS file. I use the SAS files to run through my code (The two files I mentioned before set 1 and set 2). I did not enter the values in datalines.  In the code you suggested I use, you mentioned something about a possible issue coming from a number that is too long? Could that have been it? You should not see issues with dealing with integer values of that length with SAS.  Not sure a about what REDCAP is doing internally or how they attempt to convert what they have internally into SAS datasets.  Perhaps the field length in REDCAP is limited in some way causing some truncation?  Perhaps REDCAP's idea of how to convert what they have into SAS datasets is flawed?   Look at the values for the two observations that you think should match before your attempt to convert them on the SAS side into numbers.  To really see what character variables have use the $HEX format.  That will display each byte as two hexadecimal digits.  A space will be show as hex code 20.  The digits will be hexcodes 30 to 39.  Any other hexcodes will cause trouble.   You can get some "rounding" if you where to write out that number using SAS's BEST format without enough characters to represent all of the value.  To get only one digit you would have to use BEST3. format, which would result in displaying 7E8 which when converted back into a number would become 7 with 8 zeros. 22 data test; 23 string='657,899,654'; 24 number1=input(string,comma32.); 25 string2=put(number1,best3.); 26 number2=input(string2,32.); 27 put (_all_) (=/); 28 run; string=657,899,654 number1=657899654 string2=7E8 number2=700000000       ... View more

One last thing. How do I make all of these labels a little bigger on each of the axis? Thank you! ... View more

Absolutely. Thank you. I went back and found the issue in the code where I was dropping  Source. Also, thank you for the idea you gave me of how to use source.  I really like that.  Best, ... View more

It will be MUCH easier if there is only one DATE variable. data example; input id (DATE1-DATE4) (:mmddyy.); format date1-date4 yymmdd10.; cards; 1 10/20/1999 10/20/1999 11/30/1999 12/05/1999 2 03/30/2006 05/05/2006 10/08/2006 12/12/2006 3 12/08/1998 02/02/1999 04/05/1999 05/05/1999 4 01/01/2001 02/03/2001 01/01/2001 03/30/2001 5 12/19/2003 01/08/2004 01/08/2004 06/10/2004 ; proc transpose data=example out=tall(rename=(col1=date)); by id; var date1-date4 ; run; proc sql; create table want as select a.*, b.flag from example a left join ( select id,max(count)>1 as FLAG from (select id,date,count(*) as count from tall where not missing(date) group by id,date ) c group by id ) b on a.id = b.id ; quit; proc print; run;   ... View more

Hello @Mscarboncopy  Please have a look at this paper https://www.lexjansen.com/phuse/2011/cc/CC01.pdf . This may have a solution for you. ... View more