Pivot table in SAS Hi, I need to create a pivot table with 7 variables at row level and 28 variables in column. Can anyone help me in doing the same in SAS. I have gone through the paper by Ted Conway. i am a bit confused. Can anyone help with step by step procedure for the same.. Thanks in advance, Regards, Subha ... 8 Mar 2010 07:29
using WHERE syntax in the Regression to delete an observation Hello All, I want to remove an observation from the data.Suppose that I'm predicting Y from A,B and C and that I initially removed say D from the analysis.Now , if I want to not have the observation, say 50 in my analysis then in the WHERE condition what variable I must use. The code I used is :- proc reg d... 9 Mar 2010 13:29
Proc Insightr Running Error hello All, I am getting message that I could not enetr new command as the PROC insight is runnning. What change should i make in the code below so that I can avoid this problem. /*Scatter plot for Score against the 5 predictor variables*/ proc insight data=sc.music; scatter Score GHz Processor Disk Video Ba... 7 Mar 2010 17:22
Proc tabulate....N defaulting on output Help! "N" and values always appear at the bottom of each column of my proc tabulate output. I am not specifying N in the procedure, but N (number of observations) is always output at the bottom of each table created. How do I stop N appearing? I would appreciate any help! Thankyou Suzanne. ... 8 Mar 2010 07:29
Many-to-many merge Hi, I am having difficulty with a many-to-many merge between two datasets. The two datasets actually have 2 variables in common (ID and VISNO), but I want to merge on ID only since I would lose some data from the first dataset if I merge with ID and VISNO. Here are both my merge and procSQL codes: proc sort ... 7 Mar 2010 16:16
format problem This means that a format associated with a variable is not around. Most likely one of your variables defined as metadata in one of the tables used in the DI job will have this format associated. Have a look at options fmterr and fmtsearch= HTH Patrick ... 7 Mar 2010 12:56
format problem Hi All, Please help me in the format problem... I am using DI studio and suddenly i am getting an error message like "Error: the format PRODDIM was not found or could not be loaded" . Can any one please help me in resolving this issue.. Thanks ... 6 Mar 2010 20:40
Simple Macro question Hi All, I wrote a simple macro code to generate 6 new variables: My original data set looks like: t1 t2 t3 p1 p2 p3 Then I would like my new dat looks like: t1 t2 t3 p1 p2 p3 tv1 tv2 tv3 pv1 pv2 pv3 But I am not sure what I did wrong below. Can anyone give me some advices? Thank you... 6 Mar 2010 23:54
S.E. & C.D. in Split Plot design with SAS Hi all, I want to calculate the following Standard Errors and Crirtical Differences for Split Plot design using SAS. The formulas as follows: 1. Estimate of S.E. of difference b/w two main plot treatment means = Sqrt(2*E1/r*b) 2. Estimate of S.E. of difference b/w two sub plot treatment means = Sqrt(2*E2/r*... 11 Mar 2010 04:32 |