I have the following: Date _1_2_14 _1_3_14 _1_6_14 _1_7_14 _1_8_14 _1_9_14 _1_10_14 and so on..... and I want to convert it to a date. How can I do that? Thanks for all the help! ... View more

Hi I have this big data set and I need to create few subsets: 1) if _market_ contains the word "notes' => then take all "notes" out to a new dataset and remove them from the main dataset 2)then if _taxable_ = "Y" => then take all taxable out to a new dataset and remove them from the main dataset .......and so on with few more characteristics to be taken out and at the end I want to have one dataset that doesn't contain notes, taxable etc...(based on my other if statements) and then datasets where I keep separate all the once that I don't need (for example I will have a separate dataset wit "notes", another separate wit "taxable" etc...) ...so ideally I want to create 6 datasets from the main one. Any and all help and suggestions will be great! Thanks!!! ... View more

Hi, I have the following code %let STATE1=AL; %let STATE2=AK; %let STATE3=AZ; %let STATE4=AR; %let STATE5=CA; %let STATE6=CO; %let STATE7=CT; %let STATE8=DE; %let STATE9=DC; %let STATE10=FL; %let STATE11=GA; %let STATE12=HI; %let STATE13=ID; %let STATE14=IL; %let STATE15=IN; %let STATE16=IA; %let STATE17=KS; %let STATE18=KY; %let STATE19=LA; %let STATE20=ME; %let STATE21=MD; %let STATE22=MA; %let STATE23=MI; %let STATE24=MN; %let STATE25=MS; %let STATE26=MO; %let STATE27=MT; %let STATE28=NE; %let STATE29=NV; %let STATE30=NH; %let STATE31=NJ; %let STATE32=NM; %let STATE33=NY; %let STATE34=NC; %let STATE35=ND; %let STATE36=OH; %let STATE37=OK; %let STATE38=OR; %let STATE39=PA; %let STATE40=RI; %let STATE41=SC; %let STATE42=SD; %let STATE43=TN; %let STATE44=TX; %let STATE45=UT; %let STATE46=VT; %let STATE47=VA; %let STATE48=WA; %let STATE49=WV; %let STATE50=WI; %let STATE51=WY; %let YEAR1=2010; %let YEAR2=2011; %let YEAR3=2013; %Macro Keep;  %do i = 1 %to 1; %do j = 3 %to 3; data by_state_&&i.; set data_2012; where state=&i; run;   %end;    %end;       ; run;     %Mend Keep;   %Keep; I have database with data for each state and I am trying to do calculations by state. However when I run the code above - I tried having the &I in "" and with and without the dot after it (&I and &I.), but I either get this error message "ERROR: WHERE clause operator requires compatible variables." or the data doesn't gets picked up because lets say for example the %do i = 1 %to 1;  doesn't pick up that I am looking for state AL but refers it as to 1 iMPRINT(KEEP):   data by_state_1; iMPRINT(KEEP):   set data_2012; iMPRINT(KEEP):   where state="1"; iMPRINT(KEEP):   run; and doesn't find any data . What am I doing wrong? Thanks!!!! ... View more

Attached is a sample data of what I am trying to do. The top part is the raw data and the bottom part is how I want my data to look. So basically when the ID# is the same keep the descriptive information on the first row (like amt, price1, price2, maturity, etc...) but delete the repetitive info when there are different transactions recorded for the same ID# on different dates - this would make my sheet more clean.... Let me know if you have problems opening the attachment - I can try to copy the data here. Thanks for your help! ... View more