f



Re: SAS Tables

You can use proc transpose to get the dataset you want;

data have;
   input Age  Exp   Rate;
   cards;
 1    1    0.9
 1    2    1.2
 2    1    0.6
 2    2    0.2
   ;run;
proc transpose data=have out=want;
   by age;
   var rate;
   id exp;
   run;
proc print;run;


2008/11/24 J M <jasonm@ucla.edu>:
> I would like to take this data:
> Age  Exp   Rate
>  1    1    0.9
>  1    2    1.2
>  2    1    0.6
>  2    2    0.2
> and create this table
>   1    2
> 1 0.9  1.2
> 2 0.6  0.2
> I'm then going to export this output to Excel (which I assume should
> be straightforward using ODS).
>
> Any suggestions?
>
0
dorjetarap (477)
11/24/2008 8:29:39 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
337 Views

Similar Articles

[PageSpeed] 27

Reply:

Similar Artilces:

Re: What r the data types in SAS? in Base SAS , and SAS SQL
> From: Amar Mundankar > Sent: Tuesday, July 21, 2009 8:10 AM > To: sas-l@uga.edu > Subject: What r the data types in SAS? in Base SAS , and SAS SQL > > Hi all, > What are the different data types in Base SAS and SAS SQL?? character, lengths from 1 to 32,000+ numeric: lengths from 2 to 8 dates are a subtype of numeric and are identified by their date, datetime, or time formats the new proc TSPL (Table Server Processing Language) supports ANSI data types: bigint, tinyint, etc. http://support.sas.com/documentation/cdl/en/tsag/30878/HTML/default/a003 065339.htm http://s...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year.
I took the advanced exam this April because I wanted a relatively systematic way of assessing my knowledge of SAS in a short time span. For that purpose, it was worth it. Since I learn SAS by doing new tasks, or re-doing old tasks in a new way, I assume my knowledge of SAS is uneven, even though I am regarded as productive, and frequently creative in using SAS to solve our group's problems. I passed the test, with lower subscores on the components that I expected to be weakest on. I thought many of the questions made me think about some fundamental, sometimes subtle, features of the lan...

how to add fonts to the sas registry (was RE: Re: sas/graph:
Success! A google search led me to: http://support.sas.com/documentation/onlinedoc/base/91/freetype-hub.pdf Which includes the magic option on FONTREG to use the "all" mode. (And now that I look back on the FONTREG docs, I see it there was well :-P). So here's code that works: * =================================== ; proc fontreg mode = all msglevel = verbose ; truetype 'c:\windows\fonts' ; run ; data phoney ; do n = 1 to 2000 ; x = ranuni(-1) ; if n le 1000 then grp = "one" ; else grp = "two" ; output ; end ; run ; gopti...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #7
Well Toby, let me ask something then. Since I am not an ODS fan and haven't used proc report/tabulate for some time, would that be an automatic disqualifier since you don't allow reference books or materials? SAS does not provide tools that help me code ODS (except for EG) and therefore a reference material is all I would need. Now, it's not like I haven't used proc report (used it extensively at one time), it's just that I prefer other means to produce the final output. It seems that a test like this would toss me out of the pool from the get-go. Heck, maybe that's wh...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #8
On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin Viel, PhD Post-doctoral fellow Department of Geneti...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #5
I think that SAS and R are very similar, even though their designs are very different. What matters is that both can be used to accomplish the same things - just as English and Swahilli serve the same purpose (communication) equally well. As for the copyleft "mess", do you really believe the propaganda and outright lies perpetrated by some companies? Remember, they want you to pay $$$ for your software, and copyleft poses a huge threat to that goal. -----Original Message----- From: Peter Flom [mailto:flom@NDRI.ORG] Sent: Thursday, February 05, 2004 12:57 PM To: SAS-L@LISTSERV.UGA....

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #10
I actually think you are straight-jacketing the interview for a senior person. I would definitely look for someone who thought outside of the box. That may be ways of doing things other than macros or ODS or else putting a new spin on them. I ditched most of the macro language a decade ago, for example. As a hiring manager, I always went for creativity and not specific skills on hand and was very pleased with my hires. But hey, I don't hire anymore so it isn't something I have to face. BTW, no client has ever asked me for certification nor have I been quizzed on specific SAS knowledg...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #4
No, sorry if I made it sound that way..... SAS and R are totally different in the way they work, how they are structured, what the statements look like, and so on. Not like French and Spanish, not even like English and Spanish. More like English and Swahilli. R has a lot in common with S Plus, both are based on the S language. But there is no hostility that I know of between S Plus and R (unlike the situation with Linux) Peter >>> <ben.powell@CLA.CO.UK> 2/5/2004 10:36:32 AM >>> wrote Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sort...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #4
Ed , I still contend and stick with they should both be able to program and know how SAS works. I prefer the intervewing company give a test, were the person being interviewed is sat in front a laptop or desktop and told to write code to solve some problems. No online help no books just the persona nd the computer. This weeds out those who can code and those who cant, from those who can you then talk to them about the code they wrote and you can deduce those who understand how SAS works and thos who dont. The pool you are left with are the qualified candidates atleast from a SAS perspecti...

Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #11
Kevin, Thank you for the nice words...I am sure I wouldn't have a chance on any stat exam, BTW. What I am good at is being in an absolute crisis and trying to get it solved with no time on the clock. That is why I think in a quirky manner. When the obvious isn't working, take a different path because there is simply no time left. It's what I did at MCI, SAS, and now as an independent. ....and that skill will not be measured on a certification exam or plopping me in front of a PC to hammer out an example SAS program. For any candidate, I can pick up their technical level with a few questions and watching their reactions. Alan Alan Churchill Savian www.savian.net -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Kevin Roland Viel Sent: Tuesday, September 04, 2007 4:02 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. On Tue, 4 Sep 2007, Alan Churchill wrote: > It seems that a test like this would toss me out of the pool from the > get-go. Heck, maybe that's what the goal would be ;-] Well then, maybe the rest of us might have a chance then :) Given that I have not used SAS regularly in months, I would be hurting. Hopefully, I would not be tossed immediately either. Isn't one point of the test to allow a organization to call itself a partner or some other distinction? Maybe to be listed among companies on SI's websites? Kevin Kevin ...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #2
Sounds like R is the SAS equivalent of Linux .. who are incidentally in all sorts of a copy left/right mess at the moment. On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: >I use both SAS and R; I"ve used SAS for 10 or 15 years, R for about 6 >months - 1 year. > >Each has strengths and weaknesses; I'd not like to give up either. > >Strengths of SAS (esp. compared to R) > >Tech support - I have SAS tech support's phone number and our license >number memorized. They're great. > >SAS-L - There's also an R-help list...

Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) #3
Wow, that was a leap. Better not use Apache or PHP then. Andy >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On >Behalf Of ben.powell@CLA.CO.UK >Sent: Thursday, February 05, 2004 10:37 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: Re: R vs. SAS (was Replacement for SAS (SPSS vs. SAS, redux)) > >Sounds like R is the SAS equivalent of Linux .. who are >incidentally in all >sorts of a copy left/right mess at the moment. > >On Thu, 5 Feb 2004 09:39:37 -0500, Peter Flom <flom@NDRI.ORG> wrote: > >>I use both SAS a...

Re: SAS Job websites WAS(Re: SAS jobs for freshers in US
On Fri, 24 Mar 2006 11:27:44 -0500, Steven Raimi <steven.raimi@ONSTAR.COM> wrote: >Another very helpful (and focused) web site for SAS jobs is >icrunchdata.com. I'll try to ....post from home later, where I have a set of links (I don't have them at my new job here, which, FYI, I found via Monster). I'll also try to avoid fumble-fingering that accidently posts my messages before I'm done writing them! Steve ...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727
Nice thread guys .... I guess this is what open source development is all about .... Got me thinking about suggesting a code/macro library on sascommunity.org? Any thoughts? ...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #3
First, let me admit/acknowledge that I have no knowledge of the history of this thread. Been tied up catching up post SAS Global Forum and post the announcement of sasCommunity.org. But I would like to offer some thoughts regarding Toby's comment: > No as for the sascommunity.org, do we really want a macro library. Well I > would say yes and no. I would like to have one and there are those who > have > paced some Macros on there already. I believe Don and Ron both have, > actually they were on there before the Wiki went public. However, since > people tend to get Ma...

Re: SAS and SAS/IML TO C
ricardosilva@SERASA.COM.BR wrote: > >Dear Users, > >There's some way to convert SAS and/or SAS/IML codes to C code? > >Thanks, > >Ricardo=20 Sure there is. Umm, unless you didn't want to spend a bunch of person-months writing the code by hand, and then a bunch of person-years validating and debugging all that code. If all you want is something simple, like a sort, or a sum of constants times your varables, then you can do that in any decent language. If you want any kind of generality, you are stuck. Let's say you want some subset of PROC MIXED in C. W...

Re: SAS programming and SAS/BI
<div>Auto..,</div> <div>&nbsp;</div> <div>&nbsp;</div> <div>&gt;From what I've read, it hasn't been to clear what all<BR>&gt;is involved with SAS/BI in terms SAS programming. &nbsp;So I take it<BR>&gt;there's really isn't much programming involved.</div> <div>&nbsp;</div> <div>IMO and IME:</div> <div>Yes and&nbsp;No; but really&nbsp;somewhere in&nbsp;between.&nbsp; One reason for&nbsp;the confusion is that SAS BI is a&nbsp;number of produ...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727 #2
Graham , I am not sure that the SI Tech Support examples should have all the error checking that Chang wanted to throw in the macro. The examples should be clear concise and easy to read and get going, as well as be illistrative. Too much error checking in an example well is just over kill and even detrimental to an example. However, any code solution on the SI Tech Support web sit should follow basic rules of good practices and sound advice. Such as with thier macros having atleast a somewhat good Macro design. Look at Example SAS Sample 1728: The first method well lets say is soooo bad...

Re: SAS consulting and SAS license
Paula, I'm not a consultant but, I have had a little experience with SAS licensing. If I understand you questions correctly: 1) If I recall correctly, as a consultant, she can use the contracting company's license only on company premises (may be wrong about that detail) and she can only perform work for that specific company using that copy of PC-SAS. If the company's license is workstation-based then each PC SAS is installed on will count as a license-copy. If the license is user-based then each workstation will count for at least one license-copy (each pers...

Re: To SAS or not To SAS (or whatever else)!!,
OK, I'll be the first to bite here. First, check out our most excellent archives. There have been many, many discussions on the merits of sas versus anything from spss to sql server analytics to oracle to you name it. You might need to get creative in your search, like sas AND advantage or sas AND oracle and (obviously) sas AND spss. I've used a good many of the analytical tools out there, including many years with both sas and spss, and I can tell you from first hand knowledge, nothing even comes close to sas with regard to flexibility of the tool. You can do pretty much anything ...

Re: SAS 9 and SAS 8
I suggest that you look at the SAS web site http://support.sas.com/documentation/whatsnew/index.html Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 pausha <pausha1@GMAIL.CO M> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject SAS 9 and SAS 8 11/20/2008 03:28 PM Please respond to pausha <pausha1@GMAIL.CO M> Could someone send me the papers or articles that gives the differences between sas 8 and sas 9 and new function and changes in sas 9. Thanks CONFIDENTIALITY NOTICE: This electronic message contains information which may be legally confidential and/or privileged and does not in any case represent a firm ENERGY COMMODITY bid or offer relating thereto which binds the sender without an additional express written confirmation to that effect. The information is intended solely for the individual or entity named above and access by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copyi...

Re: load SAS table into DB2 temporary table
Pascal: Enclose SQL create and delete queries in a SQL EXECUTE() function and pass them through to DB2. Once you have the table created, you can insert rows of data (using BULKLOAD to speed up inserting large numbers of rows). Ask your DB2 DBA about the correct syntax for DB2 temporary table name. Sig -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of tonts Sent: Wednesday, June 30, 2004 2:31 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: load SAS table into DB2 temporary table Lois, Thanks for your answer. But the problem is a little bit different ...

Re: SAS System Viewer 9.1 unable to open SAS datasets ( SAS 9.1.3)
A question in return: is your table from windows? compressed from another system? and specially with personnel formats hard coded inside? Andre msiddu2000 a �crit : > SAS System Viewer 9.1 was able to open datasets that were created by > V8 engine (SAS 8.2), but is unable to open datasets that are created > with V9 engine (SAS 9.1.3). > > Does this need SAS System Viewer to be upgraded ? > or > Something else needs to be done ? > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 06 21 54 ...

Re: RE : Re: copulas and SAS
Adel, Think Joke! But, more seriously, it did prompt me to look up the origins of the copula as a functional. Joe On 9/27/06, adel F. <adel_tangi@yahoo.fr> wrote: > > Hi, > I do not know how this is related to my orginal question. > > My understanding of copula is, it is a joint distribution with uniform > margins, the problem how to obtain a copula which fits better a data? > > If there is any suggestion from members of SAS list, about examples for > copulae with SAS, I will appreciate that > > Thanks a lot > > Adel > Joe Whitehurst <joew...

Web resources about - Re: SAS Tables - comp.soft-sys.sas

Table tennis - Wikipedia, the free encyclopedia
Table tennis , also known as ping-pong , is a sport in which two or four players hit a lightweight, hollow ball back and forth using table tennis ...

Sustainable seafood on more Australian tables as traceability practices improve
From cans to&nbsp;fish shop windows and restaurant plates, 30 per cent of the world's seafood is still mislabelled.

An AnandTech Round Table with ASUS: 10 Years of the Republic of Gamers
... Rajinder 'Raja' Gill Technical PR Manager, ASUS USA AnandTech Motherboard Senior Editor 2008-2010 Ian Cutress 10 Years of ROG Round Table ...

Lithuanian Designer Launches Standing App For His Funky Table
... at the office. His back started to hurt and his productivity seemed to decrease. "That was the time when I started my hunt for a suitable standing ...

Disney CEO says selling ESPN a la carte is on the table
Disney CEO Bob Iger says Disney needs to improve on the digital front, and that selling ESPN direct-to-consumer is on table . Speaking at the ...

Joe's Crab Shack apologizes for photo of black man's 1895 hanging at table
People Magazine Joe's Crab Shack apologizes for photo of black man's 1895 hanging at table Charlotte Observer An image on a table at a Joe's ...

Cramer: Oil's biggest worry now off the table
Jim Cramer thinks the big credit crunch in the oil patch could finally be over, and is ready to take action.

Minnesota diners stunned by lynching photo embedded in diner table
The owners of a Joe's Crab Shack diner has apologized for the inclusion of the photo, along with a troubling joke, in the restaurant's table ...

Aussie School Head, Avowed Global Warming Warrior Tables Requests To Divest — Too Pricey To Quit Oil
'The council has to balance both its fiduciary responsibilities to provide the funds for students and staff needs'

Morning Digest: Can Team Blue retake the House in 2016? Only if they completely run the table
Leading Off : ● House : Daily Kos Elections is pleased to present our initial House race ratings for the 2016 election cycle . Mid-decade redistricting ...

Resources last updated: 3/16/2016 3:48:27 PM