Hi The SAS data set TEMP has the following distribution of values for variable A:   A Frequency 1 500,000 2 500,000 6 7,000,000 8 3,000 Which one of the following SAS programs requires the least CPU time to be processed? A. data new; set temp; if a = 8 then b = 'Small '; else if a in(1, 2) then b = 'Medium'; else if a = 6 then b = 'Large'; run; B. data new; set temp; if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small'; else if a = 6 then b = 'Large'; run; C. data new; set temp; if a = 6 then b = 'Large '; else if a in (1, 2) then b = 'Medium'; else if a = 8 then b = 'Small';run; D. data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Small'; run; Note: The above question is from Advance sas practice exam which i found online. i would like to know the correct answer and why? Thank you. ... View more

Hi,       I am updating an excel sheet using SAS DDE. The data is in following format, date a.xls b.xls c.xls 1 456546 456546 456546 2 5643 5643 5643 3 44 44 44 4 3 3 3 5 4656 . 123 6 454542332 454542332 567      Here, I am importing data daily from few XL sheets like a, b, c. So, each row represents data collected each day & cell, a particular value from the source XL sheet.      The requirement is that if y'day's data is not updated (i.e. cell is having '.'), I need to update it along with today's value. I am storing today's and y'day's data in a macro variable at start.Then I update today's row, then I will go through y'day's row and if any of the cell (R5:b.xls) is with missing value, will update it from macro variable.      I am seeing the value for y'day's missing value cell, being updated in some other cell.       Any suggestions? ... View more

i am getting below error: Error: file_IMEX_.'feb2012$'n.data does not exist. i have chcked again &again for any spaces in sheet name still i am facing the same error. Just to mention,Actual data contains 35 columns and 1000 rows and multiple sheets(have tried for improting another sheets but got the same erro) Hi, i am unable to import the attached file using proc import. below is my code PROC IMPORT OUT= WORK.asd             DATAFILE= "C:\Tracker\ABC.xls"                        DBMS=EXCEL REPLACE;      SHEET="'feb2012$'";      GETNAMES=YES;      MIXED=YES;      RUN; ... View more

HI, Name  F1 F2 F3 F4 F5 F6 .. . .. 1Cycle  34 35 23 23 12 89 2Cycle 78 90 78 57 45 67 3Cycle 67 87 45 43 89 64 . . . 10cycle 56 45 79 90 45 78 I am having a data set like above which has a whole month data(here I have just spcified 7 columns) I want to retrive 3rd row data which is fixed and column will be chnaging on the day basis and after retriving the value, assign the value into a macro variable. for ex  on 4th feb it should select (row 3 and F4 column)=value should give 43            on the 24th feb (row 3 and F24 column) Let me know if i am not enough clear. Thanks Sudtej ... View more