in advanced certification prep, book  in hash table chapter, it has following data step. Can someone help me understand what exactly does "if _N_=1 then do" do? I really don't see the need of using this statement. data work.difference (drop= goalamount);      length goalamount 8;      if _N_ = 1 then do;           declare hash goal( );           goal.definekey("QtrNum");           goal.definedata("GoalAmount");           goal.definedone( );           call missing(qtrnum, goalamount);           goal.add(key:’qtr1’, data:10 );           goal.add(key:’qtr2’, data:15 );           goal.add(key:’qtr3’, data: 5 );           goal.add(key:’qtr4’, data:15 );      end;      set sasuser.contrib;      goal.find();      Diff = amount - goalamount; run; ... View more

On advanced certification book, it says to update record using transaction dataset and by method. book suggests we write an accumulation statement so that all the obs inthe transaction ds are added to the master observation? I am using following example. Following code trans dataset, 13 is a dup, 2nd 13 was writen to mas data set, which is not right. data mas; input id var1 $; cards; 12 fish 13 pole 14 system 15 new ; data trans; input id var1 $; cards; 13 ab 13 cd 14 book ; data mas; modify mas trans; by id; run; proc print data=mas;run; ... View more

I have a raw data like this: 649519BU8 12/15/2021 100 12/15/2022 100 12/15/2023 100 12/15/2024 100 12/15/2025 100 519Bw852 12/15/2026 100 12/15/2027 100 12/15/2028 100 12/15/2029 100 12/15/2030 X028W71659 11/19/2011 3/9/2012 3/9/2022 12/15/2005 4/8/2008 D7P00A1 12/15/2031 70 12/15/2032 60 12/15/2033 74 12/15/2034 68 12/15/2035 68 12/15/2036 75 DE000A1GNAH1 7/8/2021 80 10/8/2021 70 1/8/2022 100 4/8/2022 60 7/8/2022 80 10/8/2022 XS0271265299 10/19/2011 1/8/2022 4/8/2022 12/15/2025 4/8/2023 804519KN3 12/15/2026 99 12/15/2027 100 . 100 12/15/2029 . 12/15/2030 I want to read them into sas file into 3 colums ID                 Date          Price 649519BU8  12/15/2021  100  649519BU8  12/15/2022  100 649519BU8  12/15/2023  100 D7P00A1    12/15/2031    0.7 D7P00A1    12/15/2032    0.6 XS0271265299  10/19/2011  . XS0271265299  1/8/2022   . XS0271265299  4/8/2022   .    This challenge is the price column in the raw data file is not fixed, some times it have price like 1st, 2nd row some times it does not have price, like 3rd row (X028W71659 row) some times it is a percentage like 4th row (D7P00A1 row), it is 70%, or 0.7, so basically any value less than 90 is a percentage, not a price each row, in the end, they are not fixed columns/ length or any sort. so, how do I read them in? ... View more

data difference (drop=goalamount)/**/;     length goalamount 8 ;     if _n_=1 then    do;         declare hash goal();             goal.definekey('QtrNum');             goal.definedata("goalamount");             goal.definedone();             /*avoid the NOTE of "var uninitialized "*/             call missing(qtrnum,goalamount);           goal.add(key:'qtr1', data:10);             goal.add(key:'qtr1', data:15);             goal.add(key:'qtr3', data:5);             goal.add(key:'qtr4', data:15);     end;     set sasuser.contrib;     goal.find();     Diff=amount-goalamount; run; Define a hash object, log keeps saying " ERROR: Variable QtrNum has been defined as both character and numeric. " I don't get where I cause the error? I checked Listserv, but still don't know how to fix this. This example is from advanced sas certification, chapter 17, hash object definition, hard-code section, this is a buggy code, just doesn't work. ... View more

Can anyone suggest some datasets in sashelp lib which contains nice mixture of catigorical variables, numercial variables, sizable obs, things like that. I know sashelp.cars, but don't know others. ... View more