topic LIBNAME and PROC IMPORT problem in SAS Programming

LIBNAME and PROC IMPORT problem

MeghnaRoy9 — Thu, 22 Aug 2019 14:21:02 GMT

I ran the following code to import my data and it ran fine:

PROC IMPORT DATAFILE="/folders/myfolders/SAS Assignment/Cross Sell_Data.csv"

OUT=CSD

DBMS=CSV

REPLACE;

RUN;

Post this step I ran this code but just a blank file got created:

Libname CSD "/folders/myfolders/SAS Assignment";run;

I need to further add this code to divide the dataset into Development and Validation dataset which is obviously not working because of a blank data set.

Please help me figure out my mistake. thank you!

DATA CSD.DEV CSD.VAL;
SET CSD.BITS;
IF RANUNI (1000)<= 0.7 THEN OUTPUT CSD.DEV;
ELSE OUTPUT CSD.VAL;
RUN;

Re: CODING ISSUES

Kurt_Bremser — Thu, 22 Aug 2019 13:51:33 GMT

If you do not have a file called

bits.sas7bdat

in your directory

/folders/myfolders/SAS Assignment

Then you won't have a dataset

CSD.BITS

I see no code that would have created this dataset, either.

LIBNAME and PROC IMPORT problem

PaigeMiller — Thu, 22 Aug 2019 13:56:35 GMT

@MeghnaRoy9 wrote:

I ran the following code to import my data and it ran fine:

PROC IMPORT DATAFILE="/folders/myfolders/SAS Assignment/Cross Sell_Data.csv"

OUT=CSD

DBMS=CSV

REPLACE;

RUN;

Post this step I ran this code but just a blank file got created:

Libname CSD "/folders/myfolders/SAS Assignment";run;

What is a "blank file"? Do you mean that there are no SAS data sets in the folder /folders/myfolders/SAS Assignment? That would be the expected result. THe only thing that a LIBNAME statement does is that it tells SAS to look in the specified folder for SAS data sets, and if there are no SAS data sets in there, it shows that fact. (Also, you don't need a RUN; statement after a LIBNAME statement)

Perhaps this is what you want? Note the change of order, and the referring to the imported data set by CSD.cross_sell_data, the name beginning with CSD and a period indicating that this data set is to reside in the SAS library named CSD, which was defined by the LIBNAME statement.

libname csd "/folders/myfolder/SAS assignment";

PROC IMPORT DATAFILE="/folders/myfolders/SAS Assignment/Cross Sell_Data.csv"
   OUT=CSD.cross_sell_data
   DBMS=CSV
   REPLACE;
RUN;

Also, please go back to your original post and give a meaningful title to your question, such as "LIBNAME and PROC IMPORT problem".

Re: LIBNAME and PROC IMPORT problem

MeghnaRoy9 — Thu, 22 Aug 2019 14:21:40 GMT

Thank You so much! it was really helpful.