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: 
kuridisanjeev
‎11-10-2023
  • 279 Posts
  • 17 Likes Given
  • 0 Solutions
  • 83 Likes Received

Re: What is the usage of ENDSAS statement?

by Quartz | Level 8 in Statistical Procedures
‎09-05-2012 06:08 AM
‎09-05-2012 06:08 AM
Hi... The ENDSAS statement immediately terminates the SAS job or session. An interactive program that writes output to the OUTPUT window should not use this statement because the contents of the OUTPUT window (as well as the LOG & Program Editor windows) will be lost. However when output is directed to files (as in a batch program or when using PROC PRINTTO) or when just data sets are being created, the ENDSAS statement can be used to control job or session termination. The entire job is terminated in the following data step if the variable X is ever less than or equal to zero. data new; set old; lnx=log(x); if _error_ then endsas; run; The ENDSAS statement can also be used between steps when execution of only a portion of a program is desired. …some SAS statements… run; endsas; …unexecuted SAS statements… Source:https://docs.google.com/viewer?url=http%3A%2F%2Fwww2.sas.com%2Fproceedings%2Fsugi26%2Fp074-26.pdf Regards.. Sanjeev.K ... View more

Re: What is the usage of ENDSAS statement?

by Quartz | Level 8 in Statistical Procedures
‎09-05-2012 06:02 AM
‎09-05-2012 06:02 AM
Hi.. Please Go through this link..It may be use full to you... http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000289392.htm Regards.. Sanjeev.K ... View more

Required SAS EG.

by Quartz | Level 8 in SAS Enterprise Guide
‎08-28-2012 05:07 AM
‎08-28-2012 05:07 AM
Hi All.. Can SAS provides Free SAS EG software for learners?? If Yes Could you please advise me how to get SAS EG software with Free of cost and what are the system requirements for SAS EG.(I am Using windows7).. Thanks in advance.. Regards.. Sanjeev.K ... View more

Re: propcase

by Quartz | Level 8 in SAS Programming
‎08-24-2012 09:12 AM
‎08-24-2012 09:12 AM
Hi Art.. Great logic..it is working perfectly. I want to know one more logic(Actually it is not my requirement but i am curious to get the logic)... If i want to display "DEVELOPING" word as "DeVeLoPiNg" ..how can we change the above logic.. (Please Don't mind if i am  asking useless question:-)).. Regards.. sanjeev.K ... View more

Problem With Proc Report

by Quartz | Level 8 in SAS Procedures
‎08-24-2012 07:32 AM
‎08-24-2012 07:32 AM
Hi All.. I having small prob with Compute block in proc report.. here is the my sample code. proc report data=sasuser.admit; column age fee height; define age/display; define fee/"Max Fee"; define Height/"Max Height"; rbreak after/summarize dul dol; compute after; if _BREAK_= "_RBREAK_"  then age="Total"; endcomp; run; here i am trying to get the total value for  Fee and height variables and i want to display "Total" text in the bottom of the Age variable. but the problem is age is a a numeric variable,so i can not insert the text in  that variable.. anybody have any suggestion  for this??? Thanks in Advance.. Regards.. Sanjeev.K ... View more

Re: What is the equivalent Proc SQL code?

by Quartz | Level 8 in SAS Data Science
‎08-22-2012 06:01 AM
‎08-22-2012 06:01 AM
Hmm Good.. Just Make my answer as a Correct Answer..That would be Great for me..:-) Regards. Sanjeev.K ... View more

Re: What is the equivalent Proc SQL code?

by Quartz | Level 8 in SAS Data Science
‎08-22-2012 05:59 AM
‎08-22-2012 05:59 AM
Hi.. But You put the condition as IF b=0, which means you are taking ID's those are  present in ONE but Not in TWO. Just run your data step and SQL query which i have provided....You will get same result... Regards.. Sanjeev.K ... View more

Re: What is the equivalent Proc SQL code?

by Quartz | Level 8 in SAS Data Science
‎08-22-2012 05:40 AM
1 Like
‎08-22-2012 05:40 AM
1 Like
Hi Devarayalu.. bellow code is alternative for the above data step.. Proc SQL ;   Create Table AntiJoin As    Select *     From One a          Left Join          Two b          On a.id =b.id      Where Missing( b.id ) ;   Quit ; Regards.. Sanjeev.K ... View more

Re: Reading all values of some columns and put them in a macrovariable

by Quartz | Level 8 in SAS Programming
‎08-21-2012 09:03 AM
‎08-21-2012 09:03 AM
Hi data_null_.. It is working fine  with trim function.. Can you please explain why is is not working without trim function??? Regards.. Sanjeev.K ... View more

Re: Reading all values of some columns and put them in a macrovariable

by Quartz | Level 8 in SAS Programming
‎08-21-2012 07:15 AM
‎08-21-2012 07:15 AM
Hi Garag.. Lets try with this code....(Not tested)... %let bodymsgstring = ''; data outds;     length tmpbodymsgstring $10000;     set WORK.inputds end=EOF;       retain tmpbodymsgstring '';        tmpbodymsgstring_1 = tmpbodymsgstring || col1 || trim(left(col2)) || "\n";        if EOF then do;           call symput('bodymsgstring', tmpbodymsgstring_1);        end;     drop tmpbodymsgstring;     rename tmpbodymsgstring_1=tmpbodymsgstring; run; %put bodymsgstring= &bodymsgstring; Regards.. Sanjeev.K ... View more

Re: Problem With Format.

by Quartz | Level 8 in SAS Programming
‎08-17-2012 06:44 AM
‎08-17-2012 06:44 AM
Oh thanks Tom.. Is there any way to display month names instead of number in my above example(Except PROC FORMAT)??? Thanks.. Sanjeev.K ... View more

Problem With Format.

by Quartz | Level 8 in SAS Programming
‎08-17-2012 06:17 AM
‎08-17-2012 06:17 AM
Hi.. I am trying to use Monname3. format in my program but it is not working properly. Here i am giving small example.. data test; format month monname3.; input month amount; cards; 9 1500 2 8200 3 3256 4 7412 5 2125 6 2536 ; run; If i run this code i am getting output like this..                                      Obs    month    amount                                         1      Jan      1500                                         2      Jan      8200                                         3      Jan      3256                                         4      Jan      7412                                         5      Jan      2125                                         6      Jan      2536 It is showing every month as Jan... any one could you please help me in that... Regards.. Sanjeev.K ... View more

Re: How to select last n rows of input records using SQL?

by Quartz | Level 8 in SAS Procedures
‎08-13-2012 07:52 AM
‎08-13-2012 07:52 AM
Hi Hai.Ku.. Hmm yes i do agree with you on this.Actually i am  thinking about the simplifying  code and not considering about huge data.. Thank you for correcting me ..and one more clarification i need on  PG's code.. Is there any reason for using MAX function??Instead  of MAX function we can simply use like  select (nobs-4) into :firstobs right??? Regards.. Sanjeev.K ... View more

Re: how to reading in num value with more than 16 digits!

by Quartz | Level 8 in SAS Procedures
‎08-13-2012 07:15 AM
‎08-13-2012 07:15 AM
By using Formats   you can able to display numeric variables which length is more then 16. Ex.. data dsn; a=12345678910122341258; format a best20.; run; proc print; run; Regards.. Sanjeev.K ... View more

Re: How to select last n rows of input records using SQL?

by Quartz | Level 8 in SAS Procedures
‎08-13-2012 06:32 AM
‎08-13-2012 06:32 AM
Little bit confusing but great skills..liked it... Regards.. Sanjeev.K ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎11-10-2023 08:27 AM
Likes given to
Quick links