What you should do depends on what you would like to do. You only have to make sure that you leave out either the intercept or one dummy variable. One approach would be to keep the intercept, define A1=1 as base scenario. Then you would have: Intercept=1; leave out A1=spring(?); A2=1 if summer, 0 otherwise;A3=1 if autumn, 0 otherwise; A4=1 if winter, 0 otherwise ; B1=1 if NY, 0 otherwise, B2=1 if Chicago, 0 otherwise; .. Your model for proc reg (y=dep. var) would be: y = A2--B4 .. ; ... View more

You probably are supposed only to insert data (and not to create tables). Could be something like: Proc SQL; Insert Into <SQL.Table> Select * From <SAS.Table>; Quit; ... View more

It sets/fixes a variable to a certain value.   Exactly as in:    proc optmodel;       var x{1..10};       fix x = 0;       fix x[10] = 1;   From: http://support.sas.com/documentation/cdl/en/ormpug/66851/HTML/default/viewer.htm#ormpug_optmodel_syntax11.htm ... View more

I would use a hash iterator:   data Master; input pid details & : $100.; cards; 101 The new NASA Software Catalogue includes the code LEWICE, developed to help study 102 core module will be followed by a series of launches for other components of the space 103 Pateinst suffered with ASTHMA 104 Surgery is the best way to remove tumor from Pain 105 Trial need patient with heart burn earlier 106 Clinical trial do not require volunteer with allergicasthmA. ; run; data event; input adv_event $15.; cards; death asthma heart burn ; run; Data want_hash (Drop=rc); If _N_ eq 1 Then Do; Declare Hash H (Dataset:'event'); Declare HIter HI ('H'); H.Definekey('adv_event'); H.Definedata('adv_event'); H.Definedone(); If 0 Then Set event; End; Set Master; rc=HI.First(); Do While (not rc); If Find(UpCase(details),UpCase(Trim(adv_event))) Then Do; Output; Leave; End; rc=HI.Next(); End; Run; ... View more

I think you are thinking in the wrong direction. You probably only need proc means.   * .. imagine these are your data; Data A (Drop=i); i=1; Format Date Date9.; Do While (i<=1500); Date='01JAN2010'd+i; Price=Round(Rannor(1)*5+100,0.01); Shares=Round(Ranuni(1)*1000,1); i=i+Ceil(Ranuni(1)*2+1); * .. want the time series to be intermittent; Output; End; Run; * .. then use a auxiliary variable ; Data A; Set A; Year=Year(Date); Run; Proc Means Data=A NoPrint; By Year; Var Date; Output Out=A_Result (Drop=_: Year) MaxID(Date(Price) Date(Shares))=Price Shares Max(Date)=; Run; ... View more

Your file does not open. Proc import might be easier.   proc import datafile=.. your path ../order.txt'' out=order dbms=dlm replace; delimiter='09'x; * for tab-delimited files; run;     http://support.sas.com/documentation/cdl/en/proc/69850/HTML/default/viewer.htm#n1w1xy48wd290bn1mqalitn7wy13.htm ... View more

(simplistic 🙂 ) solution: Data A; Format Name $8. Value 8. BodyPart $8. UnknownVar $12. Value2 8.; Input Name $ Value BodyPart $ UnknownVar $ Value2; Datalines; Jack 500 head . 23 Jack . head patil 23 Tim 100 shoulder . 24 Tim 100 . Dufwenberg . ; * ^^^ check if this is similar to your data here ..; Data B (Keep=Dummy: Rename=(DummyName=Name DummyValue=Value DummyBodyPart=BodyPart DummyUnknownVar=UnknownVar DummyValue2=Value2)); Set A; Format DummyName $8. DummyValue 8. DummyBodyPart $8. DummyUnknownVar $12. DummyValue2 8.; Retain DummyName DummyValue DummyBodyPart DummyUnknownVar DummyValue2; By /*Notsorted*/ Name; If not Missing (Name) Then DummyName=Name; * hm, different var types are a bit awkward ..; If not Missing (Value) Then DummyValue=Value; * .. could try array otherwise ..; If not Missing (BodyPart) Then DummyBodyPart=BodyPart; * .. or maybe call execute; If not Missing (UnknownVar) Then DummyUnknownVar=UnknownVar; If not Missing (Value2) Then DummyValue2=Value2; If Last.Name Then Output; Run; ... View more

.. this one also shifts ..   Data B2 (Drop=i j); Set A; Array A{*} A:; Do i=1 To Dim(A); Do j=i To Dim(A); If (A{j}=A[i}) & (i^=j) Then Call Missing (A{j}); End; End; Do i=1 To Dim(A); If Missing (A{i}) Then Do j=i+1 To Dim(A); If not Missing (A{j}) Then Do; A{i}=A{j}; Call Missing (A{j}); End; End; End; Run; ... View more