I am trying to compare two datasets data1 and data2. I have the column name in both "var" and would like to check if there any differences in those two columns in the two datasets and then count the number of differences I then would like to call this macro function and save the count to macro variable x Somehow this doesnt work any help is appreciated. Thanks!ee %macro CompareUniqueCols(data1, data2, var);   %* check if all the unique values  in a column var of data set 1 and data set 2 are same and outputs the number of differences;    proc sql; create table temp1 as select distinct &var  from &data1 order by &var; run; proc sql; create table temp2 as select distinct &var from &data2 order by &var; run; proc compare base = temp2 compare = temp1 outall outnoequal out = outcompare ; run; proc sql noprint; select count(*) into: noCompareObs from outcompare ; run; &noCompareObs; %mend; %let x = %CompareUniqueCols(data1, data2, var); ... View more

Hello, I have a dataset which looks like the below gcode  seccode  WT1  WT2      REG        SSEC   AU      ENGY    10      20    APAC    RES   CA      HCARE    15    25    NA        NCYC   HK      IND          3    10      APAC    NCYC I am using sgpanel to plot the values for T1 and T2 by gcode and seccode gcode is the columns and seccode is the rows. The issues I am facing 1) I dont see all the available tick values for the columns; also the y axis does not show 0% but ** for some reason 2) How do I increase the size of the x axis and y axis values and the title 3) How do I show my sgpanel chart sorted according to SSEC for the rows and the REG for the columns as given above..   So in this example the panel on the columns will be sorted  CA HK AU and the rows will be sorted as HCARE, IND and ENGY 4) This would be good to have if I can color the titles of each panel "AU", "CA" by the REG specified 5) Any other suggestions to improve the visual.. I have attached an example of what I have so far . Many Thanks for your help! l ods graphics on/width = 20in height = 10in border = off; %let myYvalues = ("ENGY", "BMAT", "IND", "CDISC", "CSTPL", "HCARE", "FIN", "TECH", "TEL", "UTIL"); proc sgpanel data=mygroup;   format WT1 percent4.1;   format WT2 percent4.1;   title "RANDOM";   panelby gcode / novarname spacing = 0 columns=6 rows = 4;   rowaxis label = "CODE"  ;   scatter x = WT1 y = seccode /markerattrs = (symbol = circlefilled color = cadetblue  size = 15 ) legendlabel = 'T1';   scatter x = WT2 y =seccode/ markerattrs = (symbol = circlefilled color = darkgoldenrod size = 15 ) legendlabel = 'T2'; run Attached is some data as well..Thanks! ... View more

Hi , I have a dataset as the following date  numberofclusters variable  data I would like to compute the xthe percentile using the data column but partitioned by date and numberofclusters. I could do it using two for loops but I was wondering if there is a more elegant way to do this.. Thanks very much! ... View more

Hello, I have a set of datasets which I would like to output in an Excel File. Is there a way to do this quickly rather than calling proc export each time for each dataset %let MyDS = ('out.Ids', 'out.Vars', 'out.Places') %let MyDSname = (Ids, Vars, Places) I would like to create a macro that check if each dataset exists and then output to an Excel spreadsheet with the Tab name as specified in the corresponding MyDSname ... Something like... %macro Out(MySpreadsheetName, MyDS, MyDSname); Thanks very much for your help ... View more

Hello all, I have another (maybe simple) question. I have the following macro %macro mytest(dataset,  dataset1, myfldget, myfldon); proc sql; create table &dataset as select a.*, b.&myfldget from &dataset a left join &dataset1 b on a.&myfldon = b.&myfldon; run; %mend; %mytest(myfinal, myfinal, age, date); I was wondering is there a way I can pass a set of columns to myfldget like age, sales, etc rather than calling this macro again substituing age with sales? THanks very much for your help ... View more