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: 
RaviKommuri
‎09-01-2015
  • 45 Posts
  • 0 Likes Given
  • 0 Solutions
  • 21 Likes Received

Re: Sampling a dataset without replacement.

by Fluorite | Level 6 in SAS Procedures
‎10-30-2014 04:55 AM
‎10-30-2014 04:55 AM
Can you please give some example of output datasets? ... View more

Re: variable with time13.3 format to numeric format conversion

by Fluorite | Level 6 in ODS and Base Reporting
‎10-30-2014 04:49 AM
‎10-30-2014 04:49 AM
May be you can use a similar code like the code I have given below. MYTIME = INPUT(PUT(TIME1,BEST12.),$40.); ... View more

Re: transpose data by re-arranging data in columns (?)

by Fluorite | Level 6 in SAS Procedures
‎10-30-2014 03:42 AM
‎10-30-2014 03:42 AM
Another way......(may not be optimized code) DATA WANT(KEEP=ORG ITEM_NAME VALUE); SET HAVE; LENGTH ORG $16. ITEM_NAME $40. VALUE 3.; IF UPCASE(ITEM2) = 'ORGANISATION' THEN ORG = ITEM1; IF UPCASE(ITEM2) = 'LOCATION' THEN LOCATION = ITEM1; IF UPCASE(ITEM2) = 'TYPE' THEN TYPE = ITEM1; IF UPCASE(ITEM2) = 'ASSETS' OR UPCASE(ITEM2) = 'LIABILITIES' THEN MOD = ITEM2;  IF UPCASE(ITEM2) = 'ASSETS' OR UPCASE(ITEM2) = 'LIABILITIES' THEN VALUE = ITEM1; RETAIN ORG LOCATION TYPE; IF VALUE = . THEN DELETE; ITEM_NAME = LOCATION||TYPE||MOD; RUN; ... View more

Re: Across observation comparison, a data merge question

by Fluorite | Level 6 in SAS Programming
‎10-30-2014 02:26 AM
‎10-30-2014 02:26 AM
Hi, Where is the actual relation between Child and Parents -  in which dataset? ... View more

Re: How to Combine two variables?

by Fluorite | Level 6 in SAS Programming
‎10-30-2014 02:24 AM
1 Like
‎10-30-2014 02:24 AM
1 Like
You can also simply use this code for char variables...... DATA WANT(DROP=F1 F2); SET HAVE; IF B1 EQ ' ' AND F1 NE ' ' THEN B1 = F1; IF B2 EQ ' ' AND F2 NE ' ' THEN B2 = F2; RUN; ... View more

Need help in Finding a sub string which is in a particular format

by Fluorite | Level 6 in SAS Procedures
‎10-16-2014 02:05 AM
‎10-16-2014 02:05 AM
Hello, I have a character string  which contains the words with the combination of characters, numbers and special character. Now I would like to find/extract only the particular string which is in below mentioned format. Input string :  " 10% discount to be given to accidental insurance customers in 9874-04562 on a pro rata basis" Output Sub string  : 9874-04562 Thanks in advance. ... View more

Re: Need help in Do loop incremented by delimiter

by Fluorite | Level 6 in SAS Procedures
‎10-14-2014 09:27 AM
‎10-14-2014 09:27 AM
Thank you all.... 🙂 ... View more

Re: Need help in Do loop incremented by delimiter

by Fluorite | Level 6 in SAS Procedures
‎10-14-2014 07:52 AM
‎10-14-2014 07:52 AM
Can you please let me know how to write that if my delimiter is Hex Value ('41'x) instead of '*'        ? ... View more

Need help in Do loop incremented by delimiter

by Fluorite | Level 6 in SAS Procedures
‎10-14-2014 07:16 AM
‎10-14-2014 07:16 AM
Hello, I have a delimited raw data file . Now I want to create a SAS dataset using the raw data file using Do loop as there are variable number of records and variable length fileds. How to increment it in Do loop. Input : A   1*2*3*4*5 B   5*6*7 C   1*45*78*54 Desired Output: A     1 A     2 A     3 A     4 A     5 B     5 B     6 B     7 C     1 C     45 C     78 C     54 I am not getting how to increment the DO loop with delimiter value..... Thanks.... ... View more

Re: Replicate rows based on weight

by Fluorite | Level 6 in SAS Programming
‎10-07-2014 10:03 AM
‎10-07-2014 10:03 AM
You can use this..... data have;                        Input contid $ membship metric $; datalines;                        H4510 2 90                        H0028 5 80                        H2309 2 95                        ;                                 data want(drop=i);                set have;                         do i=1 to membship;               output;                           end;                              run;                              ... View more

Re: Problem to convert character to numeric

by Fluorite | Level 6 in SAS Programming
‎09-24-2014 10:03 AM
‎09-24-2014 10:03 AM
data have;                        Input val $10.;                   datalines;                        119 M€                            634 M€                           14866 M€                          ;                                 DATA WANT;                        SET HAVE;                        REMOVE_CHAR = COMPRESS(VAL,'MA'); NUMONLY = INPUT(REMOVE_CHAR,5.); I have used same COMPRESS and INPUT functions, but I didn't get any error ... View more

Re: Vertical addition

by Fluorite | Level 6 in SAS Procedures
‎09-19-2014 03:14 AM
‎09-19-2014 03:14 AM
I guess, you don't need to use nodupkey while printing the data base1. You Proc sql is giving the result without any duplicates. ... View more

Re: How to use first.variable to get the following output?

by Fluorite | Level 6 in SAS Data Management
‎09-10-2014 04:59 AM
‎09-10-2014 04:59 AM
The SET statement reads the current observation from the dataset. The OUTPUT statement tells SAS to write the current observation to a SAS data set immediately, not at the end of the DATA step. ... View more

Re: SAS Certifications

by Fluorite | Level 6 in SAS Procedures
‎09-02-2014 10:21 AM
‎09-02-2014 10:21 AM
Hi juliennel, I would like to give my Base SAS certification exam. Could you please guide me. What are the books you have followed and any dumps or any practice test? Please help me... Thank you in advance. ... View more

Re: find carriage return in dataset

by Fluorite | Level 6 in SAS Programming
‎08-28-2014 03:14 AM
‎08-28-2014 03:14 AM
You can try use this code...... data have;                                       infile datalines missover;                       input @1 group @3 label $ @12 var_status $ 12-26; datalines;                                       1 1        from 10@20                            1 2        from 20@30                            1 3        from 30@40                            1 4        from 40@50                            1 5         from 50                              1 @60                                            2 1        from 10k to 20k                       2 2        from 20k to 30k                       2 3        from 30k                              2 to 40k                                         2 4        from 40k to 50k                       ;                                                                                                 data want(drop= fromvar atvar tovar);            set have;                                       fromvar = find(var_status,'from');              atvar = find(var_status,'@');                   tovar = find(var_status,'to');                                                                   if group = 1 then                                   if fromvar = 0 or atvar = 0;                 if group = 2 then                                   if fromvar = 0 or tovar = 0;                                                                  proc print data=want;run;                        ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Likes from
Quick links