cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ken_oy
‎09-01-2015
  • 128 Posts
  • 18 Likes Given
  • 0 Solutions
  • 1 Likes Received

[SQL] how to exclude a variable when doing 'select' in SQL

by Fluorite | Level 6 in SAS Procedures
‎10-10-2012 10:40 AM
‎10-10-2012 10:40 AM
hello we use (select data.*) to choose those variables we want, but how can we do a selection to choose all variables but to exclude just one variable? This question came up when i tried to merge two datasets by "id", but I got a warning msg said the "id" had already existed. Then I have to manually rewrite the 'select' statement. Any suggestion ? Thanks! se ... View more

Re: Variables in order ("retain")

by Fluorite | Level 6 in SAS Procedures
‎05-20-2012 12:01 PM
‎05-20-2012 12:01 PM
@Linlin Thanks, your code works perfectly! ... View more

Variables in order ("retain")

by Fluorite | Level 6 in SAS Procedures
‎05-20-2012 10:39 AM
‎05-20-2012 10:39 AM
I use "retain" to make variables in order. But I don't know how to do the following: I have a SAS dataset like: A1 A2 A3 ... A300  B1 B2 B3 ... B300  C1 C2 C3 ... C300; I want to make it in the following order; A1 B1 C1 A2 B2 C2 A3 B3 C3 ... A300 B300 C300; How? Thanks ... View more

Re: [proc report] Try to put 2 tables in 1 page

by Fluorite | Level 6 in SAS Procedures
‎05-08-2012 09:46 AM
‎05-08-2012 09:46 AM
Thanks Ksharp, I tried your code, but it is not working for me. There are still 5 blank lines in between two tables. I attached my output file in "reply6". ... View more

Re: [proc report] Try to put 2 tables in 1 page

by Fluorite | Level 6 in SAS Procedures
‎05-08-2012 09:44 AM
‎05-08-2012 09:44 AM
Thanks Cynthia for your reply. Sorry for not making my question clear. I want two tables on the same page vertically (one above the other) in landscape mode. And yes, you are right, if I use portrait, those two tables will not fit the paper width, and that is why I have to use "landscape". But, I have to say, in portrait mode, two tables are "one above the other on the same page", no margin between them. But in "landscape", there are 5 blank line between two tables, so the second table will be pushed to the next page. I tried Ksharp's code (TOPMARGIN=0.1cm  BOTTOMMARGIN=0.1cm ;), and it does not seem to help for my problem. I attached the link of the output file in this reply. P.S.: the same code worked just fine in SAS 9.1.3. https://www.dropbox.com/s/0qi53zk9hcdmnr1/output.rtf ... View more

Re: [proc report] Try to put 2 tables in 1 page

by Fluorite | Level 6 in SAS Procedures
‎05-07-2012 11:07 AM
‎05-07-2012 11:07 AM
Shiva, I tried your code, the paper size did change, but still, table1 in page1 and table2 in page2. But thanks for your code. ... View more

[proc report] Try to put 2 tables in 1 page

by Fluorite | Level 6 in SAS Procedures
‎05-07-2012 10:14 AM
‎05-07-2012 10:14 AM
Wrote a SAS code to make an rtf file with tables. This code works in "portrait" mode, but it does not work in "landscape". It seems SAS made more than enough "blank lines" in between tables, and pushed the second table to the next page. Is there any way to fix this? Please see the following SAS code I used. Thanks! **================================================================; ods escapechar='^'; options nodate number; ods rtf body="&result" style=styles.LNOTE bodytitle headery = 0 footery = 0  startpage = no; options orientation=landscape number nodate nobyline;   ***(portrait works here); ods rtf; proc report data=t11(obs=10) headline headskip missing nowd split='@' spacing=0              style(header column)=[protectspecialchars=off background=white]              Style(report)={borderwidth=0.01pt cellspacing=0pt cellpadding=0.5pt  vjust=bottom}              STYLE(HEADER)={ PROTECTSPECIALCHARS=off };              TITLE1 h = 10pt j = center color = black "Study (&fdate)"; title2 h = 10pt j = center color = black "Table 1. "; *footnote1 justify=left "1. OCT stent luminal area minus MicroCT stent luminal area"; footnote justify=left " "; footnote2 justify=left " "; column panel label days_0 days_1 days_2 days_3 days_4 days_5 days_6; define panel / group noprint; define label /display " "    STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.3in just=l} STYLE(header)={asis=on  just=l}; define days_0 /display "Day0"   STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_1 /display "Day1"   STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_2 /display "Day2 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_3 /display "Day3 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_4 /display "Day4 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_5 /display "Day5 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_6 /display "Day6 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; run; proc report data=t12 headline headskip missing nowd split='@' spacing=0              style(header column)=[protectspecialchars=off background=white]              Style(report)={borderwidth=0.01pt cellspacing=0pt cellpadding=0.5pt  vjust=bottom}              STYLE(HEADER)={ PROTECTSPECIALCHARS=off };              TITLE1 h = 10pt j = center color = black "  "; title2 h = 10pt j = center color = black "Table 2. "; *footnote1 justify=left "1. OCT stent luminal area minus MicroCT stent luminal area"; footnote1 justify=left "2. "; footnote2 justify=left " "; column panel label days_0 days_1 days_2 days_3 days_4 days_5 days_6; define panel / group noprint; define label /display " "    STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.3in just=l} STYLE(header)={asis=on  just=l}; define days_0 /display "Day0"   STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_1 /display "Day1"   STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_2 /display "Day2 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_3 /display "Day3 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_4 /display "Day4 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_5 /display "Day5 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; define days_6 /display "Day6 "  STYLE(COLUMN)={asis=on PROTECTSPECIALCHARS=off cellwidth=1.10in just=c}; run; ods rtf close; ... View more

plot of censored observation in K-M curve

by Fluorite | Level 6 in Graphics Programming
‎01-20-2012 05:32 PM
‎01-20-2012 05:32 PM
@Reeza: I tried the code you provided, it works. But the question is, how if we are not removing those censored symbol '+', but changing them to 'Dot's? I don't see any option for changing cencored symbols. Any help? ... View more

how to create SAS dataset in Proc iml?

by Fluorite | Level 6 in SAS Procedures
‎11-10-2011 11:15 PM
‎11-10-2011 11:15 PM
------------------------------------ PROC IML;   X={2 3,      4 5};   CREATE test2 FROM x[colname={'a' 'b'}];   APPEND FROM x; Quit; ------------------------------------ I know the above code works; But, How to make the code below work? Thanks I want to have a dataset "x" as col1  col2   1       2 NOT col1  col2   a      b -------------code with problem ----------- --------------------------------------------------- PROC IML; a=1; b=2; x={a b};   CREATE test2 FROM x[colname={'a' 'b'}];   APPEND FROM x; Quit; ------------------------------------ ... View more

creating dummy data point

by Fluorite | Level 6 in SAS Procedures
‎07-19-2011 12:29 PM
‎07-19-2011 12:29 PM
Thanks, Art's link works. ... View more

creating dummy data point

by Fluorite | Level 6 in SAS Procedures
‎07-19-2011 11:37 AM
‎07-19-2011 11:37 AM
Trying to create dummy data points for my project. Dots of time 1, 3, 4, 5 are real datapoints, I want to create dummy datapoints for every .5 hour if there is no real datapoint existed (e.g, 0 to 5 by 0.5) . Question: How to create dummy datapoints as showed in the following curves by using SAS? ... View more

Proc freq

by Fluorite | Level 6 in SAS Procedures
‎05-10-2011 01:38 PM
‎05-10-2011 01:38 PM
a 2X2 table below. N (row %) 70(89.7) 8(10.3) 62(68.9) 28(31.1) Question: Is there any way to calculate the difference, e.g. 31.1%-10.3% and its 95%CI? Thanks. ... View more

assign "Yes" "No" to variables.

by Fluorite | Level 6 in SAS Procedures
‎05-06-2011 03:24 PM
‎05-06-2011 03:24 PM
I have several binary variables (1, 2). I tried to label them all to "Yes, No". Is there any easier way to do this? I remember I used "format" statement before, but cannot recall how i did that. Don't want to use "if then" statement, too many variables. Any help? thanks! ... View more

variable names in "row 2" how to let PROC IMPORT to start from the 2rd...

by Fluorite | Level 6 in SAS Procedures
‎02-01-2011 12:11 PM
‎02-01-2011 12:11 PM
variable names in row 2, data starts from row 3 is there any option to control this? Thanks Message was edited by: Ken_oy ... View more

Re: merge "date" and "time" as a variable "date and time"

by Fluorite | Level 6 in SAS Procedures
‎09-21-2010 05:28 PM
‎09-21-2010 05:28 PM
OK, for now I fixed it with your help. 1. transfer those strings into a SAS date: sas_date=input(substr(string_date, 1, 10), mmddyy10.); 2. using data_null_'s code: it works now! Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
Likes from
View All
Quick links