So my data looks something like this (sample data, not actual). where 1=yes and 2=no and then a group variable 1/2. All these have formats (so var, yes/no and group with group names)     So in this case, I want to calculate the row percentage of each variable for each group and then graph only the %yes   The percentage that I have calculated in my excel graph example would be from the proc freq results. I have about 200 vars, of course now 200 variables would be on one graph). So I am wondering is there a way to streamline/automate this?   ... View more

If I drop the No data, wouldn't the % be impacted?    Since I want the percentages of "Yes" within the variable for that group...   Is there a way I can make SAS create a bar graph of just numbers? I am thinking if I can use proc freq with an out= option and keep only the percentage of yes within that dataset and graph that? ... View more

SAS 9.2, I can't provide the raw dataset.   I am looking for the general approach I should use so I can code this myself. ... View more

Yeah we need to specify the the correct covariance structure.  I ran it with VC as the covariance structure and the covtest indicates it is not the correct structure.  So I am trying a few others hopefully.    We have baseline, 3mo, 6mo and end of study visit. But the study was ended early due to adverse events. So the end of study visit varies (some was before the 3 mo visit, which means missing 6mo visits,  some subjects had the 3 mo visit and were never heard of again..etc.). this data is very messy sadly. I will look into the spatial power covariance structure or a splined covariance structure as you suggested ... View more

With the missing values, but there is a record for the missing value, can I cosnider my data balanced? ... View more

Lvm,   thanks for your response... Even though it is a continious variable, I should put the time variable in the class statement?   I think the data is unbalanced, since patients do miss visits. But I did create a record for them. So if take a look at my sample table below, Patient 3 missed his 2nd visit. Because of this, can I treat this as balanced?   And to confirm, this is ok to do where there are missing duration (since patients skip visits) and the durations varies (so for example ID=1 and ID 2 had different durations for visit 2.   For example: ID Visit Duration 1 Visit 1 0 1 Visit 2 53 2 Visit 1 0 2 Visit 2 40 3 Visit 1 0 3 Visit 1 .   Also, I seem to run into a memory issue when using "repeated time / subject=subject type=un;"  It worked fine when setting the covariance structure to VC, but I need to set it to UN. Any thoughts on how to fix this? NOTE: 438 observations are not included because of missing values. ERROR: Unable to allocate sufficient memory: a request for 1954142K bytes exceeded the 786430K available. Note that the deficit amount may not be the amount of memory needed for a successful run, since it does not reflect subsequent allocations by this or other processes. ERROR: The SAS System stopped processing this step because of insufficient memory. NOTE: PROCEDURE MIXED used (Total process time): real time 0.34 seconds cpu time 0.04 seconds   ... View more