03-22-2017
jacob_klimek
Obsidian | Level 7
Member since
08-20-2015
- 39 Posts
- 0 Likes Given
- 1 Solutions
- 2 Likes Received
-
Latest posts by jacob_klimek
Subject Views Posted 6363 01-26-2017 08:26 AM 6412 01-23-2017 10:01 AM 2258 01-18-2017 02:26 PM 2267 01-18-2017 02:13 PM 5947 01-03-2017 10:31 AM 5949 01-03-2017 10:25 AM 1779 11-03-2016 09:59 AM 12594 11-01-2016 10:07 AM 1569 10-11-2016 03:55 PM 3323 09-16-2016 09:03 AM -
Activity Feed for jacob_klimek
- Got a Like for Retain Column Percentage for Proc Freq Output Table with Three Variables. 06-19-2022 10:53 AM
- Got a Like for Percentile Buckets using Proc Rank. 11-29-2017 01:37 PM
- Posted Re: Proc GLMSelect and confidence intervals on Statistical Procedures. 01-26-2017 08:26 AM
- Posted Proc GLMSelect and confidence intervals on Statistical Procedures. 01-23-2017 10:01 AM
- Posted Re: Proc GLM only show fit statistics on SAS Procedures. 01-18-2017 02:26 PM
- Posted Proc GLM only show fit statistics on SAS Procedures. 01-18-2017 02:13 PM
- Posted Re: ODS Excel Gridlines on ODS and Base Reporting. 01-03-2017 10:31 AM
- Posted ODS Excel Gridlines on ODS and Base Reporting. 01-03-2017 10:25 AM
- Posted Indicator Variable for Data Breakoff on SAS Programming. 11-03-2016 09:59 AM
- Posted Percentile Buckets using Proc Rank on SAS Procedures. 11-01-2016 10:07 AM
- Posted Proc Transpose Help on SAS Procedures. 10-11-2016 03:55 PM
- Posted Re: Proc Format with a dataset that has multiple formats on SAS Procedures. 09-16-2016 09:03 AM
- Posted Re: Proc Format with a dataset that has multiple formats on SAS Procedures. 09-16-2016 09:02 AM
- Posted Proc Format with a dataset that has multiple formats on SAS Procedures. 09-15-2016 05:37 PM
- Posted Create a class variable based on another variable's values on SAS Programming. 07-26-2016 01:17 PM
- Posted Re: Proc Sort and nodupkey to keep dups based on another variable on SAS Procedures. 07-14-2016 05:16 PM
- Posted Proc Sort and nodupkey to keep dups based on another variable on SAS Procedures. 07-14-2016 05:08 PM
- Posted Re: Contiguous CBSA Identification on Graphics Programming. 06-02-2016 02:31 PM
- Posted Contiguous CBSA Identification on Graphics Programming. 06-02-2016 01:26 PM
- Posted Retain Column Percentage for Proc Freq Output Table with Three Variables on SAS Procedures. 06-01-2016 08:54 AM
-
My Liked Posts
Subject Likes Posted 1 06-01-2016 08:54 AM 1 11-01-2016 10:07 AM
01-26-2017
08:26 AM
Great thanks this is more or less what I was looking for.
... View more
01-23-2017
10:01 AM
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
01-18-2017
02:13 PM
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
01-03-2017
10:31 AM
Just realized I can just clear out of my session for the second part. Still can't figure out the first part however.
... View more
01-03-2017
10:25 AM
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
11-03-2016
09:59 AM
Hello,
I am trying to create an indicator variable to filter some observations out and count how many observations I need. Basically, what I have is this:
data have=
ID answer
1 99
1 22
1 53
1 99
1 99
1 99
2 34
2 57
2 99
2 99
2 99
2 99
What I want is for times when 99 is the last recorded answer to go back as far as the 99s go back to have a new variable mark it as a 1.
ID answer indicator
1 99 0
1 22 0
1 53 0
1 99 1
1 99 1
1 99 1
2 34 0
2 57 0
2 99 1
2 99 1
2 99 1
2 99 1
I know how to get a 1 for all of the 99s, but the part where it's only the last one going back I don't know how to get. Any help would be great.
Thanks.
... View more
11-01-2016
10:07 AM
1 Like
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
10-11-2016
03:55 PM
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
09-16-2016
09:03 AM
I think I have the right set up for the dataset. Where I am struggling is just in the application part. The only time I have ever used formatting has been for one format at a time applied to one variable at a time, but I want this to do it for hundreds of variables each with their own independent formatting.
... View more
09-16-2016
09:02 AM
I think I have the right set up for the dataset. Where I am struggling is just in the application part. The only time I have ever used formatting has been for one format at a time applied to one variable at a time, but I want this to do it for hundreds of variables each with their own independent formatting.
... View more
09-15-2016
05:37 PM
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
07-26-2016
01:17 PM
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
07-14-2016
05:16 PM
Oh wow, duh thanks. I guess I have been working too much in Stata...
... View more
07-14-2016
05:08 PM
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