You would need to transpose long to wide using arrays. Here is a post about it: https://communities.sas.com/t5/SAS-Programming/Long-to-wide-Array/td-p/158600   ... View more

Here is another way: https://communities.sas.com/t5/SAS-Programming/Quote-and-Unquote-a-list/m-p/205514#M38206 But you would need to use proc sql to make a list anyways, so your way could be more convenient in this case. The macro from this post is better when you provide a random typed list that is not a variable. ... View more

To change the width of the date format you would need to change the number before the dot in the format statement. Say you have format date9. Its width is 9, so it will show today's date with 9 spaces like 06Jun2022. You can see for yourself by submitting this SAS code and checking the log: data _null_; dt=today(); format dt date9.; put dt ; run; If you would like to change the width to 7, the format would be date7. Now today's date will appear as 06Jun22. ... View more

It would be easiest to output the graphs in power point then add the asterisks manually: ods powerpoint file ="path to file/name.pptx"; ...your code here... ods powerpoint close; ... View more

There is PROC PYTHON ... View more

Does PROC CONTENTS show that the variable exists? ... View more

You are right @Tom , there are hidden parenthesis around v1 and v2 because of sequential evaluation. That decouples v3 condition from v1 condition. So v3=3 can be true on its own in (A). In (B), SAS first looks inside the parenthesis to see if either condition is true. If v3=3, that is not enough because then SAS checks the v1 condition which must also be true. ... View more

You can use a month function, month(), to extract the month from that variable. ... View more

Yes, you can make a dynamic format. For example, you have a number 7.4245. It uses six spaces including one for the decimal point and has 4 digits after the decimal point. Therefore, the format that would fit that number perfectly is 6.4. If you want to round it dynamically to one digit less than the last where the last digit can be any location, like 7.42455555…, you would need to specify the format &mvar_a.&mvar_b using variables a and b and putting them into macro variables mvar_a and mvar_b: a =  length(number) b = length(substring(number, index(‘.’)) minus however many digits you would like to hide Call symputx(mvar_a, “a”); Call symputx(mvar_b, “b”);     ... View more

I see, there is also CATS. CATS is kind of like CATX. Now what is the difference between CATS and CATX... https://documentation.sas.com/doc/en/vdmmlcdc/1.0/lefunctionsref/n0p7wxtk0hvn83n1pveisbcp2ae9.htm ... View more

The solution could use a method from this post: https://communities.sas.com/t5/SAS-Programming/How-to-find-flag-the-second-to-last-observation-by-ID/td-p/749175 ... View more

The comparisons are treating the variables as strings, but some of the variables are numeric, so that produces an error. Start with a dataset that includes only variables Result_1 - Result 25. f you specify a _character_ keyword in the array statement like "array c _character_; " the comparisons will work. The numeric variables are already clean, they cannot contain any special characters. If you would like to go over the numeric variables and set anything below 5 to 1, you can specify "array n _numeric_; do over n; if n < 5 then n = 1; end;". ... View more

When a function's name ends with an 'x' it strips leading and trailing blanks. For example, cat('a','  b  ') = 'a  b  ', while catx('a','  b  ') = 'ab'. Similarly, call symput("var", "  MWSUG  ")  puts "  MWSUG  " into macro variable var, while call symputx("var", "  MWSUG  ") strips the leading and trailing blanks, putting "MWSUG" into macro variable var. The 'x' functions did not become available until version 9. The older way to strip the blanks was to nest the input parameters in a strip() function, so something like cat('a', strip('  b  ')) would be equivalent to catx('a', '  b  ').  ... View more