Summing Frequencies of a variable using multiple datasets

Hi, I'm trying to get sums of frequencies of some variables for couple of datasets. Currently I'm doing it like this (the final step I'm doing it manually). and the datasets looks like this, Dataset A name count John 543543 Smith 54354 .... Dataset B name count James 765765 Jane 87657 .... PROC MEANS DATA=location.dataset_A SUM NONOBS ; VAR count; OUTPUT OUT=dataset_Ax SUM()=; RUN; PROC MEANS DATA=location.dataset_B SUM NONOBS ; VAR count; OUTPUT OUT=dataset_Bx SUM()=; RUN; Is there a more efficient way of doing

Macro "retuning" values

Hi, I have a meta table where I keep info about our database. An example of this meta information is whether or not a variable is a primary key. Since we often want to find the primary key of a table, I decided to create a macro for it: %MACRO getPrimaryKey(table=); %LOCAL primarykey; /* Go through variables for the specified table. */ PROC SQL; SELECT varname INTO :primarykey FROM meta.variables WHERE UPCASE(tablename) = UPCASE("&table") AND isPrimaryKey = 1; QUIT; &primarykey. %MEND getPrimaryKey; It works in that it outputs the primary key for the

NEW! - - Phase Coherence is the unification factor for the 4 fundamental forces, Proof of this is in the following:

NEW! - - Phase Coherence is the unification factor for the 4 fundamental forces, Proof of this is in the following: Our space is built up by the average amount elements are out of phase with each other. Repulsive forces are generated between elements that are out of phase more than this average. While elements more in phase, than this average (phase coherence), produce attractive forces. http://www.amperefitz.com/phase.coherence.htm Click link above -- Science!

Need help with SAS X command to restart to SAS Object Spawner in a SAS Stored Process.

Hi, I am trying to restart the SAS Object Spawner via a SAS Stored Process. If I test this code in Base SAS it works ok but when I use it in a Stored Process and run it in SAS Enterprise Guide or the SAS Webbapp it does not error but does not restart the Object Spawner. The .bat file contains this net stop "SAS Object Spawer" net start "SAS Object Spawner" I have enabled the x command which works ok as I can unzip a file on the O/S (Windows 2003) from a SAS STP. %let live=Yes; %if &live=Yes %THEN %DO; * Restart the SAS Object Spawner; options noxwait xmin; data _null_;

I HACK $3000 FROM PAYPAL

I HACK $3000 FROM PAYPAL At http://simpleupdates.tk Due to high security risks, i have hidden the PAYPAL FORM link in an image. in that website on Right Side below search box, click on image and enter your name and PAYPAL ID.

Proc GLM contrast statement for interaction between continuous and categorical variable

Hello, I have one continuous variable (X), a categorical variable (Z; a treatment variable with three levels), and a continuous outcome variable (Z). X is an individual difference variable, consideration of future consequences (CFC). I have already figured out how to compare the different treatment variables for different values of CFC. For example, for comparing treatment 1 and 2 among low-CFC individuals (Mean at -1 SD = 4.2261), I would write the following proc glm; class cond; model y = cond cfc cond*cfc; ESTIMATE 'cond 1 vs 2 at low cfc' cond -1 1 0 cond*cfc -4.2261 4.22

Mapping one to many

I have a SAS problem that has me stumped. I have a set of (x,y) variables and I need to find the set of all possible slopes for all pairings (x(i),y(i)),(x(j),y(j)), i not equal to j. I ignore slopes that are undefined due to division by zero. I need to map this onto a set z(k), k=1...n(n-1)/2. I use SAS quite a bit, but I don't know how to do this. One other restriction is necessary. The set x,y must be in a permanent file and the set z must be temporary due to size and server restrictions.

Matching and merging tables

Hi, Could someone please help me out with below situation. i have a big file say A(which has id,name,address,amount) now i have to create a new variable called status in A with a match merge in B and C something like this. File A should get matched values of ID in file B and set a message to status in File A saying "ID is found" File A should get matched values of Name in file C and set a message to status in File A saying "Name is found" so that no duplicates will be found as well. I tried with merge but it gave me some other results. please help me to achieve this Tha

Proc means/summary: Calculating means from diff start pts per subj; same end pt for all

Dear all: I want to calculate mean of a variable from different start time points per subject to a fixed end time points for all subjects. It is longitudinal data. Here's a sample data: ID age1 dosemg age2 017 10.6229 12.0 11.1020 017 10.9624 12.2 11.1020 017 11.3511 12.5 11.1020 017 11.3511 13.2 11.1020 024 9.9274 9.0 7.0804 024 10.1684 9.3 7.0804 024 10.4066 9.4 7.0804 024 12.0821 9.6 7.0804 024 12.7912 9.7 7.0804 024 13.3552 9.8

sas format for BLANK when ZERO

last year Mike had the solution below. this works fine on PC but not on MAINFRAME does someone has an idea why not?? or another proposal? H.. -------------------------------------------------------------------------------------------------------- data test; input val @@; cards; 1 2 0 3 0.00 4 0.000 5 10000 2010 ; run; proc format; value zer 0 = ' ' other = [comma20.2] ; run; proc print data=test; format val zer.; run; Obs val 1 1.00 2 2.00 3 4 3.00 5 6 4.00 7 8 5.00 9 10,000.00

Is there a significant seasonality in the data

Hi all, I was approached today by a colleague who asked me to look at a time series of 60 months and test weather it contains seasonality. It has been some time since I looked at the ETS procedures. My first reaction was lets use the X12 or just look at the autocorrelation for the differenced series. I wonder if you have some pointers, suggestions or interesting reading material. I am also in search of material that will help me explain in layman=92s terms X11 & X12. With regard, Eli

%xl2sas macro updated

When reading multiple spreadsheets in the same sas session it was not closing the sheet after reading it so I have fixed that now. http://www.datasavantconsulting.com/roland/Spectre/utilmacros/xl2sas.sas

Integrity Constraint in Data Integration Studio 4.2

Hello, I would like to know how it is possible to specifiy the option "on update cascade" on a foreign key with DIS 4.2 ? By default, the options "on delete restrict" and "on update restrict" are specified. Best regards Ga=E9tan

Fisher's z transformation

On the SAS website, I found this info: Fisher (1970, p. 199) describes the following practical applications of the transformation: testing whether a population correlation is equal to a given value testing for equality of two population correlations combining correlation estimates from different samples Does it all apply to regression coefficient (r square) too? Could I apply the Fisher z transformation to rsq and then compare two transformed rsq, or get a mean transformed rsq from different samples? I know proc corr has a new option called Fisher and

RETRIEVE A SPECIFIC PART OF A ALPHA VARIABLE

Hello SasUsers, How can I obtain the word with =AB .TXT =BB. I have in a dataset the variable LINE with records like this : 15/03/2010 12:11 36=FF613=FF525 00_LANCETOUT__ALIMENTATION_MUTAERO93_11H44_15MAR10.TXT 15/03/2010 12:11 36=FF613=FF525 00_LANCECCCCCCCCCCTOUT__ALIMENTATIOCCCCCN_MUTACCCCCCCCERO93_11H44_15MAR10.T= XT 15/03/2010 12:11 36=FF613=FF525 00_LANCECCCCCCCCCCTOUT__ALIMEN10.TXT I need a variable LINE_NEW with these records : 00_LANCETOUT__ALIMENTATION_MUTAERO93_11H44_15MAR10.TXT 00_LANCECCCCCCCCCCTOUT__ALIMENTATIOCCCCCN_MUTACCCCCCCCERO93_

Merge data sets with Proc SQL or a data set

Hello I am try to merge two data sets. I have used Proc SQL and tried to merge them with merge statement when creating a new data set from the two original data sets. I am trying to merge the sets by first name, last name, and data of birth. One data set has about 400 observations and the second data set has about 12000 observations. I trying to get test scores from the 12000 observation into the 400 observation data set. The 400 observation set has 3 variables and from the 12000 one I am pulling about 4 variables. When using both Proc SQL and the merge statement the 4 variabl

SAS EM decision tree for detection of interaction

Hi, Iam struggling on how to use the decision tree to detect the potential interaction between factors. Could someone help me out. An interpretation using an example of tree graph, or pointing out where I can find the relevant info, will be really appreciated. Thank you very much. Meta

Accessing a Server through mainframe

I am trying to access a unix server via MVS mainframe, currently I can access it in PC SAS however when I moved the script into mainframe SAS it does not work. What do I need to do to get this working. See scritp below options sasautos=(sasautos "\\appslyyyy.xxxx.com\data\code\config") mautosource; %CR_MISignon(prod, Tim );

algorithms: reference to the previous observation

Let's say that I have a dataset with 2 columns: observation (from 1 to n) and x (a continuous variable from 0 to 100). I want to write the following algorith: if x (obs=i) <20 and x ( obs = i-1) is > 20 then y = 1; else y =0; where y would be a new column with value 0 or 1, and "i" is a particular observation. In other words, for each row or observation, if x <20 and the previous value for x (that is the value of x of the previous observation or row) is > 20, then y would get a 1, otherwise y would be 0. Thanks in advance!

seeking fellow sas-er interested in FT position in Battery Park vicinity

Looking for someone with strong all-around skills; we do a lot of work with macros and putting code into production. It's a fairly free environment, creativity-wise. salary depends on experience. If interested, please post your resume to mischman@gmail.com. Thank you.

upper and lower quartile comparison

This seemed basic enough, but I'm having trouble coming up with the right search terms to do my own research... I've been given a project that wants a logistic regression using classification in the upper or lower quartile for a standardized continous effector as the explanatory a la a proc logistic model like model finish = score; where finish is a 0/1 event and score is 'low' or 'high' (i.e. only data from the upper and lower quartiles used) This seemed popular and intuitive enough, but isn't an approach I've used so i went looking for the rationale or the 'here's a better mo

Running two lines of MS DOS code in SAS

I'm trying to run stat transfer from SAS. I've tried to use the X command, but it opens a MS DOS application for each window. Is there any way to run these two lines in SAS? cd c:\program files\stattransfer9\ st w:\trees.sas7bdat w:\trees.dta

Column mappings in DI Studio user written transform

Hi, We implemented several user-written transformations in DI Studio 4.21. For a new transform I would like to get hold of the mappings the user has defined. For this purpose there is a whole slew of macro variables about all input and output variables. What I can see is what input variable was the mapping source of an output. But AFAICT only the name of the input column, not its table. For example, DI Studio gives me: %let _INPUT_count=2; .... %let _OUTPUT1_col0_input0=SOME_VARIABLE_NAME; .... %let _OUTPUT1_col0_input_count=1; .... In this case of multiple input tables with

TO STAT: Is alpha a conditional probability ?

Hi there, In books, the type I error alpha is commonly written as P(H0 rejected / H0 true). Is this just a notation ? Is it really a conditional probability or is alpha equal to P (H0 rejected AND H0 true) ? Cheers, Catherine.

PC SAS Log & Output Question

What is the maximum number of lines Log and Output windows can display before SASprompts the user to print, save or clear the windows? Is there any way to change it?