11-27-2019
Vish33
Lapis Lazuli | Level 10
Member since
01-04-2012
- 148 Posts
- 31 Likes Given
- 7 Solutions
- 31 Likes Received
-
Latest posts by Vish33
Subject Views Posted 1181 11-27-2019 09:04 AM 1186 11-27-2019 08:57 AM 2330 11-14-2019 09:46 AM 1543 08-30-2019 10:08 AM 900 07-01-2019 10:27 AM 910 05-08-2019 10:06 AM 1345 05-14-2018 08:58 AM 1371 05-14-2018 05:23 AM 3598 05-09-2018 09:37 AM 1075 05-09-2018 07:55 AM -
Activity Feed for Vish33
- Got a Like for Re: Merging two datasets with alternating variables. 11-27-2019 12:37 PM
- Posted Re: Merging two datasets with alternating variables on SAS Programming. 11-27-2019 09:04 AM
- Posted Re: Merging two datasets with alternating variables on SAS Programming. 11-27-2019 08:57 AM
- Posted Re: appending .csv files onto a dataset daily on New SAS User. 11-14-2019 09:46 AM
- Liked Re: export dataset rows into multiples files .txt for Ksharp. 09-03-2019 09:05 AM
- Liked Re: Make macro variable for values of a variable for Tom. 09-03-2019 08:55 AM
- Posted Re: Make macro variable for values of a variable on SAS Programming. 08-30-2019 10:08 AM
- Posted Re: How to combine two proc sql table and then export them as ods html? on SAS Programming. 07-01-2019 10:27 AM
- Posted Re: proc report summarize on ODS and Base Reporting. 05-08-2019 10:06 AM
- Posted Re: Dynamic Parameters on SAS Enterprise Guide. 05-14-2018 08:58 AM
- Posted Re: Dynamic Parameters on SAS Enterprise Guide. 05-14-2018 05:23 AM
- Liked Re: SAS Output help for novinosrin. 05-10-2018 03:13 AM
- Liked Re: SAS Output help for ChrisNZ. 05-10-2018 03:13 AM
- Liked Re: How to add quarters in SAS? for sasstats. 05-09-2018 09:55 AM
- Posted Re: How to add quarters in SAS? on SAS Programming. 05-09-2018 09:37 AM
- Posted Re: Proc Means and output statement on SAS Enterprise Guide. 05-09-2018 07:55 AM
- Liked Re: Proc Means and output statement for RW9. 05-09-2018 06:22 AM
- Posted Re: Proc Means and output statement on SAS Enterprise Guide. 05-09-2018 06:17 AM
- Posted Re: An unexplained warning with a macro variable. on SAS Programming. 05-09-2018 05:41 AM
- Posted Re: Concatenate datasets as it get created on SAS Programming. 05-08-2018 05:48 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 11-27-2019 08:57 AM 1 05-07-2018 09:05 AM 1 05-04-2018 06:53 AM 1 05-04-2018 06:28 AM 1 05-03-2018 06:25 AM
08-17-2012
06:30 AM
Hi, I want to create 4 charts in a single row, then below that i need to display the data used . My requirement is to get in Excel as well in pdf. when i create using ods lay out and regions, i am getting in html report output but in the excel sheet the charts are not displayed only data is available. As well the pdf output is not matching with my requirement. I am getting all the charts in different pages. please look into the below code and suggest me if any changes. ods listing close; ods pdf file="/myfolder/&cmpy&yymm..pdf"; ods html file="/ myfolder /&cmpy&yymm..xls"; goptions reset=global gunit=pct border colors=(blue blue blue yellow) ctext=black cback=cxCCFFFF hsize=3in vsize=3in ftitle=zapfb ftext=swiss htitle=6 htext=4 device=gif transparency; Axis1 STYLE=2 WIDTH=2 MINOR= (NUMBER=2); Axis2 STYLE=5 WIDTH=5; ods layout start width=10in height=8in columns=4 rows=2 column_gutter=.5in row_gutter=.8in row_heights=(3.5in 3.5in); ods region row=1 column=1; PROC GCHART DATA=final1; VBAR3D MONTH/ descending SUMVAR=avg_speed_to_answer SHAPE=BLOCK FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=2; PROC GCHART DATA=final2; VBAR3D MONTH/ descending SUMVAR=avg_talk_time SHAPE=BLOCK FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=3; PROC GCHART DATA=final3; VBAR3D MONTH/ descending SUMVAR=answered_cnt SHAPE=BLOCK FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=1 column=4; PROC GCHART DATA=final4; VBAR3D MONTH/ descending SUMVAR=answered_cnt group=abondoned_cnt SHAPE=BLOCK FRAME TYPE=SUM LEGEND=LEGEND1 COUTLINE=BLACK RAXIS=AXIS1 MAXIS=AXIS2 PATTERNID=MIDPOINT width=15 inside=sum coutline=black cframe=white ; RUN; QUIT; ods region row=2 column=2; proc report data=all style(header)=[BACKGROUND =blue BORDERRIGHTCOLOR=blue BORDERTOPCOLOR=white foreground=white BORDERCOLOR=blue font = (Arial,10pt) font_weight = bold]; run; ods layout end; ods pdf close; ods _all_ close;
... View more
08-09-2012
07:09 AM
Thanks Cynthia...Its working...
... View more
08-08-2012
05:54 PM
Thank you Cynthia, Its working fine and one thing is that i need to get Desc1 , below that 2 spaces then type1 and so on(as shown in the 2nd table). And i need to get like 'New Desc' for this header in report. I am trying this in EG , the above codeis working fine but the lenght statement in compute before block is marked as red, can you suggest on this. Regards, Vish
... View more
08-08-2012
01:53 PM
Hi, I have a dataset like as below. Description type count Desc1 type1 3 Desc1 type2 4 Desc1 type3 5 Desc2 type1 6 Desc2 type2 7 Desc2 type3 8 I want to create a report using this dataset as below . new Desc count Desc1 type1 3 type2 4 type3 5 Desc2 type1 6 type2 7 type3 8 As shown above i need to get the two variables Description and type in a sigle column with spacings. It's not a cross tabulation report so i didn't use proc tabulate. I tried with Proc Report but i am getting as different variables. proc report data=have ; column description type count; define description /group "new Desc"; define type / display " "; define count / display; break after description/skip; compute after description; line " "; endcomp; run; The above code is giving as separate colums instead of what i want. Can any one suggest on this. Thanks, Vish
... View more
08-02-2012
08:21 AM
Hi ALL, I want to create coverpage with the titles and images with bar lines and colors included in it. Can u please look into the sample excel provided and suggest me ..using ODS
... View more
07-26-2012
07:51 AM
Hi, I want to create Excel pivot table from EG 4.2, which will consists of autofilters. I tried with ODS tagsets.tableeditor, but its not working in EG. Can anyone suggest on this. Thanks, Vishnu
... View more
06-15-2012
10:48 AM
Ok Doc..i leave EG as of now. My intention is to first schedule the job on the server side not from my local machine, so that if any problems from my loacl machine would'nt affect the scenario. So what would be your suggestions on this, can you tell me a process that i can look into.
... View more
06-15-2012
10:24 AM
Hi Doc, I am going to work with a remote machine and our requirement is not to shedule the jobs by using Windows scheduler . I want to schedule the jobs on server so that even i log off my pc it should work!! I want to automate the reports and schedule it accordingly. Any thoughts on what scheduler is better and the tool we are going to use is SAS EG as of now. So any suggestions from your side will be greately helpful for me. Thanks, Vish
... View more
06-13-2012
06:21 AM
Thanks Doc
... View more
06-12-2012
05:42 AM
Hi ALL, I want to know are there any schedulers which will be used to schedule a SAS job, that can be run in any platform. There are some schedulers for UNIX (Cron), WIndows, but my intention is to creating scheduled Sas job that will run in any OS with out any issues. Any suggestions pls. Thanks, -Vish
... View more
05-18-2012
02:46 PM
Thanks Doc, what should i do if i want to send the report by using sas code. My interest is to not to provide the links for the client and i need to send the report directly from my sas code. I have an idea how to send emails using sas code, but here my concern is about the file size, what should i do if the file exceeds the limits. Any suggestions Doc.. vish
... View more
05-18-2012
05:04 AM
Hi All, I want to know are there anyways to send the reports as an email which exceeds size limits. It should be delivered with out any interruptions. Any help would be appriciated. Thanks, vish
... View more
04-03-2012
11:49 AM
Thank you ALL for your replies.. ya..as you people doubted there is a relationship to SAS, when i use to create ECG(EG) datasets in clinical domain, i found this HRMEAN (which is herat rate mean value) and PRMEAN(which is pulse rate mean value) and some other values. when i googled it, i found that there is no such significant difference except when the blood circulation through arteries is not normal. the same question i faced in an interview 2 days before. Regards, vishnu
... View more
- « Previous
- Next »