About Ravikumarkummari

Ravikumarkummari · ‎05-13-2015

Good day all, I am facing the problem with importing excel file through macros. the excel name is DATAExport 2015-05-04-12-18-52 the file is coming every week monday. so i created macro for this. %LET TODAY1=%SYSFUNC(TODAY(),DATE9.); %LET LAST_WEEK=%SYSFUNC(INTNX(WEEK,"&TODAY1."D,-1,B),DATE9.); %LET LAST_WEEK_MONDAY=%SYSFUNC(INTNX(DAYS,"&LAST_WEEK."D,1),YYMMDDD10.); here I didn't create macro for time. The file contains time at the end. Up to DATAExport 2015-05-04 this i can automate using macro. proc import datafile="D:\emp\DATAExport &LAST_WEEK_MONDAY..xls" but what my requirement is what ever the time it is consider only Date. and ignore time. How to import this excel file. the time is changes from file to file. So i can't importing it successfully. Any help would be greatly appreciated.

Ravikumarkummari · ‎05-08-2015

Good day all, i have the dataset of Reports. In dataset like this. summary feb15 jan15 dec14 nov14 oct14 sep14 aug14 count of account value 203 300 450 500 600 650 700 sum of account value 150000 200000 30000 350000 150000 260000 450000 count of account value 500 400 300 200 150 250 350 sum of account value 10000 14000 15000 25000 30000 45000 50000 i have applied label for columns. Summary-Details feb-15 jan-15 dec-14 nov-14 oct-14 sep-14 aug-14 count of account value 203 300 450 500 600 650 700 sum of account value 150000 200000 30000 350000 150000 260000 450000 count of account value 500 400 300 200 150 250 350 sum of account value 10000 14000 15000 25000 30000 45000 50000 when i export into excel using ods html with .xls extension the report will appear but what happened is that when we place cursor on feb-15 cell its showing feb-15 2/15/2015 jan-15 1/5/2015 dec-14 12/14/2015 nov-14 11/14/2015 oct-14 10/14/2015 But i dont want like this at background. actually the date in the monyy5. format in dataset. So for appearance i changed it as feb-15 and jan-15 like this. what my requirement is i want to show these as labels and at background also showing like this. feb-15 2/15/2015 jan-15 1/15/2015 dec-14 12/15/2014 nov-14 11/15/2014 oct-14 10/15/2014. so i used proc report code like this. PROC REPORT DATA=REPORT NOWD LIST STYLE(HEADER)={BACKGROUND=STGB FOREGROUND=WHITE tagattr='format:m/d/yyyy'}; COLUMN SUMMARY FEB15 JAN15 DEC14 NOV14 OCT14 SEP14; RUN; Can anyone know how to get the required format. in dataset the variable are having (monyy5). and in labels are having (mon-yy). format. in excel file i want like mm/dd/yyyy format. Any help would be greatly appreciated.

Ravikumarkummari · ‎05-05-2015

good day all, i am used graph for proc sgplot procedure. i am getting the output but the what the problem was i dont want keylegend location in graph anywhere. its missing blank. i follow these code. PROC SGPLOT DATA=test; XAXIS VALUES=(0 to 100 BY 10) ; YAXIS VALUES=(0 to 100 BY 25); SERIES X=x Y=y / LINEATTRS=(THICKNESS=2) NAME="series1"; SCATTER X=x Y=y1 / MARKERATTRS=(symbol=squarefilled COLOR=orange size=12); keylegend "series1" RUN; QUIT; so how to remove the keylegend location in proc sgplot.

Ravikumarkummari · ‎05-04-2015

how to do the same process using proc sgplot. i tried some code using proc sgplot. data Class; set YEAR_2010; Label = Y; if Y NOT in (50,75) then Label = " "; run; proc sgplot data=CLASS; title 'Highlight a Value on a Graph'; series x=X y=Y; scatter x=X y=Y /DATALABEL=LABEL; run; here what happen i am getting the result but all points are displaying in graph. what my requirement is that i want to display only two points on graph. i.e. 50 and 75 on y-AXIS,

Ravikumarkummari · ‎05-02-2015

how to control the midpoints in proc gplot

Ravikumarkummari · ‎05-02-2015

please comment. what my requirement is that i want to display only two points on y axis. i.e. 50 and 75. along with total graph. i clearly mentioning here along with graph no need all points on graph. only 50 and 75 points appeared on graph. any help would be much appreciated.

Ravikumarkummari · ‎05-02-2015

Thanks for your valid comments. I solved it through Ods tagsets.msofffice2k_x template which i have downloaded from sas website.

Ravikumarkummari · ‎04-22-2015

Sorry i am having requirement for that. in sas only i have to combine all excel files into one excel file with multiple sheets. Thanks

Ravikumarkummari · ‎04-22-2015

Good day all, i have one folder in E drive DATA. in that having 10 excel files with different formats. now i want to combine all 10 excel files into one single excel file with different sheets. i solved this through Excel-VBA. But i want to know is it possible through sas. your valid comments are welcome.

Ravikumarkummari · ‎04-21-2015

I followed your procedure Cythia madam, the code is below. ODS TAGSETS.EXCELXP FILE="D:\OUTPUT.XLS" ; PROC REPORT DATA=WORK.EMP NOWD; DEFINE DEC14 / SUM FORMAT= FMT32. WIDTH=32 SPACING=2 RIGHT "DEC-14" ; COMPUTE DEC14; IF X IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) THEN DO; CALL DEFINE (_COL_,'STYLE', 'STYLE={TAGATTR="FORMAT:#,###,###"}'); END; IF X IN(21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40) THEN DO; CALL DEFINE (_COL_,'STYLE', 'STYLE={TAGATTR="FORMAT:###.0\%"}'); END; ENDCOMP; ODS TAGSETS,EXCELXP CLOSE; I CREATED X VARIABLE FOR ROWNUMBER IN DATASTEP. X=_N_; But in output result only percent format is applying and comma format is missing.

Ravikumarkummari · ‎04-20-2015

can you give me the syntax of call define for comma and percent format.

Ravikumarkummari · ‎04-20-2015

just now i checked the variable new is in character type. so it is not possible. the resultant dataset is also is in numeric format.

Ravikumarkummari · ‎04-20-2015

i have one doubt in this the variable "new" is which format character or numeric. is it belongs to numeric then not a problem. if it is character then there is a problem. client need this also into numeric format.

Ravikumarkummari · ‎04-20-2015

its showing like this after exporting through libname statement. the formats are missing.

Ravikumarkummari · ‎04-20-2015

413 45582372 242 27433526 203 23314259 0.85 0.839 156 47 4207109 0.114 0.092 0.194 0.153 0.232 0.18

Online Status	Offline
Date Last Visited	‎10-02-2018 10:21 AM

ods tagsets.excelxp user define range

Export multiple datasets into excel with different sheets

Re: Importing excel file problem of reading special characters

Importing excel file problem of reading special characters

Proc Report avoid single group wise frequency

Re: How to get the end of previous month in a macro variable using %sy...

Re: how to do merge

how to do merge

proc sql update statement with inner join

Re: how to import excel file by mentioning year in place of sheet name

Re: Roll Up Data

Re: ODS highlighting duplicate row columns

Re: excelXP tagsets with Graphs

how to import excel file when its having date at the end

how to apply the excel format for column headers

how to remove the keylegend location in proc sgplot

Re: what is the graphing procedure

Re: what is the graphing procedure

Re: what is the graphing procedure

Re: how to combine multiple excel files into one single file with diff...

Re: how to combine multiple excel files into one single file with diff...

how to combine multiple excel files into one single file with differen...

Re: how to apply the format when export data into excel format is miss...

Re: how to export multiple datasets into multiple worksheets in single...

Re: how to export multiple datasets into multiple worksheets in single...

Re: how to export multiple datasets into multiple worksheets in single...

Re: how to export multiple datasets into multiple worksheets in single...

Re: how to export multiple datasets into multiple worksheets in single...