topic Re: Create dataset uing scan function in SAS Programming

Create dataset uing scan function

deleted_user — Wed, 18 Nov 2009 07:43:58 GMT

Hi All,
I have one dataset (data1) with single observation say: something|to|be|written|here.

I have to create other dataset(data2) from above dataset(data1) with below observations:
something
to
be
written
here

I have to do this using scan function only.

Please Help!!!

Thanks,
Hema Tandon

Re: Create dataset uing scan function

Patrick — Wed, 18 Nov 2009 10:54:11 GMT

Hema

You only learn it by solving it yourself - or at least invest some time trying to find out.
You'll find everything in the Online Doc and there are normally also examples.

But let's assume you waited too long before starting with work....

data have;
var="something|to|be|written|here.";
run;
data want;
set have;
length newvar $ 10;
keep newvar;
do i=1 to length(var) while(scan(var,i,'|') ne '' );
newvar=scan(var,i,'|');
output;
end;
run;
proc print data=want;
run;

Re: Create dataset uing scan function

deleted_user — Wed, 18 Nov 2009 11:56:48 GMT

Thanks Patrick,

I was missing output statement in the code I wrote 😞

I am new to SAS,trying to practice it but not able to find much exercises for trying writing new codes.

Regards,
Hema Tandon

Re: Create dataset uing scan function

sbb — Wed, 18 Nov 2009 14:22:50 GMT

Suggested Internet search:

sas programming exercises

Also, you will find code samples here:

http://support.sas.com/documentation/onlinedoc/code.samples.html

Scott Barry
SBBWorks, Inc.