As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Difference between revisions of "Talk:Main Page"

From sasCommunity
Jump to: navigation, search
(How to add 24 hours to an existing time field: new section)
(Undo revision 56682 by Nicolekristen (talk) This looks like a rather sophisticated search engine optimisation exercise and is the third posting of this text by this user on this wiki.)
 
(23 intermediate revisions by 6 users not shown)
Line 1: Line 1:
 +
''This page is to discuss the content of the [[Main Page]]. ('''Off topic postings get removed.''')''
 +
*Go to [[Employment opportunities]] and complete the form if you have [[Employment opportunities|a job to list]].
 +
*Go to [[Create an Article]] and complete the form if you want to [[contribute|submit a new article or paper]].
 +
*Go to [[Tip of the Day:Submitting a Tip|Submitting a Tip]] and complete the form if you [[contribute|have a new tip for us]].
 +
*Go to [[Post an Idea for sasCommunity.org]] and [[contribute]] your ideas.
 +
*If you want to discuss or provide feedback about an article then use that article's discussion page.
 +
*If you want to communicate with another user then use their talk (discussion) page.
 +
*If you want to make an announcement then you can use your own user page.
 +
*If you are [[Help:Seeking help|seeking help]] then first read the article about asking [[questions]].
 +
*If you have [[feedback]] then read [[Contact Us]], first.
 +
*To discuss the [[Main Page]] edit one of the topics below or add a topic by using the [http://www.sascommunity.org/mwiki/index.php?title=Talk:Main_Page&action=edit&section=new Add Topic link] at the top of the page.
 +
 +
==Closed discussions==
 +
===Registered trademark symbol===
 
Shouldn't the little "R" in a circle appear in banner_text.gif and in the first text reference? funct
 
Shouldn't the little "R" in a circle appear in banner_text.gif and in the first text reference? funct
  
 
-----
 
-----
 
+
===Search function===
 
It would be nice if the SEARCH function were visible more toward the top of the main page, so that it would be easier to find when someone just viewed the main page --[[User:Hamer|Hamer]] 11:45, 17 March 2008 (EDT)
 
It would be nice if the SEARCH function were visible more toward the top of the main page, so that it would be easier to find when someone just viewed the main page --[[User:Hamer|Hamer]] 11:45, 17 March 2008 (EDT)
  
 
-----
 
-----
 
+
===Categories===
 
How about putting CATEGORIES as a selection on the left menu?--[[User:NancyWilson|Nancy]] 13:13, 17 March 2008 (EDT)
 
How about putting CATEGORIES as a selection on the left menu?--[[User:NancyWilson|Nancy]] 13:13, 17 March 2008 (EDT)
  
 
-----
 
-----
 
+
===Hierarchical structure===
 
Since a Wiki is self-configurable (I mean that we the users can do what we want to it, without waiting for a webmaster to do it for us), that should mean that if we the users wish, we could impose a hierarcical structure on it in order to make it easier to navigate it, but of course, users would not have to use the hierarchary, but of course, gardners could move things around.  --[[User:Hamer|Hamer]] 15:51, 17 March 2008 (EDT)
 
Since a Wiki is self-configurable (I mean that we the users can do what we want to it, without waiting for a webmaster to do it for us), that should mean that if we the users wish, we could impose a hierarcical structure on it in order to make it easier to navigate it, but of course, users would not have to use the hierarchary, but of course, gardners could move things around.  --[[User:Hamer|Hamer]] 15:51, 17 March 2008 (EDT)
  
== About Category ==
+
=== About Category ===
  
 
I agree with Nancy in putting the 'category' item on the main menu.  To find categories now, I looked at 'tool box-> special pages'. I'm not sure how one would update the main menu, so it may be something that admin folks can do. --[[User:CJac|CJ]] 15:44, 3 June 2008 (EDT)
 
I agree with Nancy in putting the 'category' item on the main menu.  To find categories now, I looked at 'tool box-> special pages'. I'm not sure how one would update the main menu, so it may be something that admin folks can do. --[[User:CJac|CJ]] 15:44, 3 June 2008 (EDT)
Line 22: Line 36:
 
This was answered/addressed on [[Where did Hamer go?‎]]. --[[User:Donh|Don Henderson]] 22:07, 17 March 2009 (EDT)
 
This was answered/addressed on [[Where did Hamer go?‎]]. --[[User:Donh|Don Henderson]] 22:07, 17 March 2009 (EDT)
 
----
 
----
 +
 +
=== Employment opportunities ===
 +
 +
Please go to the [[Employment opportunities]] page to list any [[employment opportunities]]. If you list your employment opportunity here it will not be registered. - [[User:Cameron|Cameron]] 22:21, 25 September 2012 (EDT)
 +
 +
=== Removed topics ===
 +
Here is where some recently removed topics have gone. [http://www.sascommunity.org/mwiki/index.php?title=Talk:Main_Page&action=history View history] for more details. - [[User:Cameron|Cameron]] ([[User talk:Cameron|talk]]) 21:35, 29 April 2017 (CDT)
 +
*''‎PR/Advertizing sasCommunity.org at SAS Global Forum'' moved to [[Talk:SAS Global Forum]]
 +
*''‎How to add 24 hours to an existing time field'' moved to [[User_talk:Erinroze]]
 +
*''‎Connecting to SQL Server via SAS ODBC'' moved to [[User_talk:Patwary8]]
 +
*''‎Question: problem with input statement'' moved to [[User_talk:Darpnew]]
 +
*''Text of an employment opportunity with Cognigen Corporation'' moved to [[User_talk:Cawalawan]], with a request to list these as [[employment opportunities]] it if still open.
 +
*''‎i m adding a new topic on this website'' moved to [[User_talk:Shaktisoftek]], with advice to list as [[employment opportunities]] instead.
 +
*''‎How to add variable in target metadata'' moved to [[User_talk:Kumardthakur]] with advice to provide more explanation.
 +
*News about ''‎Cisco and SAS ...'' removed as [[sasCommunity:inappropriate content|inappropriate content]]. (Breach of copyright and also terms of use.)
 +
 +
=== Towards a tidy talk page ===
 +
 +
I think this talk page needs to be tidier. The page should be a discussion about the content of the [[Main Page]], rather than a public forum.
 +
*Questions from [[sasCommunity:Helping other users|users seeking help]] should be moved to the respective user's talk page if a response is provided, rather than being left here.
 +
*Users listing employment opportunities should be directed to list there instead.
 +
*Ideas, suggestions and general comments about the sasCommunity should be moved to a more relevant wiki page.
 +
*Old comments and discussion should be moved to an archive area once they are no longer relevant.
 +
*The remaining discussion(s) should be [[wiktionary:refactor|refactor]]ed.
 +
- [[User:Cameron|Cameron]] ([[User talk:Cameron|talk]]) 00:12, 29 April 2017 (CDT)
 +
: Good points [[User:Cameron|Cameron]], you have the experience, would you like to take a stab at it? --[[User:ArtCarpenter|Art Carpenter]] ([[User talk:ArtCarpenter|talk]]) 02:35, 29 April 2017 (CDT)
 +
:: I have already made a start by moving several sections to users talk pages. Though it looks like an edit conflict has just undone some of the changes I have made here recently, so that might mean I need to repeat a little bit of work. - [[User:Cameron|Cameron]] ([[User talk:Cameron|talk]]) 02:51, 29 April 2017 (CDT)
 +
:::The talk page is a bit tidier now. - [[User:Cameron|Cameron]] ([[User talk:Cameron|talk]]) 19:53, 29 April 2017 (CDT)
 +
 
== About Weekend Wiki Work/TIPs ==
 
== About Weekend Wiki Work/TIPs ==
 
I'm noticing that a daily tip was not available for today. . . . What about having a weekend wiki study assignment (HomeWork as it were.)  For example here is one:
 
I'm noticing that a daily tip was not available for today. . . . What about having a weekend wiki study assignment (HomeWork as it were.)  For example here is one:
Line 33: Line 76:
 
::I'll work on it in my spare time; easy to do. -- [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 15:06, 23 June 2015 (CDT)
 
::I'll work on it in my spare time; easy to do. -- [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 15:06, 23 June 2015 (CDT)
 
----
 
----
 
== Employment opportunities ==
 
 
Please go to the [[Employment opportunities]] page to list any [[employment opportunities]]. If you list your employment opportunity here it will not be registered. - [[User:Cameron|Cameron]] 22:21, 25 September 2012 (EDT)
 
 
== How to add variable in target metadata ==
 
 
How to add variable in target metadata???  {[( Anon )]}
 
----
 
: Please sign your posts. -- [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 15:07, 23 June 2015 (CDT)
 
 
== i m adding a new topic on this website ==
 
 
Role :SAS Admin.
 
Rate : $45/hr all inclusive
 
Location : Princeton, NJ
 
Duration : 6 months
 
 
 
Required skill:-
 
 
SAS Admin. with 3 to 8 years of experience for contract position
 
 
Experience with Health care Domaine
 
 
== PR/Advertizing sasCommunity.org at SAS Global Forum  ==
 
 
It's been a while since a comment has been added here and so I have a suggestion.  At a previous SGF there were some business cards with the sasCommunity.org logo and information.  They had many uses at the SAS Global Forum and would be good to do again.  I still have a few if someone wants me to FAX how they looked. -- [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 10:45, 22 February 2014 (CST)
 
:I'm looking forward to the use of QR codes (Quick Response Codes) for speaker/user collaboration and info exchange. Lainie Hoverstad and Mary Rosenbloom are leading the technology at SGF 2014. Refer to https://en.Wikipedia.org/wiki/QR_code and here on sC.org (you can take a look at Art Carpenter's TALK page for an example). Don Henderson makes including your QR code easy. -- There are over 35,000 'views' to this TALK page so more activity/info would be wise. [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 09:03, 23 February 2014 (CST)
 
 
== Question: problem with input statement ==
 
 
Dear Folks,
 
 
I am new to SAS and facing difficulty to understand the below point:
 
The below program is not giving correct output because the data after datalines statement is not following the spacing that is required as per variables defination in 'input' statement. Here, I have only 5 record lines and thus it is easy for me to change the spacing in datalines. '''But, if I have millions of records and data is coming as in current form (where the 'name' variable is having space in between, how would i define my 'input' statement so that output is correct as required. I tried using colon (:) in the input statement, but couldn't get the desired result. Please help!!'''
 
 
<source lang="sas">
 
options pagesize=60 linesize=80 pageno=1 nodate;
 
data sales;
 
input EmployeeID $ 1-9 Name $ 11-29 @30 HireDate date9.
 
Salary HomePhone $;
 
format HireDate date9.;
 
datalines;
 
429685482 Martin, Virginia 09aug1990 34800 493-0824
 
244967839 Singleton, MaryAnn 24apr1995 27900 929-2623
 
996740216 Leighton, Maurice 16dec1993 32600 933-6908
 
675443925 Freuler, Carl 15feb1998 29900 493-3993
 
845729308 Cage, Merce 19oct1992 39800 286-0519
 
;
 
proc print data=sales;
 
title ’Sales Department Employees’;
 
run;
 
</source>
 
::[[User:Darpnew|Darpnew]] Thank you for posting your question, although the site has a lot of information it really is not designed to be a discussion forum.  Please consider posting your question to the [https://communities.sas.com/community/support-communities|SAS Forums].  These are designed to get the kind of response that you are hoping for. --[[User:ArtCarpenter|Art Carpenter]] ([[User talk:ArtCarpenter|talk]]) 13:37, 1 May 2015 (CDT)
 
:::And if your find a good answer, consider adding a TIP/Article here. You will become famous for generations. -- [[User:CharlieShipp|Charlie Shipp]] ([[User talk:CharlieShipp|talk]]) 15:12, 23 June 2015 (CDT)
 
 
 
Darpnew ... this will work .....
 
<source lang="sas">
 
data sales_n;                               
 
length EmployeeID $9. l_name  f_name  Salary  HomePhone $12.; 
 
input EmployeeID $ l_name $ f_name $ HireDate date9. Salary $ HomePhone $;
 
format HireDate date9.;
 
Name= l_name||' '||f_name; 
 
datalines;
 
429685482 Martin, Virginia 09aug1990 34800 493-0824
 
244967839 Singleton, MaryAnn 24apr1995 27900 929-2623
 
996740216 Leighton, Maurice 16dec1993 32600 933-6908
 
675443925 Freuler, Carl 15feb1998 29900 493-3993
 
845729308 Cage, Merce 19oct1992 39800 286-0519
 
;
 
run;                                     
 
proc print data=sales_n;
 
var EmployeeID Name Salary  HomePhone HireDate ; 
 
title ’Sales Department Employees’;
 
run;
 
 
                              ’Sales Department Employees’                                  1
 
                                                                  12:39 Wednesday, August 19, 2015
 
 
                  Employee                                          Home
 
          Obs      ID                Name            Salary    Phone      HireDate
 
 
            1    429685482    Martin,      Virginia    34800    493-0824    09AUG1990
 
            2    244967839    Singleton,  MaryAnn    27900    929-2623    24APR1995
 
            3    996740216    Leighton,    Maurice    32600    933-6908    16DEC1993
 
            4    675443925    Freuler,    Carl        29900    493-3993    15FEB1998
 
            5    845729308    Cage,        Merce      39800    286-0519    19OCT1992
 
 
</source>
 
Lewis Goldson - stevie_gee@hotmail.com...
 
----
 
 
Cognigen Corporation (www.cognigencorp.com) is looking for data programmers who want to work in a dynamic, collaborative environment, who have experience with SAS and/or R, and who have the highest attention to detail. Cognigen is the only company in the world that specializes in data assembly for population pharmacometric analyses to support our clients in the pharmaceutical and biotechnology industries. Cognigen programmers are integral to our project teams. Over the last 8 years, our programmers have written more than 40,950 SAS and R programs to produce complex analysis-ready datasets and presentation-quality graphics. If you have a desire to advance your programming career, send us your resume at personnel@cognigencorp.com.
 
 
== Connecting to SQL Server via SAS ODBC ==
 
 
Can someone tell me the code to connect to SQL Server remotely through SAS ODBC so that I can see the schema as well?
 
I have the IP Addesss, User ID and Password.
 
 
 
Thanks,
 
 
Mike
 
 
-----
 
Hi Mike. Via Googling your problem, I found [https://support.sas.com/techsup/technote/ts765.pdf these instructions]. The code starts on page 10, and includes viewing the schema. Does this help?
 
 
As stated above, "Thank you for posting your question, although the site has a lot of information it really is not designed to be a discussion forum.  Please consider posting your question to the [https://communities.sas.com/community/support-communities|SAS Forums].  These are designed to get the kind of response that you are hoping for." - [[User:Paulkaefer|Paulkaefer]] ([[User talk:Paulkaefer|talk]]) 09:17, 6 May 2016 (CDT)
 
 
== How to add 24 hours to an existing time field ==
 
 
I am currently trying to find a way to add 24 hours to an existing time field. I've copied the case statement I'm attempting now and i'm getting an error that states
 
ERROR: Character format $ in PUT function requires a character argument.
 
 
1st try:
 
          case when t1.Day_Diff = 0 then t1.Time_Diff else
 
          (case when t1.Day_Diff = 1 then t1.Time_Diff + 24:00:00 else
 
          (case when t1.Day_Diff = 2 then t1.Time_Diff + 48:00:00 else
 
          (case when t1.Day_Diff = 3 then t1.Time_Diff + 72:00:00 else '0' end) end) end) end as Add_24hours
 
 
 
2nd try:
 
          case when t1.Day_Diff = 0 then strip(put(t1.Time_Diff,$32.)) else
 
          (case when t1.Day_Diff = 1 then strip(put(t1.Time_Diff + "24:00:00"T,$32.)) else
 
          (case when t1.Day_Diff = 2 then strip(put(t1.Time_Diff + "48:00:00"T,$32.)) else
 
          (case when t1.Day_Diff = 3 then strip(put(t1.Time_Diff + "72:00:00"T,$32.)) else "over" end) end) end) end as Add_24hours
 
 
Any help you can give would be greatly appreciated.
 
 
Thank you!
 
Erin
 

Latest revision as of 14:52, 29 August 2017

This page is to discuss the content of the Main Page. (Off topic postings get removed.)

Closed discussions

Registered trademark symbol

Shouldn't the little "R" in a circle appear in banner_text.gif and in the first text reference? funct


Search function

It would be nice if the SEARCH function were visible more toward the top of the main page, so that it would be easier to find when someone just viewed the main page --Hamer 11:45, 17 March 2008 (EDT)


Categories

How about putting CATEGORIES as a selection on the left menu?--Nancy 13:13, 17 March 2008 (EDT)


Hierarchical structure

Since a Wiki is self-configurable (I mean that we the users can do what we want to it, without waiting for a webmaster to do it for us), that should mean that if we the users wish, we could impose a hierarcical structure on it in order to make it easier to navigate it, but of course, users would not have to use the hierarchary, but of course, gardners could move things around. --Hamer 15:51, 17 March 2008 (EDT)

About Category

I agree with Nancy in putting the 'category' item on the main menu. To find categories now, I looked at 'tool box-> special pages'. I'm not sure how one would update the main menu, so it may be something that admin folks can do. --CJ 15:44, 3 June 2008 (EDT)


Hi! I just am learning (stumbling) my way around. Hi Bob! Is there a way just to respond to you from here about the little "R" or is the way to respond the way I'm doing now with edit? A little bit of hand holding and then I will take off... Sally Muller.

This was answered/addressed on Where did Hamer go?‎. --Don Henderson 22:07, 17 March 2009 (EDT)


Employment opportunities

Please go to the Employment opportunities page to list any employment opportunities. If you list your employment opportunity here it will not be registered. - Cameron 22:21, 25 September 2012 (EDT)

Removed topics

Here is where some recently removed topics have gone. View history for more details. - Cameron (talk) 21:35, 29 April 2017 (CDT)

Towards a tidy talk page

I think this talk page needs to be tidier. The page should be a discussion about the content of the Main Page, rather than a public forum.

  • Questions from users seeking help should be moved to the respective user's talk page if a response is provided, rather than being left here.
  • Users listing employment opportunities should be directed to list there instead.
  • Ideas, suggestions and general comments about the sasCommunity should be moved to a more relevant wiki page.
  • Old comments and discussion should be moved to an archive area once they are no longer relevant.
  • The remaining discussion(s) should be refactored.

- Cameron (talk) 00:12, 29 April 2017 (CDT)

Good points Cameron, you have the experience, would you like to take a stab at it? --Art Carpenter (talk) 02:35, 29 April 2017 (CDT)
I have already made a start by moving several sections to users talk pages. Though it looks like an edit conflict has just undone some of the changes I have made here recently, so that might mean I need to repeat a little bit of work. - Cameron (talk) 02:51, 29 April 2017 (CDT)
The talk page is a bit tidier now. - Cameron (talk) 19:53, 29 April 2017 (CDT)

About Weekend Wiki Work/TIPs

I'm noticing that a daily tip was not available for today. . . . What about having a weekend wiki study assignment (HomeWork as it were.) For example here is one:

 Use the 'edit' on any Article-Page to see how the wiki language-controls are written.
 Look for examples of good page publishing and use 'edit' to see how it is done.

Some weekend wiki work (homework) could involve longer study assignments (for Fri-PM, Sat, and Sun.), from those that are doing so well assigned to eager students such as myself. Humbly, Charlie Shipp
Charlie Shipp 00:04, 19 April 2009 (UTC)


Sounds good, Charlie! Use the 'submit a tip' process to submit your tip, and it can be scheduled.--Nancy 15:00, 20 April 2009 (UTC)


I'll work on it in my spare time; easy to do. -- Charlie Shipp (talk) 15:06, 23 June 2015 (CDT)