SAS Support Communities

tony7zx · ‎06-28-2017

Thank you so much! It is working. I was try to find the right input format for a long time. Thank you. Great answer!

tony7zx · ‎06-28-2017

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.

tony7zx · ‎11-09-2015

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

tony7zx · ‎11-09-2015

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

tony7zx · ‎11-09-2015

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

Online Status	Offline
Date Last Visited	‎07-05-2017 01:28 PM

SAS Support Communities

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

how to compare a charactor datetime with a numeric datetime.

Re: import mbd on SAS studio not working

Re: import mbd on SAS studio not working

import mbd on SAS studio not working

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

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

how to compare a charactor datetime with a numeric datetime.

Re: import mbd on SAS studio not working

Re: import mbd on SAS studio not working

import mbd on SAS studio not working

Follow Us

What is...