What are the criticality that you have faced during your
project in SAS?
Answers were Sorted based on User's Feedback
Answer / kanya
Problems with data probability.We usually get data in raw
format which we are supposed to read from the native format
to sas format. native format is the format which client send.
2) Problems with data inconsistencies
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / radhika rajesh
critical issues include:
1. sometimes databases shud be updated properly or else all
analysis wil show wrong result
2. i faced problem while running code during peak hours
since servers wil be slow due 2 heavy usage.
others plz add on to this..........
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
what is the use of proc sql? : Sas programming
How would you code a merge that will keep only the observations that have matches from both sets.
5 Answers Accenture, Bank Of America,
how does sas handle missing values in sort order? : Sas programming
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?
/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance
how do you test for missing values? : Sas programming
what is lifetest
what can you learn from the sas log when debugging? : Sas programming
diff between nodup rec and ondup key???
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation