In SAS, how to modify speicfic fields of perticular records
Select messages from
# through # FAQ
[/[Print]\]

MVSFORUMS.com -> Application Programming

#1: In SAS, how to modify speicfic fields of perticular records Author: srini_igsiLocation: Mumbai PostPosted: Thu Jul 13, 2006 4:39 am
    —
Hi,

I have two files like X & Y.
X has 2000 records, consisting of 200 fields.
Y has 20 records , consisting of 10 fields.
Total 6 fields are common.
Field1:: SALESNO is the common unique field in both the files.
Field2-6:: For these 5 fields values are coming from Y file, these 5 values to be updated in X file, remainig fields should be same.
How can i do this?
Please let me know ASAP.

#2:  Author: kolusuLocation: San Jose PostPosted: Thu Jul 13, 2006 7:08 am
    —
srini_igsi,

Go thru this link which has detailed examples of File matching in sas

http://www.ats.ucla.edu/stat/SAS/modules/merge.htm

Hope this helps...

Cheers

Kolusu

#3:  Author: DibakarLocation: USA PostPosted: Fri Mar 23, 2018 2:46 pm
    —
Above link does not work so providing a new link

https://stats.idre.ucla.edu/sas/modules/match-merging-data-files-in-sas/



MVSFORUMS.com -> Application Programming


output generated using printer-friendly topic mod. All times are GMT - 5 Hours

Page 1 of 1

Powered by phpBB © 2001, 2005 phpBB Group