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: 
BharathBandi
‎07-25-2016
  • 34 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Spliting a string into variable

by Calcite | Level 5 in SAS Procedures
‎04-15-2015 05:32 PM
‎04-15-2015 05:32 PM
Thank You Arthur, your code worked fine. But I just realized that when string has no number after comma it is not giving value example : 35,NB15O4L4NB7O Desired Output: var1     Var2     var3     var4     var5      var6      var7     var8     var9     var10     var11     var12     var13     var14     var15     var16 35      ,               1      N          1          B          15          O         4          L          4         N        1             B               7            O Thank you ... View more

Re: Spliting a string into variable

by Calcite | Level 5 in SAS Procedures
‎04-15-2015 02:11 AM
‎04-15-2015 02:11 AM
Thank you your code worked correct for me, but if there is no number in-front of character then I need 1. example:After O theres no number, so in this case I need 1 then B. For the first string : 28,16OB4N7L8U4L output: var1     Var2     var3     var4     var5      var6      var7     var8     var9     var10     var11     var12     var13     var14 28      ,               16      O        1          B          4          N          7          L          8          U          4              L Hope I'm clear. Thank you ... View more

Spliting a string into variable

by Calcite | Level 5 in SAS Procedures
‎04-14-2015 11:12 PM
‎04-14-2015 11:12 PM
Hi ,      I want to split the below string in to different variables and when there are two consecutive characters then I want to insert 1. I tried putting characters and numbers in different variables but that's not giving what I want. Please help me           String 28,16OB4N7L8U4L 28,12O8B20O 46,12C 30,14CB12C4N2C Output: var1     Var2     var3     var4     var5      var6      var7     var8     var9     var10     var11     var12     var13     var14 28      ,               16      O          1          B          4          N          7          L          8          U          4              L 28     ,               12       O          8          B          20        O 46     ,               12       C 30     ,               14       C          1          B          12        C          4           N         2          C Thank You ... View more

Re: Using Proc Compare to compare datasets and adding Update date

by Calcite | Level 5 in SAS Procedures
‎03-23-2015 06:51 PM
‎03-23-2015 06:51 PM
Sorry slight change in desired output: desired output: ID  Name$     EFFECTIVE DATE FROM     EFFECTIVE DATE TO UPDATE DATE 1     A                   23/03/2015                              NULL                   23/03/2015 2     B                   23/03/2015                              NULL                   23/03/2015 3     C                   23/03/2015                            24/03/2015              24/03/2015 3     F                   24/03/2015                              NULL                   24/03/2015 4    D                    23/03/2015                              NULL                 23/03/2015 5    E                    24/03/2015                              NULL                  24/03/2015 ... View more

Re: Using Proc Compare to compare datasets and adding Update date

by Calcite | Level 5 in SAS Procedures
‎03-23-2015 06:38 PM
‎03-23-2015 06:38 PM
Hi All, I'm running a batch process where I have to compare the old dataset with new dataset . I'm using proc compare to get the modified or newly added records from new to old but I want an update date in my dataset when ever there is any change in records. eg: data old;                                             data new;     input ID Name$;                                  input ID Name$;    cards;                                                    cards; 1 A                                                       1 A 2 B                                                       2 B  3 C                                                       3 F 4 D                                                       4 D ; RUN;                                                  5 E;                                                            run; desired result: ID  Name$     EFFECTIVE DATE FROM     EFFECTIVE DATE TO UPDATE DATE 1     A                   23/03/2015                              NULL                    NULL 2     B                   23/03/2015                              NULL                    NULL 3     F                   23/03/2015                              NULL                    24/03/2015 4    D                    23/03/2015                              NULL                    NULL 5    E                    24/03/2015                              NULL                    NULL Thank you ... View more

Re: ERROR: Invalid or non-supported file specified.

by Calcite | Level 5 in SAS Programming
‎03-08-2015 04:04 PM
‎03-08-2015 04:04 PM
Yes I have tried both methods. The only way I can read those files is through OLE DB connection but the problem here is visual fox pro has only 32 bit driver while i'm using  64 bit SAS. ... View more

Re: ERROR: Invalid or non-supported file specified.

by Calcite | Level 5 in SAS Programming
‎03-05-2015 05:01 PM
‎03-05-2015 05:01 PM
Thank you Kurt. I got Visual FoxPro 32 bit Download Microsoft OLE DB Provider for Visual FoxPro 9.0 from Official Microsoft Download Center   when I'm trying to connect through SAS OLE DB connection it is not showing in the provider list. How to access a 32 bit in a 64 bit sas?? ... View more

ERROR: Invalid or non-supported file specified.

by Calcite | Level 5 in SAS Programming
‎03-04-2015 11:13 PM
‎03-04-2015 11:13 PM
50   PROC IMPORT OUT=Payroll_45439223 51               DATAFILE="C:\SAS Payroll\45439223.dbf" 52               DBMS=DBF REPLACE; 53      DBENCODING=pcoem850; 54   RUN; NOTE: Imported 103 columns and 2 rows of data from the dBase table file. NOTE: WORK.PAYROLL_45439223 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.09 seconds       cpu time            0.00 seconds 55   PROC IMPORT OUT=Payroll_Paytrans 56               DATAFILE="C:\SAS Payroll\Paytrans.dbf" 57               DBMS=DBF REPLACE; 58      DBENCODING=pcoem850; 59   RUN; ERROR: Invalid or non-supported file specified. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time):       real time           0.00 seconds       cpu time            0.00 seconds I'm trying to read dbase files using above code but some of them are giving error. Can anyone help me to solve this. Thanks in advance. ... View more

Re: first. and last.

by Calcite | Level 5 in SAS Programming
‎03-04-2015 09:39 PM
‎03-04-2015 09:39 PM
proc sort data=have out=want;      by address; run; data want;      set want; if first.address=last.address then delete; run; you can also write a proc sort with nodupkey with name in the by statement if you have same name and same address.  ... View more

Re: calculating average while using if then else clause

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 09:11 PM
‎02-24-2015 09:11 PM
No, that wont work . For example lets say I have population of 100,000 and when applied rule1 it eliminates about 25,000,   Now I need to calculate average of 75,000 and apply rule2 on the selected ones (remaining 75,000)  if it eliminates about 10,000 then I need to calculate average of remaining 65,000 and so on. In your case it will calculate average for the ones which are eliminated.   ... View more

Re: Reading a data file using SAS ODBC

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 08:57 PM
‎02-24-2015 08:57 PM
Thank you all . We need to buy Btrieve odbc drivers, it solves the problem. ... View more

Re: calculating average while using if then else clause

by Calcite | Level 5 in SAS Procedures
‎02-24-2015 08:53 PM
‎02-24-2015 08:53 PM
data abc;      set xyz;           if abc<9000 then rule1=1;           else if xu=1 then rule2=1;           else if age <18 then rule3=1;           else if age >65 then rule4=1;           else selected =1; run; now i need to calculate Average of the Score. For example: Data rule1;      Set   abc;           if  rule1=1 then delete;      run; proc means data=rule1 mean maxdec=2;      var score; run; data rule2;      set rule1;          if rule2=1 then delete; run; proc means data=rule2 mean maxdec=2;      var score; run; Since I have 35 rules, I want to know alternative way to calculate the average of only selected observation of that particular rule. Thank you. ... View more

Re: calculating average while using if then else clause

by Calcite | Level 5 in SAS Procedures
‎02-23-2015 05:15 PM
‎02-23-2015 05:15 PM
Sorry my mistake this is how my proc means look like: proc means data=exclusion_selected mean;   Class rule1 rule2 selected/missing;   types rule1 rule2 selected;   var score; run; ... View more

Re: Reading a data file using SAS ODBC

by Calcite | Level 5 in SAS Procedures
‎02-23-2015 03:44 PM
‎02-23-2015 03:44 PM
Yes it is default extension and these files are extracted from pervasive db. ... View more

Re: Reading a data file using SAS ODBC

by Calcite | Level 5 in SAS Procedures
‎02-23-2015 03:39 PM
‎02-23-2015 03:39 PM
Files are quite small something around 100 KB. These files are extracted from Pervasive DB which has a default extension .Dat. which cannot be opened in text editor. The only way I can read this file is through ODBC connection. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-25-2016 07:54 PM
Likes given to
View All
Quick links