topic Re: My data go to the default library why? in New SAS User

My data go to the default library why?

Blandine — Fri, 09 Oct 2020 19:06:07 GMT

Hello,

I don't know why the data I imported keep going to the "work" library while I have specified where it should go ( "RBI", library.) I have to copy and paste it to the desired library. Not sure what I am doing wrong.

here is the code

/*Importing NBI Data for ILLINOIS into SAS*/
libname RBI 'C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\SAS Code\Blandine 1092020';
/*Importing TXT FILE for ILLINOIS in SAS*/
proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\IL 2019\IL19.txt"
out=NewIL19
DBMS=dlm;
delimiter=",";
Getnames=Yes;
guessingrows=1000000;
run;

Re: My data go to the default library why?

mkeintz — Fri, 09 Oct 2020 19:09:40 GMT

Change

out=NewIL19

out=rbi.NewIL19

Otherwise SAS has no way of knowing where you want the data to go. After all, you might have named a dozen libraries prior to the proc import, and SAS would not have a way to know your intention.

Re: My data go to the default library why?

Blandine — Fri, 09 Oct 2020 19:25:30 GMT

Thanks a lot