Keep in mind that that solution will drop the record if any of the values are null, not just the "adj" variable. ... View more

I like using custom informat to handle these conditions.   proc format; invalue myfmt "null" = . default = 10.5; run; data want; infile datalines firstobs=2 dsd truncover; informat open hi lo close adj vol myfmt.; input date yymmdd10. +1 open hi lo close adj vol; if adj>. then output; datalines; Date,Open,High,Low,Close,Adj Close,Volume 1960-01-04,4.520000,4.520000,4.520000,4.520000,4.520000,0 1960-01-05,4.550000,4.550000,4.550000,4.550000,4.550000,0 1960-01-06,4.680000,4.680000,4.680000,4.680000,4.680000,0 1960-01-07,4.630000,4.630000,4.630000,4.630000,4.630000,0 1960-01-08,4.590000,4.590000,4.590000,4.590000,4.590000,0 1960-01-10,null,null,null,null,null,null 1960-01-11,4.540000,4.540000,4.540000,4.540000,4.540000,0 1960-01-12,4.540000,4.540000,4.540000,4.540000,4.540000,0 1960-01-13,4.560000,4.560000,4.560000,4.560000,4.560000,0 1960-01-14,4.510000,4.510000,4.510000,4.510000,4.510000,0 1960-01-15,4.490000,4.490000,4.490000,4.490000,4.490000,0 1960-01-17,null,null,null,null,null,null 1960-01-18,4.370000,4.370000,4.370000,4.370000,4.370000,0 1960-01-19,4.310000,4.310000,4.310000,4.310000,4.310000,0 1960-01-20,4.300000,4.300000,4.300000,4.300000,4.300000,0 1960-01-21,4.270000,4.270000,4.270000,4.270000,4.270000,0 1960-01-22,4.120000,4.120000,4.120000,4.120000,4.120000,0 1960-01-24,null,null,null,null,null,null 1960-01-25,4.120000,4.120000,4.120000,4.120000,4.120000,0 1960-01-26,4.040000,4.040000,4.040000,4.040000,4.040000,0 1960-01-27,3.990000,3.990000,3.990000,3.990000,3.990000,0 1960-01-28,3.920000,3.920000,3.920000,3.920000,3.920000,0 1960-01-29,3.990000,3.990000,3.990000,3.990000,3.990000,0 1960-01-31,null,null,null,null,null,null ; run; ... View more

Use a "DO; END" block on that if statement.   data temp; do id = 1 to 10; x=ranuni(134); y=ranuni(135); output; end; run; ods rtf file="<your directory>\test.rtf"; %macro m1 (); %let mytitle=This is my title; %let xvalue=; data _null_; set temp; call symputx ('xvalue',x); run; %let yvalue=999; %if (&yvalue ne ) %then %do; ods rtf text="Xvalue is %sysfunc(round(&xvalue,.01))."; %end; title "&mytitle"; proc sgplot data=temp; scatter x=x y=y; run; title ; %mend m1; %m1; ods rtf close; ... View more

If I understand your question, you have your left join inverted.  But I don't think I do because none of your "IP" ranges overlap any of the values in table2.   Are you trying to do something like this?   data temp_table; input start_ip_int 1-11 end_ip_int 13-22 edge_country $25-26; datalines; 1844552000 1844552999 GB 2452812000 2452813000 US 3001796000 3001796999 DE ; run; data temp_table2; input ip_numeric 1-11; datalines; 1844552390 2452812925 3001796479 1844552383 ; run; proc sql; create table ip_match as select a.start_ip_int, a.end_ip_int, a.edge_country, b.ip_numeric from temp_table2 b left join temp_table a on a.start_ip_int <= b.ip_numeric <= a.end_ip_int; quit;   ... View more

DATA DATES; START_DATE_PM = INTNX('MONTH',TODAY(),-1,'B'); CD3PM = INTNX('DAY',START_DATE_PM,2); START_DATE_CM = INTNX('MONTH',TODAY(),0,'B'); CD2CM = INTNX('DAY',START_DATE_CM,1); call symput("CD3PM",put(CD3PM,DATE9.)); call symput("CD2CM",put(CD2CM,DATE9.)); RUN; %PUT &CD2CM; %PUT &CD3PM; ... View more

Perhaps you are looking for something like this:   data have; startdt='08OCT2019'd; output; startdt='08DEC2019'd; output; startdt='08DEC2017'd; output; run; data x; set have; array period [1:100] ; i = 1; period1dt = startdt; do until(period1dt > date() or i > 100); period(i) = period1dt; period1dt = intnx('day',period1dt,45); i = i + 1; end; run; ... View more

And if you want it as rows and a little less hardcoded.   data x; format period1dt date10.; period1dt='08OCT2019'd; do until(period1dt > date()); output; period1dt = intnx('day',period1dt,45); end; run; ... View more

Or, write a little MACRO to save some typing. ... View more

Then my response is why do you care what order they are in?  You can fix the order in whatever output process you use. How would the system know what order you want until you tell it? @ballardw wrote: @tmcwill wrote: Thanks for the response! My issue with this is that there are 124 variables, and I don't want to have to type 124 variables in the length/retain/attribute statement.  ... View more