Hi,   I was wondering if I am correct in my finding that I can't produce confidence intervals in the results output window when I use proc glmselect for a regression. I know it is typical procedure to post a question with data and code etc. but I don't really know where to start with this question. The only work around I have thought about is to use proc glmselect to grab variable names and output it to a data set, then write a macro variable that gets filtered into a proc glm command with the clm option specified after the model statement.   Any help would be great thanks.     ... View more

Hello,   I am trying to output to the results window only the fi statistics for proc glm. The only thing I have been able to do is suppress the output with ods close and output the fit statistics to a data set, but I want to see the results because eventually I would like the results to be put into excel with ods excel.   My code for what I have tried so far is as follows:   proc glm data=temp.data_set; class var1 (ref="1"); model dep_var=var1 var2 / solution; ods output fitstatistics=test2; run;   This outputs it to a dataset, but I'd rather have the results window just show the fit statistics. Any help would be great.   Thank You.     ... View more

Hello,   I have two questions in regards to adding gridlines to a specific style. I have been using the style sasweb for some reporting, and I would like to retain everything about that style with the caveat that I want the gridlines to be shown in all tables/reports instead of the classic all white background that it currently shows. I tried the code below, and it does successfully show gridlines, but doesn't retain the rest of SASWEB formatting.   My second question is, the code below overwrote the old sasweb formatting. Is there any way to restore the styles. library?   Thank You.   proc template; define style Styles.sasweb; parent=styles.excel; class body / background=_undef_; end; run;   ods excel file="test" options(sheet_name="Test") options(sheet_interval="PROC" embedded_titles="yes" embedded_footnotes="yes" embed_titltes_once="yes") style=sasweb; ... View more

Hi,   I am trying to create buckets (bins) based off of the deciles of a variable. I.e I want the first 10% to receive a 1, the 10-20% to receive a 2, etc.   Below is an example of what my data looks like:   ID      Var 1         2 2         25 3         12 4         16 5         8 6         13 7         9 8         11 9          3 10        1   And I want:   ID      Var         Bucket 1         2               2 2         25             10 3         12             7 4         16             9 5         8               4 6         13             8 7         9               5 8         11             6 9          3              3 10        1              1   I have been trying to work through the syntax using proc rank because I think that's what I want but I just can't get it. I think I am getting frustrated too easily because when I do a similar procedure in Stata it is pretty simple to grasp.   Any help would be great, thank you. ... View more

Hello, I have data that looks like :     ID     TYPE      ANSWER_1     ANSWER_2 1          A                4                      5 1          B                6                      8 1          C                3                      1 2          A                5                      5 2          B                11                    3 2          C                0                      7   And I want it to look like:   ID         a         b        c 1          4          6       3 2          5          11     0     I have been trying to mess with proc transpose, but the closest I have gotten has been:   proc transpose data=have out=want;         var   ANSWER_1 ANSWER_2;         id type;         by id; run;   This gets close, but it doesn't make the ANSWER_1 and ANSWER_2 wide.   Any help would be greatly appreciated.       ... View more

Hello,   I am trying to take a dataset that I want to use to create multiple formats in a different dataset with proc format. Below is a sample of my data:     CNTLIN dataset:   FMTNAME               START          END           LABEL Question_1                 1                    1               TEST  Question_1                 2                    2               NO TEST     Question_2                 1                    1               MALE TEST Question_2                 2                    2               FEMALE TEST  Question_A                 1                    1               YES Question_A                 2                    2               NO   data have=   ID             Question_1               Question_2             Question_A 1                    1                                1                             2 2                    2                                2                             2 3                    1                                1                             1 4                    1                                1                             1     And what I want is: ID             Question_1               Question_2             Question_A      1                    TEST                      MALE TEST            NO 2                   NO TEST                 FEMALE TEST       NO 3                    TEST                      MALE TEST            YES 4                    TEST                      MALE TEST            YES     I put the numbers intentionally at the end because some of my data do have numbers, and I know how to do this one by one using proc format and cntlin if all the FMTNAME are the same, but it's a monthly process that we would like to automate that includes hundreds of formats.   Any help would be great, thank you! ... View more

Hello,   I am trying to create a class variable based on a variable that is currently character. By class variable I mean a variable that is populated by integers which can be linked to a certain character string, but there are over 100 character strings and they change monthly so I would like to not have to manually write out lines for every one.   My data looks like this:   id_var       program_id 1                 ABC 2                 DEF 3                 ABC 4                 GHI 5                 GHI   and I want it to look like this:   id_var       program_id     prog_ind 1                 ABC                     1 2                 DEF                     2 3                 ABC                     1 4                 GHI                      3 5                 GHI                      3     In the past, I had just been doing them by hand like so:   data want; set have; if program_id="ABC" then prog_ind=1; run;   But as I said, if there is a way to make the process go quicker (in coding, not in computation speed) that would be really helpful.   Thank You ... View more

Hello,   So I have a dataset like below:   id_var     year     measures 1             2014               20 1             2015               20 2             2015               23 3             2014               17     And I want get rid of duplicate id_vars but KEEP the one with the year 2015. I know nodupkey gets rid of duplicates based on the by variable in proc sort, but i don't know how to reference the specific year value. Any help would be great.   Thanks.     ... View more