Dear All Suppose I have data: 001F36175180 Variable description for this data is: ID: columns1-3 Sex: columns 4 Age: columns 5-6 Height: columns 7-9 Weight: columns 10-12 I know I can read in this data using code: input   @1 ID $3. @4 Sex $1. @5 Age 2. @7 Height 3. @10 Weight 3.; However, the above method is to read data from left to right; my question is, is there a way to read data from right to left, such as: input   @12 Weight -3. @9 Height -3.. @6  Age -2. @4 Sex -1. @3 ID -3.; ... View more

dear all I apologize for asking a question that is not directly linked to SAS procedure. I am asking this question because many people have asked me if I have any experience with Large Size Data. The largest data I have ever dealt with is about 200MB, and I don't feel much difference. I realize that nowdays data could be several GB big or even bigger, but I don't understand what a data analyst will do differently with those Large Size Data in comparison with normal size data. Could anyone give me some hint? Or is there any book I can read? Thank you very much. ... View more

Dear All I have searched on internet about Macro arrays. But the results are rather confusing to me. So I want to ask the question here by using an example. Suppose I have following codes: data Test; input OldVar1 OldVar2 OldVar3; Cards; 1 2 3 ; Run; %macro GetVarNames(dsn); %local dsid rc; %global Cnt ArrayX; /*See my question in following*/ %let dsid=%sysfunc(open(&dsn)); /* Open data set */ %let Cnt=%sysfunc(attrn(&dsid,nvars)); /* get the number of variables in the dataset*/ %do i = 1 %to &Cnt; %let ArrayX=%sysfunc(varname(&dsid,&i)); /*See my question in following*/ %end; %let rc=%sysfunc(close(&dsid)); /* Close the data set */ %mend; What I want to do is: I want to define a macro array ArrayX(Cnt) of which the dimension will be defined by Cnt so that, according to the above example, ArrayX(1) = OldVar1, ArrayX(2) = OldVar2, ArrayX(3) = OldVar3. How should I do this? ... View more

Dear All Suppose I have following data set: data test; input row col count; cards; 1 1 11 1 2 4 2 1 13 2 2 1 ; run; Because this data set violates the proportion test assumption, I need to do continuity correction; and I also need to perform one sided test. So I ran following codes: proc freq data=test; tables row*col/riskdiffc (EQUAL); weight count; run; The one-sided p-value I got from running this SAS code is 0.1719. However when I try to solve the exactly same problem using R, I got one-sided p-value=0.8157. My question is: why the p-values from SAS and R are different? Personally I think p-value=0.8157 (from R) is correct, as proportion1 is greater than proportion2 suggesting the p-value should be greater than 0.5. Did I make any mistake in my SAS coding? ... View more

Dear All Suppose I have following codes: data test; input ID Var1; cards; 1 1 2 2 3 3 ; run; data test2; input IDX Var100; cards; 100 100 200 200 400 400 ; run; PROC SQL; CREATE TABLE Combined AS SELECT u1.*, u2.* FROM test as u1 FULL JOIN test2 as u2 ON u1.ID = (u2.IDX)/100 ; QUIT; The created data set Combined look like: ID Var1 IDX VAR100 1 1 100 100 2 2 200 200 3 3 . . . . 400 400 Now I want to careate one more Variable, Say Var999 that tells whether the combined data contains data from both dataset test and dataset test2 so that the created data set Combined will look like: ID Var1 IDX VAR100 Var999 1 1 100 100 1 2 2 200 200 1 3 3 . . 0 . . 400 400 0 Can someone tell me how to do it? ... View more