topic Re: importing file from csv to sas viya; format date variable not recognized in SAS Visual Analytics

importing file from csv to sas viya; format date variable not recognized

DineAch — Fri, 11 Oct 2019 20:37:38 GMT

Hi every one! i have created some variables on sas studio and export them in cvs file. When i load my file on sas viya(by local file), my date variable is not recognized; i have a Format :$. I want to know the format that i can use in sas studio when creating my data to get my date variable in the good format in Sas viya.

My date variable look like this and i ckeck my file, there is not a charactere or something like that in my column.

Thanks for help.

Re: importing file from csv to sas viya; format date variable not recognized

SASKiwi — Sat, 12 Oct 2019 22:55:09 GMT

I'm confused. In your post title you say you are importing from CSV. In your post you say you are exporting to CSV. Which is correct? If you just want to get SAS data into SAS Viya just use a SAS dataset. You don't need to use CSV files.

Re: importing file from csv to sas viya; format date variable not recognized

DineAch — Tue, 15 Oct 2019 14:58:39 GMT

Sorry for the confusion. I need to import my csv file to sas Viya.

The problem is my date variabbles are not recognized. Sas viya display a format $

Does someone know how to process?

Ps: I can't use sas dataset; i think my enterprise hasn't access.

Re: importing file from csv to sas viya; format date variable not recognized

SASKiwi — Tue, 15 Oct 2019 20:18:56 GMT

So how are you importing your CSV data now? Please post your code if it is a program. If not explain the process.

Re: importing file from csv to sas viya; format date variable not recognized

DineAch — Wed, 16 Oct 2019 18:00:15 GMT

Hi! i m still waiting for a solution.

Please for more explanation about my problem, see attached file.

You can see my data, how i export them and what i get in sas Viya.

My date variable are considered as character with a format $. I need to have them in date format.

I hope my request is more clear.

Thanks for help.

Re: importing file from csv to sas viya; format date variable not recognized

SASKiwi — Wed, 16 Oct 2019 19:28:21 GMT

Unfortunately I don't have SAS VA on Viya to be able to help you further since you are using the Data Explorer interface. Please be aware though that SAS Studio is available to you under VA so you could indeed use SAS code to import this data to give you more control.