You can "skip" variables by reading them into a dummy (which you drop): data want; infile cards delimiter=','; length dummy $8 first $8 four 8 fifth $30; input first dummy dummy four fifth; drop dummy; cards; "ABC","DATA","G:\Data\ces 202302.csv",654,14/04/2023 14:17:14 "ABC","DATA","G:\Data\ces 202302.csv.bak",654,14/04/2023 14:00:41 "XYZ","DATA","G:\Data\ces 202303.csv",5770,14/04/2023 14:17:39 "XYZ","DATA","G:\Data\ces 202303.csv.bak",5770,14/04/2023 09:49:28 "DEF","DATA","G:\Data\CES individuele.xlsx",104637,23/03/2023 14:53:38 "DEF","DATA","G:\Data\CES.xlsx",23370,23/03/2023 14:53:19 "DEF","DATA","G:\Data\12GR.csv",539,08/02/2023 15:12:13 ;run; ... View more

Assuming that your data is sorted by OBJ and DATE (meaning that missing dates come first) this should do it data want; set have; by obj date; if first.obj then count=not missing(date); else count+first.date; run; ... View more

I think that you want is to sort by case_PatientID and not control_PatientID. ... View more

Actually, @Zakharkou wanted to find out if there was a 1 in the group, not any positive value, so the SQL solution should be written as  proc sql ; select * ,(max(var1 = 1) and max(var2 = 1) as flag from have group by id ; quit ; ... View more

Your SQL solution will only work if 1 is always the maximum value - if there are larger values as well, e.g. 2 or 888, your solution will not find the ones. ... View more

You can do it with a datastep, like this: data want; do until(last.id); set have; by id; if var1=1 then flag1=1; if var2=1 then flag2=1; end; flag=flag1 and flag2; do until(last.id); set have; by id; output; end; drop flag1 flag2; run; ... View more

I guess something like this may work: data want; set have; array values(*) a1-a80; array temp(80) 8 _temporary_; do _N_=1 to dim(values); temp(_N_)=values(_N_); end; call sortn(of temp(*)); _n=n(of temp(*)); if _n then do; /* find the first valid value */ _first=dim(temp)-_n+1; /* find 20th percentile */ _20pct=temp(_first+floor(_n/5)); do _N_= 1 to dim(values); if values(_N_)>_20pct then values(_N_)=1; else values(_N_)=0; end; drop _:; run; ... View more

Another solution if you need to use the DATALINES statement in a macro call is to put the datastep code in a separate SAS file, and then just %INCLUDE it from the macro %macro AriINPChart; proc sort data=icd_10_cm_b; by icd_10_cm; run; data icd_10_cm; set icd_10_cm_a icd_10_cm_b; run; proc sort data=icd_10_cm nodupkey; by icd_10_cm; run; %include 'c:\datastep.sas'; - you probably want another path for the datastep code, but that's the idea.    ... View more

The formula can be calculated in a single step, but as the same complex expression occurs twice, it is faster to calculate it in two steps: FAST=exp(-1.65+1.07*log(LSM)+2.66E-8*CAP**3-63.3/AST); FAST=FAST/(1+FAST); - by "faster" I mean both the amount of typing to be done, and the CPU time for the calculation. ... View more

Something like this, I suppose: data want; set have; array dates(*) date_1-date_10; do _N_=1 to dim(dates); if missing(dates(_N_)) then continue; if dates(_N_)<_date then do; output; leave; end; _date=dates(_N_); end; drop _date; run; ... View more

It's a bit hard to say where the error message comes from, but I think it is because you have a comma before FROM.   As for your "subselect" statements, they do not make sense at all. What are you trying to accomplish with those? ... View more

If you are so lucky that there are only numeric variables at the end of your dataset vector, you can use "--" to get the variables in order of definition, e.g. data want; set have; array M (*) _numeric_; array L(*) m201234--n345; Totavg=mean(of M(*)); avg2=mean(of L(*)); run; (you should not calculate the mean more than once, the code you showed would just assign the same value to the same variable over and over again)   If your numeric variables are intermixed with characters, you can change the order of the variables by reading character variables in one SET statement and numeric values in another: data want; set have(keep=_NUMERIC_); set have(keep=_CHARACTER_); array M (*) _numeric_; array L(*) m201234--n345; Totavg=mean(of M(*)); avg2=mean(of L(*)); run;   ... View more