The logic you want to implement is not clear since the second observation doesn't follow the guidelines you describe. In that observation you have two '1's! If I understand your guidelines the second observation should be 1 . . 20. Can you explain why that is not the case? ... View more

The warning and error that lead to halting og proc iml in the biplot macro NOTE: Paused in module BIPLOT. NOTE: Exiting IML. 1093 title "Biplot: &FACTYPE, STD"; 1094 1095 1096 %biplot(data = chili, 1097 var = StC NA SP PGH BH LC LS LP NFA FP CC AC SE 1098 CM FCI FCM FS FSPA FSBE FBEA 1099 FC FSr SC NSF GU PH MLL MLW PHF CWF FL FW 1100 FWt FT FPP DFt DFl DFF TSWt FPK Yd, 1101 /* removed MS CP AS NBF since these result in division by zero error */ 1102 id = Acc, 1103 factype = &FACTYPE, /* GH, COV, JK, SYM */ 1104 std = std, /* NONE, MEAN, STD */ 1105 scale = 1, /* if you do not specify SCALE=1, vectors are auto-scaled */ 1106 out = biplotFriendly,/* write SAS data set with results */ 1107 symbols = circle dot, inc = 1); NOTE: IML Ready NOTE: Module BIPLOT defined. NOTE: Module POWER defined. NOTE: Module STR2VEC defined. NOTE: Module READTAB defined. NOTE: Module READLAB defined. NOTE: Module CELLNAME defined. NOTE: Module NOMISS defined. WARNING: Division by zero, result set to missing value. count : number of occurrences is 2 operation : / at line 5035 column 115 operands : *LIT1004, S *LIT1004 1 row 1 col (numeric) 1 S 1 row 41 cols (numeric) statement : ASSIGN at line 5035 column 99 traceback : module BIPLOT at line 5035 column 99 ERROR: (execution) Invalid argument or operand; contains missing values.   See my previous post for an example that is easier to analyze. ... View more

Please run the code below and view the log. You'll see an error regarding a missing value and warnings of division by zero. data reaction; input Task $6. Topic1 Topic2 Topic3 Topic4; datalines; Easy 2.43 3.12 3.68 4.04 Medium 3.41 3.91 4.07 5.10 Hard 4.21 4.65 5.87 5.69 ; run; %biplot(var=topic1-topic4, id=task); data reaction2; input Task $6. Topic1 Topic2 Topic3 Topic4; datalines; Easy 0 3.12 3.68 0 Medium 3.41 3.91 4.07 0 Hard 4.21 4.65 5.87 0 ; run; %biplot(var=topic1-topic4, id=task); I suppose that is similar to what you get with the chili dataset. The chili dataset has a single column with only '0's and several columns with '0's as values for the variable. ... View more

Please do not attach .txt files to posts. Even simple .txt files can pose a security risk and therefore will NOT be opened by experienced security aware participants in this forum! You have the insert sas code option when you compose your post to insert code. If your code seems too BIG for the insert sas code option then create an example that can be placed in the post using the insert code option. Thank you. ... View more

Have a look at the example: discreteattrmap name="piecolors"; value "F" / fillattrs=(color=pink); value "M" / fillattrs=(color=light_blue); enddiscreteattrmap; For documentation see: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/grstatproc/p1jzx3nmuupe74n1qy54onbwjoem.htm ... View more

Do you have access to the macro code? Or is it stored in a macro library? There is a paper on understanding the macro facility that you may want to read: https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/237-30.pdf ... View more

Have a go with the code below: /* Create a sample input dataset */ data input_data; input VariableName $8.; datalines; 12345 ABCDE ; run; /* Attempt to read the input dataset with incorrect format */ data output_data; set input_data; length VariableName_num 8.; VariableName_num = input(VariableName,?? 8.); if (missing(VariableName_num)) then VariableName_num = ._; run; ... View more

I tried Tom's code on SAS OnDemand for Academics (=linux server) and got the desired result. The SAS Studio results window shows -1234.56. But the excel file is formatted correctly. I downloaded the excel file and opened it to verify. ... View more

I was able to change the sas9.cfg to change jreoptions memsize and sortsize. I verified the changes and the changes were correctly applied. In your case I would advice against changing the defaults since you have only 8gb RAM. You will always have make sure the OS has enough RAM to run. So if you would like to change then memsize could be set to 4gb and in that case jreoptions could be set to -Xmx256m -Xms1024m. I doubt that would change the outcome regarding the "Java virtual machine exception". If you want to try please let me know. ... View more

Try this link: https://support.sas.com/en/books/authors/ron-klimberg.html ... View more

Your code is confusing. In both the have and want datasets you have the column/variable 'episode'! In the have dataset you have the column 'dif_days' but you also calculate 'dif_days' for the want dataset. In the code for the want you use 'by id program' but that seems incorrect since the first observation for ID has program c and the next has program a. Please revisit your code snippets and revise them so that 'have' and 'want' have the columns you need and rethink the sort condition. ... View more

Do you want to set the jreoptions just for a single session or permanently? If for a single session you can start sas via the command prompt with something like "sas -jreoptions '(-Xmx256m -Xms256m)'" Note: you can use higher values ex 512m or even 1024m but should only do that if needed and if you have lots of RAM. The suggested value is 1/4 of the memsize option set for the sas session. If you want to create a customized configuration file please read: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/hostwin/p0bmj7wjme32ayn1h4wim7trkhp6.htm#n19ns7rwcgjykbn1ffzdy6wuy795 ... View more