I have a dataset concat having a variable a b & c. How to rename a b to e & f?
No Answer is Posted For this Question
Be the First to Post Answer
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above code how to convert character data values to numeric data values?
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
What is the difference between an informat and a format? Name three informats or formats.
Describe the function and untility of the most difficult SAS macro that you have written.
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?
What is difference between Global n Local Macro Variables..?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How would you code a macro statement to produce information on the SAS log? This statement can be coded anywhere.
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;
how to intersect the tables by using PROC MIXED?