Advertisement
Guest User

Untitled

a guest
Sep 25th, 2016
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. data classivar_1;
  2. set classvar;
  3. AnaClassVar=scan(scan(F2,1," "),2,".");
  4. run;
  5. proc sql;
  6. select AnaClassVar into : MacClassVar separated by "#" from classivar_1 ;
  7. select count(*) into: Count_classvar from classivar_1;
  8. quit;
  9. %put &MacClassVar.;
  10. %put &Count_classvar.;
  11. ods output variables=adsl_var;
  12. proc contents data=ev.adsl;
  13. run;
  14. proc sql;
  15. select variable into : AllVar separated by "#"
  16. from adsl_var;
  17. select count(*) into : Count_Allvar from adsl_var;
  18. quit;
  19. %put &Allvar.;
  20. %put &Count_Allvar.;
  21.  
  22. **** set up Macro ClassAna to analyze the classified varialbes;
  23.  
  24. %macro ClassAna(datasets= );
  25. %do i= 1 %to &Count_classvar.;
  26. %do count=1 %to &Count_Allvar;
  27. %if %sysfunc(find(%scan(&MacClassVar,&i,#),%scan(&AllVar,&count,#)))
  28. %then %do;
  29. %let Class_var&i.=%scan(&AllVar,&count,#);
  30. %end;
  31. %end;
  32. %put &&Class_var&i..;
  33. %end;
  34. %Mend;
  35. %ClassAna(datasets=sashelp.class)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement