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: 
tony7zx
‎07-05-2017
  • 5 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: how to compare a charactor datetime with a numeric datetime.

by Calcite | Level 5 in SAS Programming
‎06-28-2017 09:12 AM
‎06-28-2017 09:12 AM
Thank you so much! It is working. I was try to find the right input format for a long time. Thank you. Great answer! ... View more

how to compare a charactor datetime with a numeric datetime.

by Calcite | Level 5 in SAS Programming
‎06-28-2017 08:59 AM
‎06-28-2017 08:59 AM
I have two variables in this dateset.   column A                               column B 2016-12-09T09:45                 22NOV2016:00:50:07   column A is charactor variable. column B is numeric. Each variable I have about 200 obs. I need to not only consider the date, but also the time. For some obs, that have same date, so I also need to compare time. ... View more

Re: import mbd on SAS studio not working

by Calcite | Level 5 in SAS Programming
‎11-09-2015 06:17 PM
‎11-09-2015 06:17 PM
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc import datatable='CARS_DET' 57 out=CARS515.CARS_DET dbms=accessCS replace; 58 database='/folders/myfolders/Cars_Det.mdb'; 59 run; ERROR: Server Name is invalid or missing. 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 ... View more

Re: import mbd on SAS studio not working

by Calcite | Level 5 in SAS Programming
‎11-09-2015 06:15 PM
‎11-09-2015 06:15 PM
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc import datatable='CARS_DET' 57 out=CARS515.CARS_DET dbms=access replace; ERROR: DBMS type ACCESS not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds   58 database='/folders/myfolders/Cars_Det.mdb'; 59 run; 60 61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 73 ... View more

import mbd on SAS studio not working

by Calcite | Level 5 in SAS Programming
‎11-09-2015 05:45 PM
‎11-09-2015 05:45 PM
I use these code   libname CARS515 "/folders/myfolders/HW1/CARS515"; proc import out=CARS515.CARS_DET datatable='CARS_DET' dbms=access replace; database='/folders/myfolders/Cars_Det.mdb'; run;   the error is dbms= access is not working.   After I change access to accessCS the error is 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 proc import datatable='CARS_DET' 57 out=CARS515.CARS_DET dbms=accessCS replace; 58 database='/folders/myfolders/Cars_Det.mdb'; 59 run;   ERROR: Server Name is invalid or missing. 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   60 61 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 73 ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-05-2017 01:28 PM
Likes given to
View All
Quick links