topic Re: Import a csv file and then export a sas dataset in SAS Programming

Import a csv file and then export a sas dataset

SteelersPitts — Fri, 20 Jul 2018 18:56:05 GMT

Hi,

I'm trying to import a csv file and then export a sas dataset as on output but I'm running into issues. Can anyone let me know where I'm going wrong? My code logic is as follows:

Import:

Proc Import out=xyz

datafile='c:\User\Folder\File_Abc.csv'

DBMS =csv replace;

run;

SAS Dataset export

Libname out 'c:\user\Desktop';

data out.test;

set xyz;

run;

I'm receiving an error saying "set is not allowed in the data statement".

Can anyone let me know how I export the sas dataset here? Thank you.

Re: Import a csv file and then export a sas dataset

Urban_Science — Fri, 20 Jul 2018 18:48:19 GMT

You need to close your quotation marks for both times you use it. Also, you had an extra semicolon in the proc import statement.

Proc Import out=xyz
   datafile='c:\User\Folder\File_Abc.csv'
   DBMS =csv replace;
run;

 


Libname out 'c:\user\Desktop';

data out.test;
set xyz;
run;

Re: Import a csv file and then export a sas dataset

SteelersPitts — Fri, 20 Jul 2018 18:57:19 GMT

I apologize for the missing quotes and extra semi-colon in the post. However, the code has proper quotes and semi-colon but it still does throw up errors.

Re: Import a csv file and then export a sas dataset

Urban_Science — Fri, 20 Jul 2018 19:01:30 GMT

Without seeing the errors, my guess is that the paths are wrong. C:\Users\<User Name>\
But that could be an editing mistake when posting.

Re: Import a csv file and then export a sas dataset

Reeza — Fri, 20 Jul 2018 19:02:37 GMT

Post the full log from the code you're running.

@SteelersPitts wrote:

Hi,

I'm trying to import a csv file and then export a sas dataset as on output but I'm running into issues. Can anyone let me know where I'm going wrong? My code logic is as follows:

Import:

Proc Import out=xyz

datafile='c:\User\Folder\File_Abc.csv'

DBMS =csv replace;

run;

SAS Dataset export

Libname out 'c:\user\Desktop';

data out.test;

set xyz;

run;

I'm receiving an error saying "set is not allowed in the data statement".

Can anyone let me know how I export the sas dataset here? Thank you.

Re: Import a csv file and then export a sas dataset

Urban_Science — Fri, 20 Jul 2018 19:04:44 GMT

I didn't see that you edited your post. Nevermind with the path. My new guess is that you might have forgotten a semicolon after data out.test

Re: Import a csv file and then export a sas dataset

SteelersPitts — Fri, 20 Jul 2018 19:57:12 GMT

My bad! Code is working fine now. There was a missing semi-colon. Thanks everyone.