%macro ab(x); proc print data=test1 ;where rating in(&x);run; %mend; %ab(2,3,4)   here i'm getting error that more positional parameters found but if i write proc print data=test1 ;where rating in(2,3,4);run; i'm getting the desired output.   &x also doing the same then y error is cmng? I think after resolving macro variable to (2,3,4) it should work like a normal sas program. . Please explain how the macro processor is processing these values.     ... View more

i have aa data set  data t; name   rating  post; cards; a   2   ASE b   3   ASE c  4    ITA d  5   ITA e  2  VP f   7  Vp ;run;   want to knw the rating of each person out of whole rating and performed the following query proc sql; select first_name,(calculated rating/r) from pawan.test,(select sum(rating) as r from pawan.test1); quit;   getting error  ERROR: It appears that the CALCULATED variable rating was referenced before it was defined. ERROR: The following columns were not found in the contributing tables: post. ERROR: The following columns were not found as CALCULATED references in the immediate query: rating. ... View more

have to dipslay the datasets starting with name P   proc sql; select distinct memname into : ab separated by ',' from dictionary.columns where libname='work' and upcase(memname) like"P%"; %let r=&sqlobs; quit;   %put &ab &r; (P1,PATIENT,PAWAN,PAWAN1,PP,PULMICORT_PA,PULMICORT_PH 7)       %macro b(libname); %do i= 1 %to &r; proc print data=&libname..%scan(&ab,&i); run; %end; %mend; %b(work); getting error  - ERROR: Macro function %SCAN has too many arguments. The excess arguments will be ignored. ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand is required. The condition was: PATIENT ERROR: Argument 2 to macro function %SCAN is not a number ... View more

%macro print(libname,dslist=a b c); %do i=1 %to 4; proc print data=&libname..%scan(&dslist,&i); run; %end; %mend; %print(pawan,dslist=test p1 test1 test2);   here if i place quotes in (dslist="test p1 test1 test2") it's not working..........in which scenerio have to place quotes and not.   %macro print1(libname,dslist="pawan test test1"); %do i=1 %to 4; data _null_; call symput('a',scan(&dslist,&i)); run; proc print data=&libname..&a; run; %end; %mend; here it is not working without quotes? ... View more

%let a=2 here a is a macro variable and is character and if i write ths proc print data=data; where rating=&a; run; then records with rating=2 is coming.How ths character is getting resolved as numeric over here? ... View more

I'm passing a date and it will b a character only,can't i store it in any variable or macro variable like %let or as i'm doingin code.And how can i change this date into numeric and store in a variable so that i can find no of weekdays between these two dates. %macro ab(strt,end); a=&strt; b=&end; %put a= b=; %mend;   %ab(01jan2015,31jan2015);   ... View more

I have a date set shown below   data new; input location$ &20. date:mmddyy. rev1:dollar. rev2:dollar. rev3:dollar. costs:dollar.; format date date9.; cards; Boston 12/15/2006 $500 $150 $300 -$200 Boston 12/22/2006 $300 $500 $200 -$200 Boston 12/29/2006 $100 $200 $50 -$200 Boston 1/6/2007 $100 $100 $150 -$200 New York 12/15/2006 . $600 $400 -$400 New York 12/22/2006 $700 $600 $250 -$400 New York 12/29/2006 $200 $300 $100 -$400 New York 1/6/2007 $50 $100 $50 -$400 ;run;   need to find -How much profit did each branch earn during the holiday period, in dollars and as a percent of total profits?   And got one solution -select location, sum(sum(rev1,rev2,rev3,costs)) as branch_profit, total_profit from financials, (select sum(sum(rev1,rev2,rev3,costs)) as total_profit from financials where location ne ' ') where location ne ' ' group by location; quit;   can someone explain how this query is working and why "total_profit" is there in the main query?   ... View more