topic Re: how to set proper date format with EG to import csv file in SAS Programming

how to set proper date format with EG to import csv file

Geo- — Fri, 24 Aug 2018 04:28:53 GMT

The date column values in csv file look like:

log_date	cst_id
20180502	101
20180818	102

after I used EG to import this file,the column values in SAS all shows "."

how should I set a right format before import or change the column into the right date type after import that can show its value?

thanks for your time.

Re: how to set proper date format with EG to import csv file

Kurt_Bremser — Fri, 24 Aug 2018 06:49:56 GMT

data want;
infile ".......csv" dlm=",";
informat
  log_date yymmdd8.
  cst_id $3.
;
input
  log_date
  cst_id
;
format
  log_date yymmddd10.
;
run;

Just use proper informats. The import wizard might have mis-guessed.

Re: how to set proper date format with EG to import csv file

Kurt_Bremser — Fri, 24 Aug 2018 06:51:04 GMT

And if you are running this in a client-server environment, you need to have the file on the server. Use the Copy Files task for this.

Re: how to set proper date format with EG to import csv file

BrunoMueller — Fri, 24 Aug 2018 07:53:00 GMT

how does the column definition in the import data wizard look like?

It should look similar like this, usually EG picks the column as a date

Re: how to set proper date format with EG to import csv file

Kurt_Bremser — Fri, 24 Aug 2018 12:04:43 GMT

@Geo- wrote:

The date column values in csv file look like:

log_date cst_id

20180502 101

20180818 102

after I used EG to import this file,the column values in SAS all shows "."

how should I set a right format before import or change the column into the right date type after import that can show its value?

thanks for your time.

Actually, your csv file (hopefully) does NOT look like this. A csv file looks like this:

log_date,cst_id
20180502,101
20180818,102