Hi,   How do i fetch multiple column name for a value using Vname function.    /*Input*/ Vid sep_2017 Oct_2017 Nov_2017 Dec_2017 jan_2018 max aa 3 0 5 1 0 5 bb 4 4 4 4 2 4 cc 8 3 8 1 2 8 dd 0 0 0 5 1 5 ee 9 2 5 6 9 9 /*expected output**/ Vid sep_2017 Oct_2017 Nov_2017 Dec_2017 jan_2018 max Period aa 3 0 5 1 0 5 Nov_2017 bb 4 4 4 4 2 4 sep_2017,Oct_2017,Nov_2017,Dec_2017 cc 8 3 8 1 2 8 sep_2017,Nov_2017 dd 0 0 0 5 1 5 Dec_2017 ee 9 2 5 6 9 9 sep_2017,Dec_2017 /**Code**/ Data want; Length period $200.; Set need; Array V (*) sep_2017 -- jan_2018 ; do i = 1 to dim(v)until (i = DIM(V)); if v{i}=Highest_variance then do; name=vname(v[whichn(Highest_variance, of v{i} )]); period=CATX(',',period,name); end; end; RUN; ... View more

Hello,   i have two datasets and i need to get variance between two dataset so i have used proc compare. I need missing values in the output to be changed to 100 in my output when either one of the input has a value and other one has zero or missing. The data i have mentioned here is sample one. Rows and columns will be more in actual data. /**Dataset 1**/ Data DT1; input v_id $ @4 month1 @7 month2 @10 month3; datalines; aa 12 58 0 bb 34 47 . cc 25 . 54 ; run; /**Dataset 2**/ Data DT2; input v_id $ @4 month1 @7 month2 @10 month3; datalines; aa 62 58 3 bb 34 47 . cc 15 0 54 dd 15 12 14 ee 8 9 65 ; run; /** Compare***/ Proc compare base=dt1 compare=dt2 OUTPERCENT out=result noprint; ID V_Id; VAR _NUMERIC_; run; /**Output from proc compare**/ _TYPE_ _OBS_ v_id month1 month2 month3 PERCENT 1 aa 416.6666667 0 . PERCENT 2 bb 0 0 . PERCENT 3 cc -40 . 0 /**expected output**/ _TYPE_ _OBS_ v_id month1 month2 month3 PERCENT 1 aa 416.6666667 0 100 PERCENT 2 bb 0 0 . PERCENT 3 cc -40 . 0     ... View more

Hi, I have a Variable_ID and 8 quarters of data. This data is the output of a proc compare and I have created a varlist based on required quarters. i need the number of non missing and max for the varlist. I have attached the data and the desired output.   I have tried in two different ways but none of them giving me the correct results. It is considering all the columns.   Code1:   data want; set date; Count=N(Varlist); Max=MAX(Varlist); Run;   Code2:   Proc Sql; Select count(variable_id) INTO: count from date; quit;   Data_null_; call symput('count1',left(count)); run;   Proc Sql; Select varlist INTO: list1  :list&count. from date; quit;   %macro dlt; data want; set date; %do I = 1 to &count1.; count=N(of &&list&I.); max=Max(of &&list&I.); %end; %mend; %dlt;   Am i missing something or is there any other way to achieve the desired output? please help ... View more