Thank you for your interest 🙂 Because of you i improved my array skills 🙂 ... View more

Thank you Tom. I will consider your recommendation but it goes without saying that sometimes i need to post my data to better explanation. ... View more

Thanks a lot. It worked.I'll examine whole of the code in detail. Thanks for leaded me.   Can. ... View more

Thanks a lot. ... View more

Note that when doing the merge merge TABLE2 TABLE(in=Y); you are matching one to one, so the shortest table (in terms of number of observations) stops the processing even if the other one is longer.       ... View more

Thanks a lot. It is working 🙂 ... View more

Hi,   Actually, I need this program to be defined as a macro. I mean, we have more than hundreds of variables to be defined sequentially in a macro. There is an example in the below which shows a basic process. If I can define these process with a loop, then I will be succeed in other outputs.   So, how can I write this program to define each value as a macro and make it change in each step with a loop process?   Thanks & Regards, Can         data Table1; length ID $ 3; input ID; datalines;Q1 Q1_ Q2 Q2_ Q3 Q3_; run; data _null_; set Table1; call symput(ID,put(ID,3.));run;Data Table2;Variable="&ID";run   ... View more

So the problem is that your original TABLE2 does not already have any identifying variables to represent the groups.  You only have one group.  What is happening in that case with this data step view is that the variable ID is staying = to -1 when the first real data is read from TABLE2 (since there is no ID variable in that table).  If you just add a statement after the DO I= loop to set ID to missing then that will fix the problem.   if _n_=1 then do ; id=-1 ; do i=1 to 6 ; variable = cats('q',i); output; end; id=.; end;   ... View more

Yes. That's it. Thank you 🙂   PROC UNIVARIATE data=WORK.sample OUTTABLE=want (keep=_var_ _mean_ _std_ _mode_ RENAME=( _VAR_=VARIABLE _MEAN_=MEAN _STD_=STDDEV _MODE_=MODE )); var Q:; RUN; ... View more

Thanks everyone. I posted photos because i think it is the best way to tell what i try to do and i also post my SAS code to describe you. Everyone helps me within this this period i imporove my skills. I try to find best way to use memory more efficiency. I guess less data steps or proc sql steps more efficiency. Thanks again. ... View more

Thanks a lot. I made it. 🙂 ... View more

You can calculate sum at a data step level but its more complex and requires a DOW loop. That being said, I didn't thoroughly go over your program. I don't understand your next question. And since it looks unrelated I'll suggest posting a new question. L ... View more

Are there any simple methods to make this @Tom wrote: You posted three columns of data, but no column names. Your SQL references 4 varaibles: ID DEGER2 COLUMN and COLUMN2. What does your output look like?  Do have variables named AAA and ABA?  Do you have a observations for ID=1,2,3,4,5? Or do you have observations for ID=11,21,22,23,.... ?   ? ... View more

Thanks a lot. I was very important for me thanks again 🙂 ... View more