Hello,   I run into a problem when I reopened SAS. The format which can be loaded previously can not be loaded any more. I specify the libname for the formats and I can find and open them in SAS explorer. I used options fmtsearch= . However, when I try to set a dataset into another dataset, it always said "Format was not found or could not be loaded".    libname fmt 'C:\Users\hli\Desktop\work\project\HealthABC\Data\Formats'; libname PH 'C:\Users\hli\Desktop\work\project\HealthABC\Data\PH'; options fmtsearch=(fmt) ; data ph; set PH.ph; keep HABCID HCFAID DOB RACE GENDER SITE VSTATUS DOD CV3DATE VITAL06M VITAL36M DTLASTCT LASTCTYP CV1AGE CV3AGE; run; ERROR: The format RACE was not found or could not be loaded. ERROR: The format GENDER was not found or could not be loaded. ERROR: The format SITE was not found or could not be loaded. ERROR: The format STATUS was not found or could not be loaded. ERROR: The format VTYPE was not found or could not be loaded. ...   Does anyone know the reason? Thank you. ... View more

Hi,   I have a question regarding proc sql select into clause. Here is my code:   %macro varinput(data=, selectname= , namelike=); proc contents data=&data. out=contents(keep=name) noprint; run; proc sql noprint; select name into: &selectname. separated by ' ' from contents where name like "&namelike."; quit; %mend varinput; %varinput(data=outcome.cvd, selectname=miad , namelike=v_miad);   My objective is to extract those variables with name containg v_miad. I want to put these variables into a macro variable named miad. However, it seems that &miad cannot be resolved. Does anyone know how to solve this? Thank you.   ... View more