Explain the use of proc print and proc contents?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the difference between nodup and nodupkey options?
What do the put and input function do?
How would you combine 3 or more tables with different structures?
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
Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?
What are Dashboard reports?And significance of these in analysis?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
what is the purpose of _error_? : Sas programming
How can you limit the variables written to output dataset in data step?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
how to delete the duplicates by using proc sql?