topic Re: DATA STATEMENT in SAS Programming

DATA STATEMENT

gee21 — Thu, 31 Jan 2019 02:16:11 GMT

Hi All;

I a new in this community, I have a problem with data statement. I write a simple program as example:

data AUTOFILL_SERIAL;

set NWK.ALL2019;

do no=RANGE_START to RANGE_END;

output;

end;

run;

May I know how the program look likes if I need to save the output direct to permanent folder name 'NWK'. currently the output save directly to temporary Work Libraries.

tks

gee

Re: DATA STATEMENT

Reeza — Thu, 31 Jan 2019 02:21:59 GMT

SAS uses a two level naming system:

libName.dataSetName

You would first create a libname reference to the folder and then change your data statement to be:

libname nwk 'path to folder';
data nwk.autofill_serial;

Re: DATA STATEMENT

gee21 — Thu, 31 Jan 2019 02:42:35 GMT

Hi Rezza;

sorry not really familiar with program. Did I just need to add the libname as below .

libname NWK;

data NWK AUTOFILL_SERIAL;

set NWK.ALL2019;

do no=RANGE_START to RANGE_END;

output;

end;

run;

Still error , actually how the program should look like.

tks

gee

Re: DATA STATEMENT

Reeza — Thu, 31 Jan 2019 02:46:27 GMT

It's literally the code I wrote. You have to fill in the path and replace your data statement.

@gee21 wrote:

Hi Rezza;

sorry not really familiar with program. Did I just need to add the libname as below .

libname NWK;

data NWK AUTOFILL_SERIAL;

set NWK.ALL2019;

do no=RANGE_START to RANGE_END;

output;

end;

run;

Still error , actually how the program should look like.

tks

gee

Test this:

libname nwk 'path to folder';

data nwk.demo;
set sashelp.class;
run;