About pritish069

pritish069 · ‎04-20-2019

I have updated the errors in the original post.

pritish069 · ‎04-20-2019

Data have; infile datalines dlm= " "; input ID :$20. Class :$2. Year Group Total; datalines; A001003 X 2012 5 10 A001003 X 2012 5 10 A001003 X 2012 5 10 A001002 X 2012 5 10 A001004 X 2012 5 10 A001005 X 2012 5 10 A001005 X 2012 5 10 A001004 X 2012 5 10 A001001 X 2012 5 10 A001001 X 2012 5 10 A002007 X 2013 4 8 A002005 X 2013 4 8 A002007 X 2013 4 8 A002003 X 2013 4 8 A002003 X 2013 4 8 A002001 X 2013 4 8 A002007 X 2013 4 8 A002001 X 2013 4 8 A002004 Y 2013 2 3 A002004 Y 2013 2 3 A002002 Y 2013 2 3 A002006 Z 2013 1 2 A002006 Z 2013 1 2 A003003 X 2014 3 5 A003003 X 2014 3 5 A003004 X 2014 3 5 A003001 X 2014 3 5 A003007 X 2014 3 5 A003002 Y 2014 3 7 A003008 Y 2014 3 7 A003005 Y 2014 3 7 A003008 Y 2014 3 7 A003005 Y 2014 3 7 A003005 Y 2014 3 7 A003002 Y 2014 3 7 A003006 Z 2014 1 1 A004004 X 2015 6 12 A004011 X 2015 6 12 A004002 X 2015 6 12 A004007 X 2015 6 12 A004001 X 2015 6 12 A004004 X 2015 6 12 A004011 X 2015 6 12 A004002 X 2015 6 12 A004009 X 2015 6 12 A004001 X 2015 6 12 A004007 X 2015 6 12 A004006 X 2015 6 12 A004010 Y 2015 3 5 A004010 Y 2015 3 5 A004008 Y 2015 3 5 A004008 Y 2015 3 5 A004003 Y 2015 3 5 A004005 Z 2015 1 3 A004005 Z 2015 1 3 A004005 Z 2015 1 3 ; run;

pritish069 · ‎04-20-2019

proc freq data= have; title "Summary"; table Class*year / nofreq norow nopercent out=freqtbl; run; PROC TABULATE data= have; title "Final"; keylabel max="#" n="#"; CLASS Year; Var Group total; TABLE (((Max*Group)*f=8.)(N*total)), Year; RUN; Proc Freq Output: Proc Tabulate Output:

pritish069 · ‎07-02-2018

data a; array b [1:2,2] (1,2); do i = 1 to 2; do j = 1 to 2; val = b[i,j]; output a; end; end; run; proc print data=a noobs; var i j val; run; I am getting this WARNING: Partial value initialization of the array b. Output: i j val 1 1 1 1 2 2 2 1 . 2 2 . Could some please explain what is the process behind this and why am i getting missing in last 2 obs

pritish069 · ‎02-20-2018

Thankyou!

pritish069 · ‎02-20-2018

I want the macro to sort and print where the profit is the given value

pritish069 · ‎02-20-2018

%macro con (p=); proc sort data=work.superstore; by descending profit; %if profit ge &p %then %do; title 'Profit'; proc print data=work.superstore; %end; %mend; run; %con (p=500); I want to print the data if the condition is met in the profit variable but the result i am getting is the entire table. Thank you in advance

pritish069 · ‎02-01-2018

Thank you for your advise but the result variable is still not giving output, i need the result variable to display 1 if the i1 is greater else display 0

pritish069 · ‎02-01-2018

I want to compare 2 rows. i have 2 variables i and i1, i1 increments by 1 in do while loop and if then statement compare i and i1 compares and should give results result variable as 1 for whichever row is greater but i am not getting the results displayed. Thank you in advance data t; infile datalines dlm="," dsd missover; input i; datalines; 2 3 4 5 ; run; data t1; set t; i1=1; do while (i le last.i); if i < i1 then put result = 1; else result = 0; end; i1 = i + 1; run;

Online Status	Offline
Date Last Visited	‎04-21-2019 12:16 PM

Re: Table format final output

Re: Table format final output

Table format final output

Multi Dimension Arrays

Re: Macro if then print

Re: Macro if then print

Macro if then print

Re: Compare 2 rows

Compare 2 rows

Re: Table format final output

Re: Table format final output

Re: Multi Dimension Arrays

Re: Compare 2 rows

Re: Table format final output

Re: Table format final output

Table format final output

Multi Dimension Arrays

Re: Macro if then print

Re: Macro if then print

Macro if then print

Re: Compare 2 rows

Compare 2 rows