About terrencetang

terrencetang · ‎10-04-2016

You can try the following code, hope it can help you. Assuming your datatset is called "a": data V1; set a; where V1 is not missing; keep ID V1; run; data V2; set a; where V2 is not missing; keep ID V2; run; data V3; set a; where V3 is not missing; keep ID V3; run; data a; merge V1 V2 V3; by ID; run; proc datasets nolist; delete V1 V2 V3; run; ------------------------------------------------------------------------------------- If you have more variables in the dataset similar to this pattern, just create more V<n> datasets in the same way, and then merging them in the data step. The proc dataset is used to delete those workings.

terrencetang · ‎10-04-2016

You can use MACRO to achieve it; libname raju 'C:\Users\q807540\Documents\SAS'; %let ds=adverse; <I found that you are omitting the "%let"> %MACRO test; %if %sysfunc(exist(raju.&ds)) %then %do; data ad; set raju.&ds; where sex = 'M'; run; %end; %else %do; data ad; msg="NO SAS DATASET PRESENT"; run; %end; %MEND test; %Test; -------------------------------------------- You can also use %put function to make your message displaying in the SAS log instead of in a dataset. %put NO SAS DATASET PRESENT; Just replace the code between %else %do; and %end;

Online Status	Offline
Date Last Visited	‎10-25-2017 04:00 AM

Re: Merging rows by ID which isn't unique

Re: reading the sas dataset from the given path

Re: Merging rows by ID which isn't unique

Re: reading the sas dataset from the given path

Re: Merging rows by ID which isn't unique

Re: reading the sas dataset from the given path