Nevermind, I see now that the Libname statement does not actually create a new folder on your computer.  ... View more

Ok thank for the reply Paige. But why can't I see the permanent folder or dataset anywhere? It is not in the location that I created it with using a filepath on my computer, and it is not in sas explorer window. Overtime I'm sure I will have multiple folders with multiple datasets in them and will not be able to remember everything when I want to reference a dataset. ... View more

Can't believe I missed that. I couldn't figure it out. Thanks for taking the time to look through it and help me out. ... View more

Well I was originally trying to do this using macros but I just couldn't figure it out at all. I am just a beginner so this was just the easiest way I knew to do it.  ... View more

This is the first part of the log where zero observations begin to occur:   77 78 data tempa; 79 set proj3; 80 if upcase(inst_num)= "CANCER INSTITUE 2"; 81 NOTE: There were 4000 observations read from the data set WORK.PROJ3. NOTE: The data set WORK.TEMPA has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 82 data tempb; 83 set tempa; 84 85 if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; 86 x= ranuni(0); 87 output; 88 NOTE: There were 0 observations read from the data set WORK.TEMPA. NOTE: The data set WORK.TEMPB has 0 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 89 proc sort data=tempb; 90 by x; 91 run; NOTE: Input data set is empty. NOTE: The data set WORK.TEMPB has 0 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 92 93 data one; 94 set tempb (obs=5); 95 run; NOTE: There were 0 observations read from the data set WORK.TEMPB. NOTE: The data set WORK.ONE has 0 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.00 seconds ... View more

Hey paigemiller,   I do not get any errors in the SASLOG, however, starting with cancer institute 2 and on, everything created has 0 observations, I've looked through and can't figure it out. ... View more

Thank you Reeza, that was very helpful. I am having one other issue. When I try to print my data, it only prints the data from Cancer institute 1 and leaves out cancer institute 2-5. Do you see anything else that I am doing wrong?       data tempp; set buy; if upcase(inst_num)= "CANCER INSTITUTE 1" ; data temp1; set tempp; if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; x= ranuni(0); output; proc sort data=temp1; by x; run; data one; set temp1 (obs=5); run; data temp2; set tempp; if upcase(leu_type)= "ACUTE MYELOID LEUKEMIA (AML)"; x= ranuni(0); output; proc sort data=temp2; by x; run; data two; set temp2 (obs=10); run; data temp3; set tempp; if upcase(leu_type)= "CHRONIC LYMPHOCUTIC LEUKEMIA (CLL)"; x=ranuni(0); output; proc sort data=temp3; by x; run; data three; set temp3 (obs=20); run; data temp4; set tempp; if upcase(leu_type)= "CHRONIC MYELOID LEUKEMIA (CML)"; x=ranuni(0); output; proc sort data=temp4; by x; run; data four; set temp4 (obs=5); run; data new1; set one two three four; run; data tempa; set proj3; if upcase(inst_num)= "CANCER INSTITUE 2"; data tempb; set tempa; if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; x= ranuni(0); output; proc sort data=tempb; by x; run; data one; set tempb (obs=5); run; data tempc; set tempa; if upcase(leu_type)= "ACUTE MYELOID LEUKEMIA (AML)"; x= ranuni(0); output; proc sort data=tempc; by x; run; data two; set tempc (obs=10); run; data tempd; set tempa; if upcase(leu_type)= "CHRONIC LYMPHOCUTIC LEUKEMIA (CLL)"; x=ranuni(0); output; proc sort data=tempd; by x; run; data three; set tempd (obs=20); run; data tempe; set tempa; if upcase(leu_type)= "CHRONIC MYELOID LEUKEMIA (CML)"; x=ranuni(0); output; proc sort data=tempe; by x; run; data four; set tempe (obs=5); run; data new2; set one two three four; run; ************************************************ ******************************** *********************; data tempp; set proj3; if upcase(inst_num)= "CANCER INSTITUE 3"; data temp1; set tempp; if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; x= ranuni(0); output; proc sort data=temp1; by x; run; data one; set temp1 (obs=5); run; data temp2; set tempp; if upcase(leu_type)= "ACUTE MYELOID LEUKEMIA (AML)"; x= ranuni(0); output; proc sort data=temp2; by x; run; data two; set temp2 (obs=10); run; data temp3; set tempp; if upcase(leu_type)= "CHRONIC LYMPHOCUTIC LEUKEMIA (CLL)"; x=ranuni(0); output; proc sort data=temp3; by x; run; data three; set temp3 (obs=20); run; data temp4; set tempp; if upcase(leu_type)= "CHRONIC MYELOID LEUKEMIA (CML)"; x=ranuni(0); output; proc sort data=temp4; by x; run; data four; set temp4 (obs=5); run; data new3; set one two three four; run; *****************; data tempp; set proj3; if upcase(inst_num)= "CANCER INSTITUE 3"; data temp1; set tempp; if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; x= ranuni(0); output; proc sort data=temp1; by x; run; data one; set temp1 (obs=5); run; data temp2; set tempp; if upcase(leu_type)= "ACUTE MYELOID LEUKEMIA (AML)"; x= ranuni(0); output; proc sort data=temp2; by x; run; data two; set temp2 (obs=10); run; data temp3; set tempp; if upcase(leu_type)= "CHRONIC LYMPHOCUTIC LEUKEMIA (CLL)"; x=ranuni(0); output; proc sort data=temp3; by x; run; data three; set temp3 (obs=20); run; data temp4; set tempp; if upcase(leu_type)= "CHRONIC MYELOID LEUKEMIA (CML)"; x=ranuni(0); output; proc sort data=temp4; by x; run; data four; set temp4 (obs=5); run; data new4; set one two three four; run; *********************************; data tempp; set proj3; if upcase(inst_num)= "CANCER INSTITUE 5"; data temp1; set tempp; if upcase(leu_type)= "ACUTE LYMPHOCYTIC LEUKEMIA (ALL)"; x= ranuni(0); output; proc sort data=temp1; by x; run; data one; set temp1 (obs=5); run; data temp2; set tempp; if upcase(leu_type)= "ACUTE MYELOID LEUKEMIA (AML)"; x= ranuni(0); output; proc sort data=temp2; by x; run; data two; set temp2 (obs=10); run; data temp3; set tempp; if upcase(leu_type)= "CHRONIC LYMPHOCUTIC LEUKEMIA (CLL)"; x=ranuni(0); output; proc sort data=temp3; by x; run; data three; set temp3 (obs=20); run; data temp4; set tempp; if upcase(leu_type)= "CHRONIC MYELOID LEUKEMIA (CML)"; x=ranuni(0); output; proc sort data=temp4; by x; run; data four; set temp4 (obs=5); run; data new5; set one two three four; run; data new; set new1 new2 new3 new4 new5; run; proc print data=new; title 'Tabulation of selected records'; run; ... View more

Ok sorry about that, here are the errors in the log:   16 data temp1; 17 set tempp; 18 19 if leu_type= Acute Lymphocytic Leukemia (ALL); ----------- 388 76 ERROR 388-185: Expecting an arithmetic operator. ERROR 76-322: Syntax error, statement will be ignored. 20 x= ranuni(0); 21 output; 22 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEMP1 may be incomplete. When this step was stopped there were 0 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds   23 proc sort data temp1; ----- 73 ERROR 73-322: Expecting an =. 24 by x; 25 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SORT used (Total process time): real time 0.05 seconds cpu time 0.00 seconds   ... View more

@FreelanceReinhthanks for the reply, that was a great explanation, very helpful. I fixed everything you mentioned except the length statement bc I am not seeing any truncation. However something still isn't working correctly. Now it is printing out all 144 observations, but the absenses are not correct, it seems to be assigning the last value in the datalines to all the variables? not sure if i explained that correctly. here is what i updated   options nonumber nodate; data example33;  input x1 - x6;  if _n_ in (1,2,3,4,5,6) then district = 'OKEECHOBEE';   else IF _N_ IN (7,8,9,10,11,12) THEN DISTRICT= 'SEMINOLE';   else IF _N_ IN (13,14,15,16,17,18) THEN DISTRICT= 'VOLUSIA';   ELSE DISTRICT= 'WALTON';    if _n_ in (1,2,7,8,13,14,19,20) then race= 'B';  else if _n_ in (3,4,9,10,15,16,21,22) then race= 'W';  else race= 'O';  if _n_ in (1,3,5,7,9,11,13,15,17,19,21,23) then gender= 'M';  else gender= 'F';  array pr2(6) x1-x6;  do i= 1 to 6;   if i < 4 then learntype= 'Passive';   else learntype= 'Active';   if i in (1,4) then level= 'Elementary';   else if i in (2,5) then level= 'Middle';   else level= 'High';  absenses= pr2(6);  output;   end;  drop I; ... View more

Thanks for the reply @Kurt_Bremser. So I made a couple of changes by adding else if statements, but I still am only getting 24 observations where I should have 144. problem seems to be the variables level and learntype. options nonumber nodate; data example33;  input x1 - x6;  if _n_ in (1,2,3,4,5,6) then district = 'OKEECHOBEE';   else IF _N_ IN (7,8,9,10,11,12) THEN DISTRICT= 'SEMINOLE';   else IF _N_ IN (13,14,15,16,17,18) THEN DISTRICT= 'VOLUSIA';   ELSE DISTRICT= 'WALTON';    if _n_ in (1,2,7,8,13,14,19,20) then race= 'B';  else if _n_ in (3,4,9,10,15,16,21,22) then race= 'W';  else race= 'O';  if _n_ in (1,3,5,7,9,11,13,15,17,19,21,23) then gender= 'M';  else gender= 'F';  array pr2(6) x1-x6;  do i= 1 to 6;   if i < 4 then learntype= 'Passive';   else learntype= 'Active';   if i in (1,4) then level= 'Elementary';   else if i in (2,5) then level= 'Middle';   else level= 'High';  absenses= pr2(6);   end;  drop I;   ... View more