I have the dataset below:   ID a b c d 1 1 1 . . 2 1 . 1 1 3 1 1 1 .   and I want to add another column called "Result", that sum the variables a,b,c and d without taking into account the missing values and values after the missings.   The data I want to get is like this one: ID a b c d Result 1 1 1 . . 2 2 1 . 1 1 1 3 1 1 1 . 3   Ps: in my real data I have more than 4 variables (a,b,c,d) How could I program it in SAS and thanks in advance. ... View more

I want to use proc sql to create the maximum of each var by ID, and since I have many variables so I want to use the loop do. I used the below code but I get only var100 , but I want all variables to be in the new_start table. %macro m(); proc sql; %do j=1 %to 100; create table new_start as select distinct ID, max(var&j.) as var&j. from start group by ID order by ID; %end; quit; %mend; %m(); I want that  new_start dataset contains: ID var1 var2 var3 ..... var100 ... View more

I have the dataset below, and I want to know if there is a difference in Response between SoilTest, Irrigati, MowHeigh and Clipping, but I want to use the long format of the data: data data; input Practice $ Student $ Response $; datalines; SoilTest a Yes SoilTest b No SoilTest c Yes SoilTest d Yes SoilTest e No SoilTest f Yes SoilTest g Yes SoilTest h Yes SoilTest i No SoilTest j Yes SoilTest k Yes SoilTest l Yes SoilTest m Yes SoilTest n Yes Irrigation a Yes Irrigation b No Irrigation c No Irrigation d No Irrigation e No Irrigation f No Irrigation g No Irrigation h No Irrigation i Yes Irrigation j No Irrigation k No Irrigation l No Irrigation m No Irrigation n No MowHeight a Yes MowHeight b No MowHeight c Yes MowHeight d Yes MowHeight e Yes MowHeight f Yes MowHeight g Yes MowHeight h Yes MowHeight i No MowHeight j Yes MowHeight k Yes MowHeight l Yes MowHeight m Yes MowHeight n Yes Clippings a Yes Clippings b No Clippings c No Clippings d Yes Clippings e Yes Clippings f No Clippings g No Clippings h Yes Clippings i Yes Clippings j Yes Clippings k Yes Clippings l No Clippings m Yes Clippings n No ; run; Actually this code working, but with changing the shape of the table: proc sort data=data;by student;run; proc transpose data=data out=data_test(drop=_NAME_); ID Practice; BY student; VAR Response; run; proc freq data=data_test; tables SoilTest Irrigati MowHeigh Clipping/nocum; tables SoilTest*Irrigati*MowHeigh*Clipping/agree noprint; run;   is there any possibility to have the same pvalue of Cochran test, without changing the shape of the data, it means :using the long format of data without doing transpose ?   ... View more

I have the code below: data want; input mydate1 :yymmdd10. mydate2 :yymmdd10.; format mydate1 mydate2 yymmddd10.; datalines; 2020-08-27 2020-10-22 2020-03-01 2020-04-26 ; run; data want2; set want; diff_months=intck("month",mydate1,mydate2); diff_days=intck("day",mydate1,mydate2); run; proc print;run; which provides the dataset want2   but I don't know why I don't have same diff_months=1 for both rows, since we have the same diff_days !   ... View more