I wanted to create table numeric which can store 22 digits and with decimals. I need to create a table in proc sql only and run insert query to enter the data. Eg=123456789987654321.999   this is the numeric value.   ... View more

1)How can I use User defined format which i have defined in the precode  but still not available in format drop-down in mapping tab.So how can i use this user defined format .. plzz help   2)How to drop/rename a column from a target table. I dont want to drop in mapping coz i am using it. I want to drop after if have used its value in some other column.. like we use in data step rename/drop but i want in SAS di.    plz help....       ... View more

I wanted to remove the last value taken during and the year end.   ods escapechar="^"; proc report data=sashelp.shoes spanrows split='#' out=abcd style(header)=[foreground=BLACK background=ORANGE font_size=10pt font_weight=bold vjust=bottom] style(report)=[cellspacing=2 cellpadding=10 borderwidth=1 bordercolor=black outputwidth=100% font_face=calibri font_weight=bold frame=box ]; title 'A2) Default Report Only Numeric Variables'; title2 'With COMPUTE block for new report items'; column region product sales returns inventory Profit pctinv ; define region/display "REG" group style(column)=[vjust=center just=CENTER font_size=15pt cellwidth=0in backgroundcolor=yellow font_weight=bold] ; define product /display format=$50. "PRO" group ; define profit / computed f=dollar14.2 style(header)=[just=center background=blue] style(column)=[just=center font_size=10pt]; define pctinv /computed display "%" computed f=percent9.2 style(header)=[just=center background=blue] style(column)=[just=center font_size=10pt]; compute pctinv; profit = sum(sales.sum,-1*returns.sum); pctinv = sales.sum/ inventory.sum; endcomp; Compute Region; If Region='Central America/Caribbean' and _BREAK_ ="Region" then Region='USA'; line region $varying100.; brktxt = ' '; text1='^{style[textdecoration=underline just=CENTER]Values taken during } '; text2='the Year End.'; if region = 'Canada' then do; reglg = 0; reglg2 = 0; reglg3 = 0; end; else do; reglg = 1; reglg2 = 20; reglg3 = 20; end; endcomp; break after region/summarize style={font_weight=bold font_size=10pt background=pink just=CENTER };   compute after region/ style={background=white}; line brktxt $varying. reglg; line text1 $varying. reglg2; ; line text2 $varying. reglg3;; endcomp; /* compute after region /style={ background=white}; */ /* line ' '; */ /* line @20 '^{style[textdecoration=underline just=CENTER]Values taken during } ' ; */ /* line @20 'the Year End.'; */ /* endcomp; */ rbreak after /summarize skip ul ol style={font_weight=bold font_size=10pt background=pink just=center}; /* line '^{style[foreground=white]Values taken during } ' */ Compute after/style={background=white just=CENTER }; Product="GRAND TOTAL of countries " ; /*HOW TO PUT THE TOTAL TEXT AND MAKE BOLD*/ REgion="GRAND"; line @50 "THIS IS FROM ALL OVER THE WORLD"; Endcomp; Footnote 'This is a system generated mail please dont respond to this '; run;     THE ERROR I AM GETTING   ... View more

%macro obs_count(input=); %global dsid rc cnt;  %let rc=%sysfunc(filename(data,&input));   %if &rc.=0 %then %put success; */ %let did = %sysfunc(fopen(&data));   %if &did.>0 %then %put can open;            */MY EXTERNAL FILE CAN BE OPENED*/ %if &did %then %do; %let cnt=%sysfunc(attrn(&did, NVARS));   /*THIS GIVES FOR A DATASE I WANT FOR AN EXTERNAL EXCEL FILE*/ /*%put &cnt.; %end;*/ /* %let rc=fdelete('testdir'); */ %let rc = %sysfunc(close(&did)); %mend; %obs_count(input=/home/u60099960/sasuser.v94/sashelp.xlsx) ... View more