Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

SAS Discussion Forums - www.sas.com | Site profile

Site profile page for http://www.sas.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.sas.com. This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.sas.com is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: SAS Discussion Forums - http://www.sas.com SAS Discussion Forums
Url: http://www.sas.com
Users activity: 2 posts per thread
site activity: 191 active thread during last week
Site rank: 6,799 (go to rank page)
Domain info for: sas.com
 

Posting activity table on SAS Discussion Forums:

  Week Month 3 Months
Threads: 191 635 1,708
Post: 435 1,399 3,655
 

Authority Badge:

SAS Discussion Forums | Forum Authority Badge

SAS Discussion Forums posting activity graph:

Posts by:  day  week  month 
 

http://www.sas.com Alexa graph:

Top authors on SAS Discussion Forums during last week:

Name
Posts
sbb
43
user's latest post:
proc export create files with...
Published (2009-11-25 15:40:00)
Very useful SAS DOC on this topic: SAS Macro Language: Reference, Scopes of Macro Variables Special Cases of Scope with the CALL SYMPUT Routine http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/tw3514-symput.htm Scott Barry SBBWorks, Inc.
Cynthia@sas
38
user's latest post:
How do I assign HTML to be saved...
Published (2009-11-25 21:54:00)
Hi: I'm not sure what you mean by a "script". However, with SAS program code, you can absolutely direct your HTML output to a specific directory location. cynthia ods html file='c:\temp\myfile1.html'; ...sas code to generate output .... ods html close; OR ods html path='c:\temp' (url=none) gpath='c:\temp' (url=none) file='myfile2.html'; ....sas code and sas/graph code to generate...
Doc@Duke
18
user's latest post:
Concatenate SAS data rows ?
Published (2009-11-25 10:46:00)
PROC TRANSPOSE will do approximately that (it won't repeat the cell code). If you want to concatenate the raw data that way, you can do it in the DATA step. Look at the @@ notation for the PUT statement and add something like FILE myoutputfile; *that you have defined; IF lag(cell_code) = cell_code THEN PUT _infile_ @@; ELSE PUT; Doc Muhlbaier Duke
Yennie
16
user's latest post:
How do I assign HTML to be saved...
Published (2009-11-25 22:22:00)
Hey Cynthia! That's okay. I got it all sorted out! Thank you so much for your help! Cheers.
Peter.C
16
user's latest post:
URGENT: Risks of SPDS elimination
Published (2009-11-25 09:17:00)
if it does not justify itself, then you will find it hard to keep paying the licence fees. very quickly, you must find out the cost/performance impact of not having SPDS! To assess the performance cost of not using SPDS, try some of your processes using an alternate data platform. SAS/Access to some alternate rdbms (perhaps your administrators recommend/demand their site standard rdbms) will still need/cost a SAS licence fee, but you may...
jmpuseer
16
user's latest post:
How to pass a string variable as...
Published (2009-11-25 18:50:00)
Hi Guys, I am trying to pass a variable name to a Y axis column name for a Oneway chart as follows: <! col = Column(2); a = Item(1,files ,"."); b = "_test"; comb = concat Items ({a,b}); col << Set Name(comb); Oneway( Y( :Name("col_name") ), X( :Lot Number ), Box Plots( 1 ) ); ---> files is in a loop and is a string. The files name changes with the filename. I want to put the filename...
Robert Allison ...
12
user's latest post:
Major ticks in PROC GCHART
Published (2009-11-24 08:22:00)
Traditional sas/graph gcharts allow tickmarks on the response (height) axis, but not on the midpoint (bar) axis. I guess the reasoning is something like ... if you have a bar & a bar value/label at every data point, why the need for tickmarks? Also, since the bars are at discrete/categorical values it wouldn't really make sense to have tickmarks (tickmarks are for proportionally-spaced numeric ranges). If you *really* need tickmarks...
Flip
12
user's latest post:
update dataset
Published (2009-11-25 14:35:00)
Are all birth years for a given provider the same? That would seem strange. If not, you need more identifying info such as a patient identifier. If they are then a 'distinct' on the select might help. The message is self explanitory. You are trying to update a single value with more than one result. Your subquery must return a single row.
Chris@SAS
11
user's latest post:
How do I add a SAS editor...
Published (2009-11-24 16:15:00)
Okay, okay. The magic number is.... 6 Recommend that you set the properties in this order (assuming you like your log view to be read-only): editor.ReadOnly=true; editor.SetLanguage(6); Chris
abdullala
8
user's latest post:
Concatenate SAS data rows ?
Published (2009-11-25 11:17:00)
this is a quite unique request that all fields need to be replicated. I can not think of any one-step way to achieve that. 1. sort the data and assign a unique ID to each records within a cell_code. 2. output to 2 separate datasets with this ID and change variable names. 3. merge the 2 new datasets using proc sql, with value of original cell_code. or if you need to really 'concatenate' those fields, you may first concatenate all 4...
 

Top 10 active forums on SAS Discussion Forums during last week:

SAS Procedures - 97 new posts SAS Procedures
 - forum profile
ODS and Base Reporting - 65 new posts ODS and Base Reporting
 - forum profile
SAS Enterprise Guide - 47 new posts SAS Enterprise Guide
 - forum profile
JMP Software - 47 new posts JMP Software
 - forum profile
SAS Macro Facility, Data Step and SAS Language Elements - 44 new posts SAS Macro Facility, Data Step and SAS Language Elements
 - forum profile
SAS/GRAPH and ODS Graphics - 28 new posts SAS/GRAPH and ODS Graphics
 - forum profile
SAS Statistical Procedures - 18 new posts SAS Statistical Procedures
 - forum profile
SAS/IML and SAS/IML Studio - 8 new posts SAS/IML and SAS/IML Studio
 - forum profile
SAS Stored Processes - 5 new posts SAS Stored Processes
 - forum profile
SAS and Clinical Trials - 4 new posts SAS and Clinical Trials
 - forum profile
 

Top 10 forums on SAS Discussion Forums:

SAS Macro Facility, Data Step and SAS Language Elements - 3,656 posts SAS Macro Facility, Data Step and SAS Language Elements
 - forum profile
SAS Procedures - 3,124 posts SAS Procedures
 - forum profile
ODS and Base Reporting - 2,902 posts ODS and Base Reporting
 - forum profile
SAS Enterprise Guide - 2,765 posts SAS Enterprise Guide
 - forum profile
SAS Stored Processes - 1,111 posts SAS Stored Processes
 - forum profile
SAS and Clinical Trials - 1,043 posts SAS and Clinical Trials
 - forum profile
JMP Software - 890 posts JMP Software
 - forum profile
Integration with Microsoft - 619 posts Integration with Microsoft - forum profile
SAS Statistical Procedures - 497 posts SAS Statistical Procedures
 - forum profile
Mathematical Optimization and Operations Research with SAS - 325 posts Mathematical Optimization and Operations Research with SAS
 - forum profile

Latest active threads on SAS Discussion Forums:

SAS Discussion Forums
Started 2 days, 2 hours ago (2009-11-25 12:13:00)  by Flip
A starting point. proc sql; update datatable set birthdate = (select birthdate from source_table where **match criteria**); Quit;
Forum:  SAS Macro Facility, Data Step and SAS Language Ele... SAS Macro Facility, Data Step and SAS Language Elements
 - forum profile
Thread:  Show this thread (7 posts) Thread info: update dataset Size: 269 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: update dataset :: SAS Macro Facility, Data Step and SAS Language Ele... :: SAS Discussion Forums"
SAS Discussion Forums
Started 1 day, 11 hours ago (2009-11-26 02:58:00)  by Linus H
Since most persons in this forum is not R experts, I think you have do explain how you want the comparison between a single value and a vector should be done, preferable using some example data. /Linus
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (2 posts) Thread info: Proc Sql question Size: 320 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Proc Sql question :: SAS Procedures
 :: SAS Discussion Forums"
SAS Discussion Forums
Started 2 days, 5 hours ago (2009-11-25 08:57:00)  by sbb
Suggest the following Google advanced search to find technical conference papers on the topic: proc report calculate percentage column site:sas.com Scott Barry SBBWorks, Inc.
Forum:  ODS and Base Reporting ODS and Base Reporting
 - forum profile
Thread:  Show this thread (4 posts) Thread info: How to calculate right percentage using across function in proc report? Size: 319 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to calculate right percentage using across function in proc report? :: ODS and Base Reporting
 :: SAS Discussion Forums"
SAS Discussion Forums
Started 1 day, 15 hours ago (2009-11-25 22:51:00)  by twocanbazza
Have you got "SAS/Access to oracle" installed?
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (2 posts) Thread info: Assigning Oracle Library in SAS 9.2 Size: 152 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Assigning Oracle Library in SAS 9.2 :: SAS Procedures
 :: SAS Discussion Forums"
SAS Discussion Forums
Started 1 day, 16 hours ago (2009-11-25 21:54:00)  by Cynthia@sas
Hi: I'm not sure what you mean by a "script". However, with SAS program code, you can absolutely direct your HTML output to a specific directory location. cynthia ods html file='c:\temp\myfile1.html'; ...sas code to generate output .... ods html close; OR ods html path='c:\temp' (url=none) gpath='c:\temp' (url=none) file='myfile2.html'; ....sas...
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (4 posts) Thread info: How do I assign HTML to be saved to my desired directory ? Size: 1,534 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How do I assign HTML to be saved to my desired directory ? :: SAS Procedures
 :: SAS Discussion Forums"
SAS Discussion Forums
Started 3 days, 23 hours ago (2009-11-23 14:54:00)  by mpb
Is this what you are trying to do? (Script assumes the Fitness data is current). <! New Window( "Box Plots", V List Box( Textbox("Box Plots"), Oneway( Y( :Oxy ), X( :Sex ), Box Plots( 1 ) ), Oneway( Y( :MaxPulse ), X( :Sex ), Box Plots( 1 ) ) ) ); --> P259 of the JMP Scripting Guide has a slightly more complicated example which illustrates this kind of thing. I ...
Forum:  JMP Software JMP Software
 - forum profile
Thread:  Show this thread (9 posts) Thread info: How to append two box plots to same box? Size: 1,132 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to append two box plots to same box? :: JMP Software
 :: SAS Discussion Forums"
SAS Discussion Forums
Started 2 days, 1 hour ago (2009-11-25 12:49:00)  by sbb
To start, can you identify what the file-extension will be with the command below, when executed: X " move /y project&num..xls &prj_nam. "; /* Rename The file */ Also, you may want to get that sticky QUESTION_MARK key looked at. Scott Barry SBBWorks, Inc.
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (7 posts) Thread info: proc export create files with missing extension " xls" Size: 414 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: proc export create files with missing extension " xls" :: SAS Procedures
 :: SAS Discussion Forums"
 

Hot threads for last week on SAS Discussion Forums:

SAS Procedures
Started 2 days, 3 hours ago (2009-11-25 10:37:00)  by KevinC.
Let me be more clear.. The first two rows before concatenation: NR800 1 12/07/2009 N NR800 1 12/07/2009 Y After: NR800 1 12/07/2009 N NR800 1 12/07/2009 Y Thanks.
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (11 posts) Thread info: Concatenate SAS data rows ? Size: 338 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Concatenate SAS data rows ? :: SAS Procedures
 :: SAS Discussion Forums"
ODS and Base Reporting
Re: SAS Data to Excel - 10 new posts
Started 1 week, 4 days ago (2009-11-16 05:24:00)  by Peter.C
have a look at http://support.sas.com/rnd/base/ods/odsmarkup/exce lxp_demo.html
Forum:  ODS and Base Reporting ODS and Base Reporting
 - forum profile
Thread:  Show this thread (14 posts) Thread info: SAS Data to Excel Size: 264 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: SAS Data to Excel :: ODS and Base Reporting
 :: SAS Discussion Forums"
JMP Software
Started 3 days, 23 hours ago (2009-11-23 14:54:00)  by mpb
Is this what you are trying to do? (Script assumes the Fitness data is current). <! New Window( "Box Plots", V List Box( Textbox("Box Plots"), Oneway( Y( :Oxy ), X( :Sex ), Box Plots( 1 ) ), Oneway( Y( :MaxPulse ), X( :Sex ), Box Plots( 1 ) ) ) ); --> P259 of the JMP Scripting Guide has a slightly more complicated example which illustrates this kind of thing. I ...
Forum:  JMP Software JMP Software
 - forum profile
Thread:  Show this thread (9 posts) Thread info: How to append two box plots to same box? Size: 1,132 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to append two box plots to same box? :: JMP Software
 :: SAS Discussion Forums"
ODS and Base Reporting
Started 1 week, 2 days ago (2009-11-18 09:19:00)  by Flip
First of all move the ODS open command inside you macro. You are opening a file once and closing it 95 times.
Forum:  ODS and Base Reporting ODS and Base Reporting
 - forum profile
Thread:  Show this thread (8 posts) Thread info: ods tagsets.EXCELXP whit macro var Size: 216 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: ods tagsets.EXCELXP whit macro var :: ODS and Base Reporting
 :: SAS Discussion Forums"
JMP Software
Started 2 weeks ago (2009-11-13 10:43:00)  by _Stig_
Sometimes the simplest things can be mindboggling in JSL Here are a couple of approaches: new column("test",formula( as column("column 1")*2 )); or a = "column 1"; new column("test",formula( a[]*2 )); The logic of the syntax is something like this. In the first example we want to treat "column 1" as a column of numbers. In the second example, "[]" indicates that a is...
Forum:  JMP Software JMP Software
 - forum profile
Thread:  Show this thread (14 posts) Thread info: JSL: Creating formula using a variable column name Size: 682 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: JSL: Creating formula using a variable column name :: JMP Software
 :: SAS Discussion Forums"
ODS and Base Reporting
Started 1 week ago (2009-11-20 12:35:00)  by DerekM
Oops.. there's a missing ENDCOMP; between the END; and the RUN; in the code I typed here. I don't get what I'm trying for when I don't have syntax errors.
Forum:  ODS and Base Reporting ODS and Base Reporting
 - forum profile
Thread:  Show this thread (7 posts) Thread info: Compute block processing/debugging Size: 342 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Compute block processing/debugging :: ODS and Base Reporting
 :: SAS Discussion Forums"
ODS and Base Reporting
Started 4 days, 5 hours ago (2009-11-23 08:54:00)  by sbb
Please explain "the output doesn't run as well as wanted." And also share your SAS code. Scott Barry SBBWorks, Inc.
Forum:  ODS and Base Reporting ODS and Base Reporting
 - forum profile
Thread:  Show this thread (7 posts) Thread info: How to solve variable length problems in output using proc report Size: 241 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: How to solve variable length problems in output using proc report :: ODS and Base Reporting
 :: SAS Discussion Forums"
SAS Procedures
Started 3 days ago (2009-11-24 13:43:00)  by sbb
I expect you would want to declare the SAS macro variable names you are using as %GLOBAL variables - then you can use these macro variables in your code, but only after executing the OPTIONS statement as you identified and then by also invoking %FREQ; -- after the %GLOBAL references (or add the %GLOBAL to your FREQ macro code). Suggest you use this Google advanced search ...
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (7 posts) Thread info: Storing and Resusing Macros Size: 1,005 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: Storing and Resusing Macros :: SAS Procedures
 :: SAS Discussion Forums"
SAS Macro Facility, Data Step and SAS Language Elements
Re: update dataset - 7 new posts
Started 2 days, 2 hours ago (2009-11-25 12:13:00)  by Flip
A starting point. proc sql; update datatable set birthdate = (select birthdate from source_table where **match criteria**); Quit;
Forum:  SAS Macro Facility, Data Step and SAS Language Ele... SAS Macro Facility, Data Step and SAS Language Elements
 - forum profile
Thread:  Show this thread (7 posts) Thread info: update dataset Size: 269 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: update dataset :: SAS Macro Facility, Data Step and SAS Language Ele... :: SAS Discussion Forums"
SAS Procedures
Started 2 days, 1 hour ago (2009-11-25 12:49:00)  by sbb
To start, can you identify what the file-extension will be with the command below, when executed: X " move /y project&num..xls &prj_nam. "; /* Rename The file */ Also, you may want to get that sticky QUESTION_MARK key looked at. Scott Barry SBBWorks, Inc.
Forum:  SAS Procedures SAS Procedures
 - forum profile
Thread:  Show this thread (7 posts) Thread info: proc export create files with missing extension " xls" Size: 414 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Re: proc export create files with missing extension " xls" :: SAS Procedures
 :: SAS Discussion Forums"