How would you compile all macros from a folder in a study, within the autoexec program?
Answer / sumanth
Using options sasautos = (sasautos,"&_macros") after a libname statement
Is This Answer Correct ? | 1 Yes | 2 No |
What are the difference between ceil and floor functions in sas?
what is the need of INDEX in datasets?
What are the analysis datasets created, and what are the new variables created in CLINICAL SAS
1 Answers Accenture, Sciformix,
Can you explain the process of calendar?
you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
Which are the statements whose placement in the data step is critical?
To what type of programms have you used scratch macros?
Where do you use proc means over proc freq?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...