f



Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN #2

A:
You may want to consider using nested queries to create the keys that you
need to join the tables? That gives the SQL compiler a way to bound the
search space. For example,
proc sql;
create table temp as
select *
from (select <key transformation>,* from small) as t1
      left join (select <key transformation>,* from large) as t2
on t1.<transformed key> EQT t2.<transformed key>
;
Now the SQL compiler has two keys from the same domain that it can index or
use as sort keys. This method works with composite keys as well. Just make
sure that the <transformed key> values match in the rows that you hope to
link. The method may also work much faster than joining two tables directly
on computed key values.
Sig


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of afraser
Sent: Monday, January 31, 2005 3:59 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN


I have the following data, along with some other variables: BVM.XSBC.
BVT.XAGL70.D01. BVT.XAGL71.D01. BVT.XAGL71.D02. BVT.XAGL71.D03.
CORP.XSOP.ARCHIVE. CRT.

I need to merge it too this data, that also has other variables:
BVM.XSBC.FAFRBUDG.TS0001.N01.G1724V00
BVM.XSBC.FMCHCPLN.TS0001.D01.G1595V00
BVT.XAGL70.D01.G0017V00
BVT.XAGL71.D02.G0013V00
BVT.XAGL71.D03.G0017V00
CORP.XSOP.ARCHIVE.D04365.T090107.F01
CORP.XSOP.ARCHIVE.D04366.T090108.F01
CRT.CAKLIB.D01.G3487V00
CRT.CMSR30.D01.G0004V00
CRT.FSED86.D04.D87.G0024V00
CRT.FSED86.D69.D87.G0024V00
CRT.FSED86.D69.D87.G0025V00

Basically the first set has prefixes of the data in the second set. It is
the only data in common between the two groups, so thus the only data to use
for a SAS Merge or SAS SQL JOIN.

I have been thru all the postings on using SQL JOIN and SAS MERGE but none
to this point has worked.

This is one of my many attempts in SQL just as an example:
proc sql;
create table temp as
select *
from small as t1 left join large as t2
on trim(t1.dataset) EQT substr(t2.dataset,1,length(t1.rmfdsn))

also with the WHERE INDEX
proc sql;
create table temp as
select *
from small as t1 left join large as t2
on trim(t1.dataset) EQT substr(t2.dataset,1,length(t1.rmfdsn))
where index(t1.dataset,t2.dataset);

I knew SAS Merge was not going to work but I did try something basic
like:
data test;
merge small (in=a)
large (in=b);
by dataset;
if index(dsn,rmfdsn) >0;

Any help would be greatly appreciated.
A. Fraser
IBM Global Services
MVS Storage Administration
0
HERMANS1 (2683)
1/31/2005 9:31:00 PM
comp.soft-sys.sas 142827 articles. 3 followers. Post Follow

0 Replies
1256 Views

Similar Articles

[PageSpeed] 3

Reply:

Similar Artilces:

Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN
Your first attempt should have worked. Note that you don't need to SUBSTR the fullname when you're using the EQT operator ( there are some length caveats, see SAS-L archives ). proc sql; create table combined as select prefix, fullname from short left join long on prefix eqt fullname ; quit; OR proc sql; create table combined as select prefix, fullname from short left join long on prefix = substr(fullname,1,length(prefix)) ; quit; worked with test data: data short; length prefix $200; input prefix $; cards; BVM.XSBC. BVT.XAGL70.D01. BVT.XAGL71.D01. BVT.XAGL71.D02. BVT.XAGL71.D03. CORP.XSOP.ARCHIVE. CRT. run; data long; length fullname $200; input fullname $; cards; BVM.XSBC.FAFRBUDG.TS0001.N01.G1724V00 BVM.XSBC.FMCHCPLN.TS0001.D01.G1595V00 BVT.XAGL70.D01.G0017V00 BVT.XAGL71.D02.G0013V00 BVT.XAGL71.D03.G0017V00 CORP.XSOP.ARCHIVE.D04365.T090107.F01 CORP.XSOP.ARCHIVE.D04366.T090108.F01 CRT.CAKLIB.D01.G3487V00 CRT.CMSR30.D01.G0004V00 CRT.FSED86.D04.D87.G0024V00 CRT.FSED86.D69.D87.G0024V00 CRT.FSED86.D69.D87.G0025V00 run; -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of afraser Sent: Monday, January 31, 2005 3:59 PM To: SAS-L@LISTSERV.UGA.EDU Subject: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN I have the following data, along with some other variables: BVM.XSBC. BVT.XAGL70.D01. BVT.XAGL71.D01. BVT.XAGL71.D02. BVT.XAGL71.D03. CORP.XSOP.ARCHIVE. ...

Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN #3
From a datastep point of view, there are a couple of ways to handle this: (Untested code) Data Combined Nomatch; Merge HLQFILE COMPLETEFILENAMEFILE; If DSNWTIHGOOVOO =: HLQ then output combined; Else output Nomatch; /* decide how you want to handle rejects from */ /* each file - maybe add your in=a to make sure */ /* you keep all records from one side or the */ /* other */ Or If INDEX(DSNWITHGOOVOO, HLQ) > 0 then output combined; --index function scans the first operand for the second operand, and if it finds it, returns a positive value (the number of occurrences). Otherwise, returns a zero. The =: assumes equivalence beginning with the first character (as opposed to occurring at some point within the second operand, not necessarily beginning with the first character). The english equivalent is 'starts with'. So, if the DSN with Goo Voo starts with HLQ, then output combined. HTH, CH On Mon, 31 Jan 2005 12:59:06 -0800, afraser <afraser@US.IBM.COM> wrote: >I have the following data, along with some other variables: >BVM.XSBC. >BVT.XAGL70.D01. >BVT.XAGL71.D01. >BVT.XAGL71.D02. >BVT.XAGL71.D03. >CORP.XSOP.ARCHIVE. >CRT. > >I need to merge it too this data, that also has other variables: >BVM.XSBC.FAFRBUDG.TS0001.N01.G1724V00 >BVM.XSBC.FMCHCPLN.TS0001.D01.G1595V00 >BVT.XAGL70.D01.G0017V00 >BVT.XAGL71.D02.G0013V00 >BVT.XAGL71.D03.G0017V00 ...

Re: SAS merge vs. SQL Merge? #2
Also, you are selecting multiple instances of columns with the same name, which SAS shouldn't let you do, namely SOLDTO SHIPTO and the other name. If there are not too many variables better to select only the columns you actually need. This removes the need for SAS to review what columns there are and interpret *, but will also reduce the I/O, hth. Ben Powell, Data Analyst Date: Mon, 20 Oct 2003 14:58:15 -0700 From: "David L. Cassell" <cassell.david@EPAMAIL.EPA.GOV> Subject: Re: SAS merge vs. SQL Merge? James Green <jamesgreen55@YAHOO.CA> wrote [in part]: >...

Re: Re-learning SAS
Proc Transpose is your friend ... proc transpose data=have out=want; by hhld; var product; run; should do the trick. Your column names will be COL1, COL2, etc., you'll need to either rename them or use the ID statement in proc transpose. -Joe On Tue, Oct 7, 2008 at 2:53 PM, steve_mi_94 <stephenjfarr@gmail.com> wrote: > I am re-learning SAS after a 10 year hiatus, and can't remember how to > do something simple that I used to be able to do! > > Basically I am looking to summarize transaction-level observations > into a household purchase history record. > > For example, the dataset I am starting with would have n observations > in a household that has n purchases in their history. I am interested > in creating a single observation per household, while keeping all of > the detail of each transaction. > > Current Data: > > HHLD PRODUCT > 1 coat > 1 shoes > 2 purse > > > Transformed Data: > > HHLD 1_PRODUCT 2_PRODUCT > 1 coat shoes > 2 purse . > > > > I APPRECIATE YOUR HELP! > ...

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: Difference between Sql Joins and SAS merges ?? #2
Thank you all for the help thanks SL On Fri, Aug 8, 2008 at 1:47 PM, Michael Davis <michael@bassettconsulting.com > wrote: > Hello SAS_learner and other SAS-L Friends, > > Try: > > http://www2.sas.com/proceedings/forum2008/185-2008.pdf > http://www2.sas.com/proceedings/forum2007/237-2007.pdf > > I've been using SQL more often in my current job because it > handles missing values better than PROC SUMMARY and PROC MEANS. > > Best wishes, > > Michael Davis > Ambler, PA > Michael.Davis@alumni.duke.edu > > > On Fri, August 8, 2008 10:26 am, "SAS_learner" > <proccontents@GMAIL.COM> wrote: > > > hello all I am trying to get my hand wet on SQL joins and in > that process > > I > > tried something like this (below) but > there is difference in sas merge > > and > > Sql Join I used > ?? Can some body guide me to SUGI paper which has > > explanation > of both SAS merges and Sql Joins side by Side thanks > > > > > proc sql ; > > create table miles as > > select > salcomps.empid ,lastname , newsals.salary, newsalary > > > > > from sasuser.salcomps, sasuser.newsals > > where salcomps.empid = > newsals.empid > > order by 2 ; > > quit; > > > > proc sort data = sasuser.salcomps out = salcomps ; > > by > empid ; > > run; > > > > Proc Sort data = > sasus...

Re: sql join vs sas merge #2
Why is such a join awkward? Because it involves a data structure which deviates from the normalized ones for which SQL is designed. I don't know what the next step is, but if it involves additional SQL processing, Ben might do better to combine the tables thusly: create table long as select pid, 1 as date_num, dt1 as date format=date9. from a union select pid, 2 as date_num, dt2 as date format=date9. from b union select pid, 3 as date_num, dt3 as date format=date9. from c union select pid, 4 as date_num, dt4 as date format=date9. from d; Result: Obs pid date_num date 1 101 1 01JAN2004 2 101 2 01FEB2004 3 201 1 01FEB2004 4 201 4 01JUN2005 5 301 1 01MAR2005 6 401 1 01APR2005 7 401 2 01JUN2005 8 401 3 01JUN2005 9 501 1 01APR2005 10 501 3 01JUN2005 11 601 1 01APR2005 On Sat, 19 Feb 2005 21:36:43 GMT, Roger Lustig <trovato@VERIZON.NET> wrote: >Ben: >In the general case, your two programs do not produce the same results! > >They are only equivalent if > >a) none of the four data sets (well, perhaps one) has multiple instances >of the PID variable; > >b) all of the PIDs are represented in table a. (You want left joins, >not full joins, to mimic the effect of the I...

Re: Re-learning SAS
Steve Welcome back to the side of truth and beauty. For this problem, you could use arrays but Proc Transpose is a whole lot easier. data a; input HHLD PRODUCT & $5.; cards; 1 coat 1 shoes 2 purse run; proc transpose out = b (drop = _name_ ); var product; by hhld; run; proc print; run; Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 steve_mi_94 <stephenjfarr@GMA IL.COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re-learning SAS - merging records and keeping variables using 10/07/2008 03:53 first. and last. PM Please respond to steve_mi_94 <stephenjfarr@GMA IL.COM> I am re-learning SAS after a 10 year hiatus, and can't remember how to do something simple that I used to be able to do! Basically I am looking to summarize transaction-level observations into a household purchase history record. For example, the dataset I am starting...

Re: SAS merge vs. SQL Merge? #3
James: I have not had time until now to take a look at your question. David has suggested that query optimization techniques may help you control run-time errors. A few comments follow that may help you find a more efficient, and perhaps more complete, SQL solution. I know from the form of the query that are trying to combine rows from three tables into rows in one table. I also know that you are selecting only those rows in which 1. rawdata.SOLDTONAME=soldto_lkp.SOLDTONAME; 2. rawdata.SHIPTONAME=shipto_lkp.SHIPTONAME; 3. rawdata.ENDUSERNAME=shipto_lkp.ENDUSERNAME. I assume that the query describes your requirements accurately. (The lack of a formal data model makes me more than a little uneasy.) I ask about the query because it does not seem to correspond directly to the Data step MERGE's it supposedly replaces. The MERGE's look like updates of a master dataset. The RHS transaction file overwrites the master dataset (curiously named 'rawdata'). Trouble is, the transactions identified by ENDUSERNAME may overwrite updates from transactions identified by SHIPTONAME. The construction of the sequence of the merges appears to be failsafe logic that updates the master dataset when transactions in shipto_lkp match on SOLDNAME only, when they match on both SOLDNAME and ENDUSERNAME, or when they match on ENDUSERNAME only. Further, if any one row in the master dataset matches one row on SHIPTONAME and another on ENDUSERNAME, the transaction identified by ENDUSE...

Re: How to filter sas data sets into separate sas data sets #2
you cannot do this as described without a common link here, your Var1 Note: both data sets must be sorted by Var1 Data Newlist (KEEP=node1 node2 node3 ... var15) Otherds (Keep=node1 node2 node3 .... var15) ; do until(EndoFile); Set SASDS1 SASDS2 end = EndoFile; by Var1; *consider: if Var1 in (Node1 Node2 Node3); If Node1 = VAR1 or Node2 = VAR1 or Node3 = Var1 then Output Newlist ; Else Output Otherds ; end; stop; Undoubtedly the HashHeads will propose a lookup table but the above is what you are trying to do. Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > From: starsoul@mindspring.com > Listers, > > This is my failing point in coding SAS. The use of 2 > separate SAS data sets to create a third. > > I can do this in a program with nested Do loops. But with > SAS it is just different enough I seem to be unable to see > the coding technique. > > Problem: > > Sas Data set 1 contains 1 variable and 1000 obs. > Sas Data set 2 contains 15 variables and 500000 obs. > > I need to filter off the data in Sas data set 2 based on Sas > data set 1 > > Node1, Node2 and Node3 must match VAR1 exactly. I have all > the code I need to do this except for splitting the data into > a separate SAS data set (NEWLISTS). > > > Psuedo code: > > Sas Data set 1: Var1 Length 7 Char > Sas Data set 2: Node1 Length 1-8 Char Node2 Length 1-8 > Char Node3 Length 1...

Re: sql join vs sas merge
it is one good answer, though. p.s. It is rare, but it happens in real world. events could be recorded in different files, but we can put pt's mutilple 'records' into one 'record' per id as those mocked files. Thanks On Sat, 19 Feb 2005 21:36:43 GMT, Roger Lustig <trovato@VERIZON.NET> wrote: >Ben: >In the general case, your two programs do not produce the same results! > >They are only equivalent if > >a) none of the four data sets (well, perhaps one) has multiple instances >of the PID variable; > >b) all of the PIDs are represented in table a. (You want left joins, >not full joins, to mimic the effect of the IF A; statement in your merge.) > >That said, I suspect that: >--you have more data than this >--you may even have more than four dates. > >This may not be more efficient, but it's only one multi-level join: > >proc sql; >create table x_join as >select > a.pid, > a.dt1, > z.dt2, > z.dt3, > z.dt4 >from > a > left join > ( > select > pid, > max(dt2) as dt2, > max(dt3) as dt3, > max(dt4) as dt4 > from > ( > select * from b > outer union corr > select * from c > outer union corr > select * from d > ) > group by pid > ) z >on > a.pid=z.pid >; >quit; > >OK? > >Roger > >Ben wrote: >> ...

Re: Difference between Sql Joins and SAS merges ??
Hello SAS_learner and other SAS-L Friends, Try: http://www2.sas.com/proceedings/forum2008/185-2008.pdf http://www2.sas.com/proceedings/forum2007/237-2007.pdf I've been using SQL more often in my current job because it handles missing values better than PROC SUMMARY and PROC MEANS. Best wishes, Michael Davis Ambler, PA Michael.Davis@alumni.duke.edu On Fri, August 8, 2008 10:26 am, "SAS_learner" <proccontents@GMAIL.COM> wrote: > hello all I am trying to get my hand wet on SQL joins and in that process > I > tried something like this (below) but there is difference in sas merge > and > Sql Join I used ?? Can some body guide me to SUGI paper which has > explanation of both SAS merges and Sql Joins side by Side thanks > > proc sql ; > create table miles as > select salcomps.empid ,lastname , newsals.salary, newsalary > > from sasuser.salcomps, sasuser.newsals > where salcomps.empid = newsals.empid > order by 2 ; > quit; > > proc sort data = sasuser.salcomps out = salcomps ; > by empid ; > run; > > Proc Sort data = sasuser.newsals Out = Newsals ; > by empid ; > run; > > Data miles1; > Merge salcomps Newsals ; > By empid ; > run; > Proc Compare base = Miles Compare = Miles1 ; > Run; > ...

Re: Deleting SAS Data from a SAS DATASET #2
Chandra - this isn't my expertise area - I'm sure others may have better ideas but I'll make three comments. If your datasets have a large number of variables, in your datastep method a WHERE clause will be more efficient - the IF statement causes each record to be fully read before it can be selected for deletion. A WHERE clause would only read the single variable in the case of records that meet the criteria for deletion. Data prod.Master_date; set prod.master_date; where snap_dt ne "&end_dt"d; run; You probably would be better off changing your data model though - my first thought would to be to store your data as separate yearly or monthly files and then access them with a view of the past two years or 24 months. With each month or year you would delete the oldest file and change the view one time period forward. *set up the data; data time1 time2 time3 time4; do i = 1 to 100; do t = 1 to 4; if t=1 then output time1; if t=2 then output time2; if t=3 then output time3; if t=4 then output time4; end; end; run; *three successive example views; data filet1 / view=filet1; set time1 time2; run; data filet2 / view=filet2; set time2 time3; run; data filet3 / view=filet3; set time3 time4; run; One more thought - since the data are appended - if the file is not reordered and you have the record counts from each append - then you can use firsto...

Re: SAS/DMS library default library allocations using SAS V8.2 on #2
The library allocations have to be stored <somewhere>, otherwise you wouldn't continue to get the prompt. You can look under your userid to see if it's there (though I suspect you've already done that), but a better question would be directed at the SAS sysadmin--ask them where these profiles/customizations are stored (the sasuser.profile is the generic one--your personal one is concatenated along with it). You may be able to see your session info under your userid tso log (shows usage information), though off the top of my head I can't remember if it captures al...

Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com
Need SAS Data Integration Consultant with SAS Data Integration Studio, Base SAS, SAS macros and SQL experience for a 9 months project at Charlotte NC, please send resumes to kamesh@kmmtechnologies.com ...

Re: Difference between Sql Joins and SAS merges ?? #3
The sql is performing a inner join and data step is not. You can try by saying >Data miles1; > Merge salcomps(in=a) Newsals(in=b) ; >By empid ; >if a and b; >run; which might work. On Fri, 8 Aug 2008 10:26:58 -0400, SAS_learner <proccontents@GMAIL.COM> wrote: >hello all I am trying to get my hand wet on SQL joins and in that process I >tried something like this (below) but there is difference in sas merge and >Sql Join I used ?? Can some body guide me to SUGI paper which has >explanation of both SAS merges and Sql Joins side by Side thanks > >proc sql ; >create table miles as > select salcomps.empid ,lastname , newsals.salary, newsalary > >from sasuser.salcomps, sasuser.newsals >where salcomps.empid = newsals.empid >order by 2 ; >quit; > >proc sort data = sasuser.salcomps out = salcomps ; >by empid ; >run; > >Proc Sort data = sasuser.newsals Out = Newsals ; >by empid ; >run; > >Data miles1; > Merge salcomps Newsals ; >By empid ; >run; >Proc Compare base = Miles Compare = Miles1 ; >Run; ...

Re: urgent : Convert SAS array in to sas variables #2
On Sat, 3 May 2008 23:34:44 -0700, Shailesh <shailesh.tewari@GMAIL.COM> wrote: >In my dataset I have an array variable , say A which has values like >Observation 1 - A[1]= 23 ,A[2]=34, A[3]=45 >Observation 2 - A[11]= 23 ,A[12]=34, A[13]=45 > >I want to create sas variables which should have name A61, A62 , A63, >A64 .......... >Similarly for second observation these would be A71, A72, >A73 , A74......... > > >in the same datastep. > >Any help ? > >Regards, >Shailesh Arrays are DATA *step* structures. They do not exists in data *sets*. Please post an example showing the data set you have and what you need (or think you need). ...

Re: merge 1000 dataset using sas macro #2
A couple of thoughts: 1 For 1,000 data sets with presumably identical structure, it might be a good idea to include OPEN=DEFER in the SET statement. 2. If Doaa had used BY-group processing instead of macro looping to do the simulations, there wouldn't be 1,000 data sets, just 1. On Thu, 23 Oct 2008 11:01:23 -0400, Nat Wooding <Nathaniel.Wooding@DOM.COM> wrote: >You can use SQL to create a macro variable that contains the names of the >SAS sets in a library. Here is sample code > >Data a b c d; > x = 1; >run; > >Proc SQL ; >Select MemName Into : DSNList Separated By ' ' >From Dictionary.Tables > Where LibName = 'WORK' > And MemName Like '%' ; >Quit ; > > >Data Need ; >Set &DSNList ; >Run ; > >The following is a generic example that I keep in my set of "tools". Note >that it specifies how to describe the libname and select data sets. > > >Proc SQL ; >Select MemName Into : DSNList Separated By ' ' >From Dictionary.Tables > Where LibName = '<Your Library Name All Upper Case>' > And MemName Like 'FINAL_APP%' ; >Quit ; > > >Data Need ; >Set &DSNList ; >Run ; > > > > >Nat Wooding >Environmental Specialist III >Dominion, Environmental Biology >4111 Castlewood Rd >Richmond, VA 23234 >Phone:804-271-5313, Fax: 804-271-2977 > > > > Doaa >...

Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS. Gerhard On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM> wrote: >Is it possible to read a sas dataset NOT using sas and have >observations and variables etc. rather than having meaningless chunks >of text? ...

Re: search SAS data set from SAS code #2
Rose, The answer to your question depends on your operating system. In Windows, there's the Search tool. In Unix/Linux, you can use grep Bob Abelson HGSI 240 314 4400 x1374 bob_abelson@hgsi.com Rose <myr_rose@YAHOO.COM> Sent by: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> 04/19/2005 11:13 AM Please respond to myr_rose To: SAS-L@LISTSERV.UGA.EDU cc: Subject: search SAS data set from SAS code Hi All, Suppose I have a sas permanent data set which was created early, I know the library path but I couldn't remember in which sas program code I created it. how can I search from so many sas program files in different folders and find it. thanks in advance. Rose ...

SAS / Excel: Using SAS to merge/center cells in Excel
I'm trying to write out 2 different datasets to Excel. The issue I'm having is the column width from my first dataset is too wide for the data reported from my second dataset. Is there any way, using SAS, to merge and center columns B,C,D,E for a particular field in the first dataset? ...

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: SAS Advanced Programming Exam for SAS 9: SAS Joke of the year. #2
jontugman, Test preparation is akin to following a simple algorithm: 1. Evaluate the test and discover if it is worth taking. 2. If #1 evaluates false then go to exit. 3. Determine if your *test* knowledge of SAS is insufficient. 4. If #3 evaluates true, do the test preparation. 5. Pay the money. 6. Take the test. 7 Exit. From your standpoint, the step of paramount importance is step #1. That is where you mainly failed. From SAS' standpoint, only one step matters: #5. This is the only reason the test was created in the first place. The world would be a better place if all employers understood that as well. However, some recruiters/HRers require the certificate as a CYA backup should they accidentally hire a pure test-passer. Fortunately, I have not seen many occurrences of this nature since the inception of the boondoggle, perhaps because most candidates are almost inevitably interviewed by people qualified in SAS better than HR. And most qualified people saw the program for what it is even before its advent. SAS-L is replete with numerous posts to prove it. Needless to say, it does not imply in any way that any certificate-holder has no more SAS behind the belt than the certificate can cover. Far from that! Many fantastic real-world people have been forced into the thing by their SAS partnership business needs, many have taken it just for the heck of it because their employer would pay for it, etc. My opposition to the thing as a matter of principle is based on t...

Re-learning SAS
I am re-learning SAS after a 10 year hiatus, and can't remember how to do something simple that I used to be able to do! Basically I am looking to summarize transaction-level observations into a household purchase history record. For example, the dataset I am starting with would have n observations in a household that has n purchases in their history. I am interested in creating a single observation per household, while keeping all of the detail of each transaction. Current Data: HHLD PRODUCT 1 coat 1 shoes 2 purse Transformed Data: HHLD 1_PRODUCT 2_PRODUCT 1 coat shoes 2 purse . I APPRECIATE YOUR HELP! On Oct 7, 3:53=A0pm, steve_mi_94 <stephenjf...@gmail.com> wrote: > I am re-learning SAS after a 10 year hiatus, and can't remember how to > do something simple that I used to be able to do! > > Basically I am looking to summarize transaction-level observations > into a household purchase history record. > > For example, the dataset I am starting with would have n observations > in a household that has n purchases in their history. =A0I am interested > in creating a single observation per household, while keeping all of > the detail of each transaction. > > Current Data: > > HHLD =A0 =A0PRODUCT > 1 =A0 =A0 =A0 =A0 =A0 coat > 1 =A0 =A0 =A0 =A0 =A0 shoes > 2 =A0 =A0 =A0 =A0 =A0 purse > > Transformed Data: >...

Web resources about - Re: MVS Merge Variable Data Using SAS Merge or SAS SQL JOIN #2 - comp.soft-sys.sas

Variable - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Westpac interest rate rise is one of many variable loan rate rises
WESTPAC is not alone in hitting its owner-occupier customers with a surprise interest rate rise, as dozens of other variable rate home loans ...

Airbnb upgrades variable pricing tool for hosts
Online home rental group Airbnb is rolling out an upgraded variable pricing tool that automatically raises or cuts room rates based on supply ...

Commonwealth Bank raises variable home loan rates
Home owners' mortgage costs are set to rise by hundreds of dollars a year, after the Commonwealth Bank became the latest bank to hike interest ...

CBA lifts variable home loan rates to offset costs associated with stricter capital requirements
The Commonwealth Bank to lift its home loan interest rates independently of the Reserve Bank to partially offset costs associated with stricter ...

Washington Square Signs Spielbergs, Choi Joins Variable and More
... films and an episode of the HBO comedy series "Girls," on which he plays the role of Ray Ploshansky. New York-based creative collective Variable ...

Mozilla moves Firefox to variable release schedule
... schedule process "carefully" and learning "a lot" from it in the past years, Mozilla has announced that Firefox is now moving to a variable ...

"You have to ignore many variables to think women are paid less than men. California is happy to try." ...
Writes Sarah Ketterer in The Wall Street Journal in "The ‘Wage Gap’ Myth That Won’t Die" (which you can get to without subscribing if you Google ...

Staley: 'A lot of different variables...been a hard year'
... 41° Navigation Home Giants A's Sharks Warriors Kings 49ers Raiders Quakes Insiders More Tickets Shop Watch Staley: 'A lot of different variables...been ...

When your environment variables are showing
There are embarrassing moments in life. There is the teacher calling you out as a child in class as you stare out the window wistfully imagining ...

Resources last updated: 3/18/2016 9:57:48 PM