I recently started using the TableN macro and I wanted to say thank you to @JeffMeyers for providing such a useful macro! I was able to produce Table 1 for TM_group (which is a binary variable with values 0,1). However, I would now like to create Table 1 for subgroups based on the ADRD_group variable (which is also 0,1). The documentation for the macro indicates the COLBY option can do exactly what I'm looking for, and provides an example output table with Gender and Arm. However, I can't find good example syntax of how to add the COLBY option to the code. I've tried a few variations, but I keep getting errors. Below is my latest version.
%tablen(
data=have;
,by=TM_group
.colby=ADRD_group
,var=DEM_AGE DEM_SEX
,type=2 2
,outdoc=C:\Users\r\Desktop\TM vs MA ADRD Table 1(&version.).rtf
);
... View more
Some years ago when I installed SAS Studio 3.7 (SAS9.4M5) on Windows 10 (Single User PC Licence), I specified the JRE Location as given in this post.
https://communities.sas.com/t5/SAS-Studio/JRE-location-for-downloaded-SAS-Studio/m-p/327473
I've uninstalled SAS on my PC in order to reinstall SAS 9.4M8 which comes with SAS Studio 3.82.
The SASPrivateJavaRuntime is now named SASPrivateJavaRuntimeEnvironment.
I've tried pointed to:
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin
C:\Program Files\SASHome\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin\server
I've also tried to create a copy of the folder and name it as it was named before and test it again i.e.
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre\bin
C:\Program Files\SASHome\SASPrivateJavaRuntime\9.4\jre\bin\server
While installing SAS I also got this error which could be the reason for the issue:
I didn't find a way to rerun the installation to attent to complete this step properly.
Do you have any suggestion because I consider creating a ticket by SAS support?
... View more
Hi, I was wondering whether it is correct to analyze the dependent variable X on a Likert scale (scale 1 -5) with the independent variables TRT (1, 2, 3 and 4) and product (A, B and C) with this model: proc logistic; class trt product; model X (EVENT='1')=trt product; run; or this one: proc glm; class trt product; model X=trt product/solution; means trt product/hovtest; lsmeans trt product/pdiff adjust=tukey ; run; Thank you in advance, Alen
... View more
I'm running proc report on a proc freq output table and the resulting table looks good except the rows under the "year" headers are offset (see data example below).
The code is running without errors -- any ideas what's going wrong?
data test;
input year biomarkername $ biomarkerstatus $ count pct_row;
cards;
2017 ALK N 2716 90.8969
2017 ALK P 87 2.9116
2017 ALK U 185 6.1914
2017 BRA N 1786 92.1569
2017 BRA P 91 4.6956
2017 BRA U 61 3.1476
2018 ALK N 2839 92.3552
2018 ALK P 72 2.3422
2018 ALK U 163 5.3025
2018 BRA N 2364 92.0202
2018 BRA P 136 5.2939
2018 BRA U 69 2.6859
;
run;
options missing=' ';
proc report data=test missing;
column biomarkername year,(biomarkerstatus count pct_row);
define biomarkername / group ;
define year / across ;
run;
... View more
Hi! I am a Coursera student and I am trying to enter the JMP Lab but it says "Incorrect user name or password". I tried to reset the password but it says "Password not set successfully" and I also tried to refresh the data but it says "An error has occurred." What I can do?
... View more