topic Re: String Function in SAS Procedures

String Function

DPraba79 — Wed, 18 Nov 2009 23:37:56 GMT

Hi,

I have a dataset with two obs and one varibale. The variable name is A and the values are "USA SAS" & "EARTH WORLD". I need to create a output datset like below.

INPUT:

A
---
USA SAS
EARTH WORLD

OUTPUT :
USA EARTH
----- ----------
SAS .
. WORLD

The first part of my input variable A should go to output varible and the second part of the input variable will be VALUE of the output variable, Could you please let me know how to do this?

Thanks

Re: String Function

sbb — Thu, 19 Nov 2009 00:24:06 GMT

Investigate using the SCAN function (DATA step, SAS variable assignment) and also the PROC TRANSPOSE procedure. The SAS support http://support.sas.com/ has SAS-hosted documentation for this topic area.

Scott Barry
SBBWorks, Inc.

Re: String Function

ChrisNZ — Thu, 26 Nov 2009 21:15:28 GMT

Alternatively you can try this.
Spaces in sas variable names must be used with caution, so I used a _ instead.
You can use a space in the variable label if you want.

[pre]
data SAMPLE;
infile cards truncover;
input A $16.;
cards;
USA SAS
EARTH WORLD
run;
data STEP1;
set SAMPLE;
length NAME $16; * set variable name length;
retain NAME; * variable name is built across several obs;
VALUE=scan(A,2); * build values;
NAME=catx('_',NAME,scan(A,1)); * build variable name;
call symput('varname', NAME); * save variable name;
run;
data STEP2;
set STEP1 (keep=VALUE rename=(VALUE=&varname)); * use variable name;
run;