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

Update missing values from with in Table

by Calcite | Level 5 in SAS Programming
‎05-22-2013 04:21 AM
‎05-22-2013 04:21 AM
Hi I have to update missing values in a in both coulmns using value of adjacent coulmn as refernce for search. refer to below example Coulmn 1 Coulmn 2 A 1 1 A B 2 2 B As in ROW1 values are available for both coulmn, i want to update missing values in ROW2 & ROW3 , please guide How ? ... View more

Re: CSV File Import :

by Calcite | Level 5 in SAS Programming
‎05-22-2013 04:02 AM
‎05-22-2013 04:02 AM
DanWaldo ! your approch and code was awsome and i had sucefully implemented it with some customization ... View more

Re: CSV File Import :

by Calcite | Level 5 in SAS Programming
‎05-10-2013 01:53 AM
‎05-10-2013 01:53 AM
Thanks a lot !  data_null_ and cwilson. it really work well. ... View more

Re: CSV File Import :

by Calcite | Level 5 in SAS Programming
‎05-10-2013 12:53 AM
‎05-10-2013 12:53 AM
I recive this data from extrenal source frequently and used to work on it, the external source often forget the quantifiers(" "), so to get the correct file waste time which is critical. i-e, i want to handle this exception at my end rather wasting time oftenly to get correct data. help is required to write a procedure/data step to address this issue when it occurs. Regards Ali J ... View more

Re: CSV File Import :

by Calcite | Level 5 in SAS Programming
‎05-09-2013 09:43 AM
‎05-09-2013 09:43 AM
Dear All, Thanks for your replys. Probably I did not explain the problem correctly. Please find attached sample data "SAMPL.csv" There are coulmns from A to W , when I import data it create coulmns by commas but in coulmn 'N' there are multiple values(>=2, not fixed) also seprated by  comma . SAS also read these values as different coulmns and shifts the value of adjacent coulmn. due to this extra coulmns cretae automatically and inapproprite data is filled in coulmns. Kindly help me to resolve it, i am using SAS EG for data import Regards ... View more

CSV File Import :

by Calcite | Level 5 in SAS Programming
‎05-09-2013 07:49 AM
‎05-09-2013 07:49 AM
Hi, I have to import a Comma Seprated file into SAS but there is a problem with one coulm (A), Coulmn(A) has multiple values seprated by commas. while importing SAS also reads these commas, so shift the values in subsequent coulmns(B,C,..). so the data become courrpt. Can anay one please advice how can this exception(issue) be handle? so the multiple values in coulmn(A) remains in  Coulmn(A). SAS gurus your support in this would be highly appreciated Regards Ali J ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:12 AM
Likes given to
Quick links