06-04-2015 12:00 PM
i have a code I should the records which has only those vendors names but I have 30 vendor names and I don't want to type all those vendor names so is there any way . keeping all those 30 vendor names in excel and can call it using macro . Any idea ?? Pls help
06-04-2015 12:49 PM
You can import the excel file and write it out to a sas dataset that you can call on, you can write the 30 names into a proc format. I'm sure there are other options but without more details it's hard to help.
06-05-2015 03:57 AM
Import the list of vendors into SAS.
Create a proper cntlin file for proc format that assigns the value 1 to all vendors, and attach a line for "other" that assigns 0,
Aplly that format in a data step and keep only the records where the formatted value is 1.
If you're not yet firm with all these procedures/steps, copy/paste the list into the EG code window and reformat it manually so that it can be used in an "in" condition.
06-05-2015 04:49 AM
proc import datafile="xyz.xlsx" out=temp;
create table WANT as
where VENDOR in (select distinct COL1 from TEMP);