Because of variable length limits, etc., I simply renamed all variables:
i_01
i_02
i_03
But each variable really should be associated with a longer, more descriptive name:
Abc.......
Def.......
Ghi.......
I've imported the dataset using the simple variable names. But I'd like to somehow 'import' the longer respective names as 'labels'. Can that be done? If so, how?
Thanks,
Nicholas Kormanik
... View more
Hi, I try to run proc traj and the trajplot command runs a graph saying that traj group 1 is 21.09% and group 2 78.90%. proc traj data=TLS out=out outstat=os outplot=op;
ID SER_NO4; VAR sleep01-sleep02; INDEP year01-year02;
MODEL CNORM; MIN 0; MAX 24; NGROUP 2; RORDER 1;
run;
%trajplot (OP, OS, “Title of graph”,“Subtitle”, “Y-axis label”, “X-axis label”); However, if I run the code below. It shows group 1 is 12.27% and group 2 87.73%, which is different from above. proc freq data=out;
table group; run; Is there anyone who knows why? and how can I solve this issue? Thank you in advance for your help.
... View more
Hello In a typical SAS 9.x environment, users often create datasets etc. that can be permanently stored on a physical disk. (Local, shared etc.) Moving to SAS Viya 4 on AWS I am exploring the options where a user can get the same experience and store the data on some form of permanent storage disk. (Content server, database excluded). This could be a storage on AWS itself. Wondering if somebody can enlighten me about the options available.
... View more
Can you tell me what is wrong with this code?
*OTHER NEUROLOGICAL DISEASES; array xx $ icdx1 icdx2 icdx3; label ond="Oth neurological"; ond=0; do over xx; if xx in: ("B90", "D48", "G04", "G09", "G10", "G11", "G12", "G13", "G24", "G25", "G26", "G32", "G37", "G51", "G52", "G53", "G70", "G71", "G72", "G73", "G80", "G81", "G82", "G83", "G90", "G91", "G93", "G95", "G99", "M47", "Q00", "Q01", "Q02", "Q03", "Q04", "Q05", "Q06", "Q07", "Q76") then ond = 1; *Doing exclusions in this way does not work; if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", "G733", "G734", "G838") then ond=0; end;
The first part works fine. But then when I add in the line of code under *Doing exclusions in this way does not work; I get the following error messages:
*Doing the exclusions in this way does not work; 509 if xx in: ("G130", "G131", "G251", "G254", "G256", "G510", "G732", _ 22 202 509 ! "G733", "G734", "G838") then ond=0; ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
510 end;
Please help! Thanks!
... View more
As I detailed in this post I'm trying to make a "Table 1" summary table and another additional table of descriptive statistics for dozens of variables. Generating the proper results is relatively easy. But rearranging those results for dozens of variables and putting them into a well-organized summary table takes a lot of code. The TableN macro does this extremely well, but it doesn't have a provision to add weights.
Before I go any further, has anyone else ever run into this issue? I'm hoping there may be a modified version of the macro that can include weights.
First and foremost, I need to add the person weight variable PUFFWGT. I believe all of the procs used in the macro (such as PROC MEANS, PROC FREQ, PROC UNIVARIATE, etc.) can include a WEIGHT statement for the person weight.
For simplicity sake, I'm attempting to hardcode PUFFWGT into these procedures. However, I'm discovering that the macro takes the input dataset, extracts key variables, and divides them into multiple files that each have a standard format that is specific to the macro. The datasets to which the Procs are actually applied no longer have the weight variables or any of the original variable names. The varnames and labels are presumably added back in at the end. So I can't just add the weight statement, because the weight variable is no longer there.
... View more