What is the difference between the proc sql and data step?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SAS Interview Questions

What areas of SAS are you most interested in?

0 Answers   Quintiles,


how do you test for missing values? : Sas programming

0 Answers  


How do you debug macros?

3 Answers   Accenture,


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 ...

0 Answers   Accenture,


What is proc sql pass through facility?

4 Answers   L&T,






libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak

7 Answers  


what is ae onset date n what is RDS

0 Answers   Accenture,


Which is the best training institute for SAS in hyderabad.

112 Answers   Stansys Software Solutions,


What is the purpose of trailing @ and @@? How do you use them?

0 Answers  


Explain the main difference between the sas procedures and functions? : Sas-administrator

0 Answers  


What is the use of stop statement?

0 Answers  


What is the difference between %local and %global? : sas-macro

0 Answers  


Categories