MVSFORUMS.com

js01

Hi friends,

I am trying to create a SAS dataset using two input files , below are the input files

RECF=VB
LRECL=250

infile1:

kolusu · Posted: Mon Mar 15, 2010 3:01 pm Post subject:

js01,

There are tons of examples mentioned here

SAS Learning Module Match merging data files using proc sql

Kolusu

js01 · Posted: Mon Mar 15, 2010 4:17 pm Post subject:

Thank you very much Kolusu

I am new to the SAS ,could you please is there any user defind function in SAS ,

actually i want assign a value that retuirns from function.

Regards

kolusu · Posted: Mon Mar 15, 2010 5:10 pm Post subject:

js01 · Posted: Tue Mar 16, 2010 11:27 am Post subject:

Hi Kolusu,

actually i got a requirement to add a new field to existing SAS dataset , this SAS dataset is loaded with inpufile (VB , 250 length) with business logic. input file has the packed decimal values along with chars and numbers,
i have added new field to inputfile after 250 (which will pass from previous step)

like below

DATA SAS1
INFILE infile1
INPUT @0001 key 16
@120 var2 PD
@ .......
@251 newfield $10

some busines logic
-----

the newfiled is getting populated with zigzag data , when i used fixed block file then it was having correct value (this tested with business logic)

so i am thinking to pass new value with different file ( new) to SAS,hence want to use a function which will retrun a value

like below

DATA SAS1
INFILE infile1
INPUT @0001 key 16
@120 var2 PD
@ .......
@251 newfield $10

some busines logic
-----
newfield = getvalue(key)

---------
end

function getvalue (key)
proc sort data=sas2 output=sas3
infile inputfile2
input @001 Key 16
@015 var5 $10
return var5
end

is this possible in sas, please help me