thanks you, just changed some of the code and works perfectly 🙂 ... View more

Hi it seems to be falling over immediately.   32 proc sql noprint; 33 select int(nobs/2) into :nobs_half 34 from dictionary.tables 35 where libname = 'work' and memname = 'cell002'; NOTE: No rows were selected. 36 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 5160.37k OS Memory 38316.00k Timestamp 12/07/2018 08:51:55 AM Step Count 82 Switch Count 34 Page Faults 0 Page Reclaims 13 Page Swaps 0 Voluntary Context Switches 84 Involuntary Context Switches 1 Block Input Operations 0 Block Output Operations 0 37 38 data cell002_003; 39 set work.cell002; 40 if _n_ <= &nobs_half WARNING: Apparent symbolic reference NOBS_HALF not resolved. 40 if _n_ <= &nobs_half _ 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, 2 The SAS System 07:45 Thursday, July 12, 2018 a missing value, bitstring, INPUT, PUT. 41 then cellid = '002'; ______ _ 180 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 42 else cellid = '003'; 43 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.CELL002_003 may be incomplete. When this step was stopped there were 0 observations and 74 variables. WARNING: Data set WORK.CELL002_003 was not replaced because this step was stopped. ... View more

Morning, I am actually using SAS code in a code window rather than point and click in EG. My data contains 89,382 records which I need to split out into two separate cells but I need to prioritise one of the cells above the other. I was doing the following code to randomly sort them out but this wouldn't allow me to prioritise the data.   proc sort data = cell002; by priority; run; /* ALSO CELL 002 SPLIT 50% WITH CELL 003 */ data cell002_003; set cell002; if priority = '2' and mod (_n_,2) = 1 then do; cellid = '003'; end; run;     I found the only way I could get around this was to use the count feature but this required me to know the exact volumes before hand.   proc sort data = cell002; by priority; run; /* ALSO CELL 002 SPLIT 50% WITH CELL 003 */ data cell002_003; set cell002; if _n_ <= 44691 then cellid = '002'; else if _n_ > 44691 then cellid = '003'; run;     Am not sure if this help you at all as it's not the easiest to explain. But I need cell's 002 & 003 to hold equal volumes but I also need to prioritise 19,176 records that have the variable Priority that's equal to 1 into cell002 and then the remaining split out. ... View more