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: 
Kumar1
‎12-31-2018
  • 4 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: IMPORT EXCEL SHEET WITH PROPER INFORMAT

by Calcite | Level 5 in SAS Programming
‎10-24-2015 12:26 PM
‎10-24-2015 12:26 PM
Hi Ballardw, Scenario is with many different types of date's so it might help me in any other. Thank You ... View more

Re: IMPORT EXCEL SHEET WITH PROPER INFORMAT

by Calcite | Level 5 in SAS Programming
‎10-24-2015 12:19 PM
‎10-24-2015 12:19 PM
Thank you, I realy apprictiate your suggestion deptness.   ... View more

IMPORT EXCEL SHEET WITH PROPER INFORMAT

by Calcite | Level 5 in SAS Programming
‎10-20-2015 11:43 PM
‎10-20-2015 11:43 PM
To import below data used RollNo Name Date Marks Remarks 1 Jai 24/10/1990 74 Good 2 Ram 16/11/2001 84 Better 3 Rose 9/2/2013 54 Bad 4 Pop 12/7/2001 96 Best This program is used to IMPORT PROC IMPORT OUT=Test1 DATAFILE="C:xyz\Record.xls" DBMS=Excel REPLACE; SHEET="Sheet1$"; GETNAMES=Yes; MIXED=NO; USEDATE=YES; SCANTIME=Yes; RUN;   OUTPUT: Obs RollNo Name_ Date Marks_ Remarks 1 2 3 4 1 Jai . 74 Good 2 Ram . 84 Better 3 Rose 02/09/2013 54 Bad 4 Pop 07/12/2001 96 Best   Here I'm not able to read date in proper format can anyone help me? ... View more

JOIN MAX DATE AMONG 2 DATA SET

by Calcite | Level 5 in SAS Programming
‎09-17-2015 03:41 PM
‎09-17-2015 03:41 PM
DATA A; INPUT LoanNo APAR ddmmyy8. Name$; CARDS; 101 12092014 xyz 101 24082015 xyz 101 29092015 xyz 102 22062012 abc 102 02032015 abc ; RUN; DATA B; INPUT LoanNo BillDate ddmmyy8. Amount; CARDS; 101 09092014 1200 101 29082015 8000 101 14092015 100 102 22062015 8900 102 02032015 2300 ; RUN;   Above we have 2 DATA Sets. Amoung both i need maximum date value like below mentioned. LoanNo Date             Name Price 101        29SEP2015 xyz      . 102        22JUN2015            8900   Can anyone help me in above issue? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-31-2018 05:39 AM
Likes given to
View All
Quick links