cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
pallis
‎09-01-2015
  • 71 Posts
  • 5 Likes Given
  • 0 Solutions
  • 7 Likes Received

Re: Proc Report

by Fluorite | Level 6 in Administration and Deployment
‎09-20-2013 06:06 AM
‎09-20-2013 06:06 AM
https://communities.sas.com/communications Actually please go through the post which. I put the issue in wrong place. Sorry for that. ... View more

Re: Proc Report

by Fluorite | Level 6 in Administration and Deployment
‎09-20-2013 06:05 AM
‎09-20-2013 06:05 AM
Thank you M/S Durga for the reply. This is how I'm getting error ERROR: A GROUP variable appears above or below other report items.        Name                              Usage        --------------------------------  --------        MONTH                             COMPUTED        PAYMENT_STATUS                    GROUP ... View more

Re: Proc Import not successful

by Fluorite | Level 6 in SAS Procedures
‎09-20-2013 05:14 AM
‎09-20-2013 05:14 AM
Try this Data lib1.comp_new; Set lib1.comp; Inv_date=datepart(invoice_date); Format inv_date date9. ; Run; Proc print data=lib1.comp_new; Run; Regards, venky Note: If your issue is resolved please close . ... View more

Re: Proc Report

by Fluorite | Level 6 in Administration and Deployment
‎09-20-2013 01:57 AM
‎09-20-2013 01:57 AM
HI Durga, (month*variable name[which contain a b c values]) '*' works in proc tabulate. But it dont work in proc report. I mean here it's not working for me it's showing error. Regards, venky ... View more

Re: Proc Import not successful

by Fluorite | Level 6 in SAS Procedures
‎09-20-2013 01:44 AM
‎09-20-2013 01:44 AM
Hi sridhar,,   1) There is no difference both are same. There are two different ways to import file into SAS. If using file>import method u need to have some setup to install to import Excel files into sas. Where as if you are using IMPORT procedure there is no need for that because you are saying to tool that you what to import excel file. 2) You can fine the IMPORT and EXPORT in file menu. You can find in base sas(I'm using base sas ). As per my knowledge  if you are looking for GUI export one is as I mentioned above and other option you can do is if u want to data in excel file go the data set>right click > there u can find excel. Please go through below links it may help you. http://www.ats.ucla.edu/stat/sas/faq/rwxls8.htm http://rfd.uoregon.edu/files/rfd/StatisticalResources/dt06_import.txt SAS/ACCESS(R) 9.2 Interface to PC Files: Reference, Second Edition Can I know which sas version you are using. Regards, venky ... View more

3 cross result using proc report

by Fluorite | Level 6 in SAS Procedures
‎09-20-2013 01:11 AM
‎09-20-2013 01:11 AM
How Can I Achieve 3 Cross result in Report Procedure. Looking for output like this                      students Score subject       JUN13   JUL13  AUG 13       Total Score                    M F       M F            M F ------------------------------------------------------------------------------- Maths          x y       x y               x y                 z I have achieved                       students Score subject       JUN13   JUL13  AUG 13       Total Score -------------------------------------------------------------------------------- I couldn't figure out how to group again  student's score based on Gender. Can any one one give me hint. Regards, venky ... View more

Proc Report

by Fluorite | Level 6 in Administration and Deployment
‎09-19-2013 09:52 AM
‎09-19-2013 09:52 AM
Help need for Report Procedure. code  l       Jun13 |  jul 13 | aug 13   l          l   --------------|----------|------------- l          l     a|b |c    | a |b| c |  a b c     l total ---------|----------------- |----------|--------------|-------------- Im looking for output like this I have 3 columns I need to create this kind of layout accordingly. Any hints please                regards venky ... View more

Re: Proc Tabulate

by Fluorite | Level 6 in Administration and Deployment
‎09-19-2013 01:55 AM
‎09-19-2013 01:55 AM
I got output. I just want to update it may helpful for some who is looking for similar kind of solution. {code} PROC TABULATE DATA= Bncd_Emp   ; Class a  b; TABLE a, b*n=''/ misstext='0' ;   RUN; We can supress the n in output by placing n=''. As @ballardw said in case of missing text in output you can replace with 0 by using misstext='0' Regards, venky ... View more

Proc Tabulate

by Fluorite | Level 6 in Administration and Deployment
‎09-18-2013 11:37 AM
‎09-18-2013 11:37 AM
Hi, 1 )When I try to run the proc tabulate there is missing data in some of columns. Those columns are numeric which is populated by '.'.    I  need to replace '.' with 0. I tried missing in     PROC TABULATE DATA= Bncd_aug13_test  missing;     But It didn't worked for me 2) When I display output Im getting the 'N"        BOU     ‚    CLR     ‚    NCL     ‚           N      ‚     N      ‚     N. Is there any way to hide 'N'. regards, venky ... View more

Re: concatenation

by Fluorite | Level 6 in Administration and Deployment
‎09-18-2013 11:32 AM
‎09-18-2013 11:32 AM
Thank you for the help. I got the output as you suggested me. ... View more

concatenation

by Fluorite | Level 6 in Administration and Deployment
‎09-18-2013 10:06 AM
‎09-18-2013 10:06 AM
Hi, I'm having two data files of two months. One is july and august. Using proc sql I combines these two data sets select * from                  ( select depnto,                              comm                    from emp_aug13)                   union all                  ( select depnto,                              comm                    from emp_Jun13); I got  output deptno  Comm   10      1000   20      3000   30      1500   10       500   20       190   30       250 Loking for output ,       Aug          Jul deptno  Comm   deptno  Comm   10     1000           10       500   20     3000           20       190   30     1500           30       250 Can any one share me hints to achive this. regards, venky ... View more

Re: Data Reading Eror

by Fluorite | Level 6 in Administration and Deployment
‎09-18-2013 03:19 AM
‎09-18-2013 03:19 AM
Thanks for the work. Can you explain me the steps I unable to figure out. ... View more

Re: Data Reading Eror

by Fluorite | Level 6 in Administration and Deployment
‎09-17-2013 09:22 AM
‎09-17-2013 09:22 AM
Its one person with 3 names ... View more

Data Reading Eror

by Fluorite | Level 6 in Administration and Deployment
‎09-17-2013 09:05 AM
‎09-17-2013 09:05 AM
HI All, I have an issue when reading data This is my data file Name,sal,comm venkat srini,1000 ,300 srinivas,kiran,raju,3000,150 When I import into sas the data is reading as Name sal comm venkat srini 1000 300 srinivas kiran raju Can you let me know solution. My data is 28gb. can any one let me know solution for this issue. regards, venky ... View more

Re: Conversion sql to data step

by Fluorite | Level 6 in Administration and Deployment
‎09-13-2013 02:54 AM
‎09-13-2013 02:54 AM
Yes I'm an sql programmer and I was moved to sas recently. The task given by team is that. I could do things and get  results in sql  But they are rejecting and asking me to us in data step. I'm unable to figure out the thing how to do in sas . So I thought this is way I can learn and implement when it comes next time. Regards, venky. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
Likes from
View All
Quick links