Hello Everyone, So I have this problem on my homework assignment where I need to write a proc print statement using sashelp.vcolumns dictionary to print all of the datasets that contain Product_ID. This is my code so far: data _null_;    set sashelp.vcolumn;    where libname='ORION' and name='Product_ID';    file 'C:\SAS\print_products.sas';    put 'proc print data=orion.memname (obs=5);';    put 'run;'; run; %include 'C:\SAS\print_products.sas' /source2; Unfortunately, so far I am not successful with this code and I know it's because I am not not familiar with how to use memname. Could someone please take a look at my code and let me know where I am going wrong? Thanks, Alisa ... View more

Hello Everyone, So I have the following data set that I need to create a format from which is called orion.continent:                   Continent_            Obs        ID        Continent_Name             1         91        North America             2         93        Europe             3         94        Africa             4         95        Asia             5         96        Australia/Pacific I used the following code in order to create the continent format: data continent;   keep Start Label FmtName;   retain FmtName 'Continent' ;   set orion.continent (rename=(Continent_ID=Start Continent_Name=Label));   run; proc format library=orion.myfmts cntlin=continent; run; proc format library=orion.myfmts fmtlib; run; Then my assignment calls for me to run this code and it should run without errors: data countries;    set orion.country;    Continent_Name=put(Continent_ID, Continent.); run; proc print data=Countries(obs=10);    title 'Continent Names'; run; This is the error that I am continuously getting: 307  data countries; 308     set orion.country; 309     Continent_Name=put(Continent_ID,Continent.);                                                                      ----------                                                                      48 ERROR 48-59: The format CONTINENT was not found or could not be loaded. 310  run; So I am not sure if I am coding this incorrectly or if the code that my assignment has put is incorrect. Could someone please let me know where this is going wrong? Thanks, Alisa ... View more

Hello Everyone, So I am stuck on a problem on how to use a hiter object to eliminate duplicates from a data set in order to create a new one. My example data set is orion.order_fact:                                                                       Order_                                  Obs     Customer_ID     Type                                    1               4                 3                                    2               4                 1                                    3               4                 3                                    4               4                 3                                    5               4                 3                                    6               4                 1                                    7               4                 1                                    8               4                 3                                    9               4                 1                                   10               5                 2                                   11               5                 1                                   12               5                 2                                   13               5                 2                                   14               5       2                                   15               5       1                                   16               5       2                                   17               5       2                                   18               5       2                                   19               5       1                                   20               5       1 What I need to do is to eliminate the duplicate values of Customer_ID and Order_Type so only one record would appear like Customer_ID     Order_Type 4                         1 4                         3 5                         1 5                         2 So far my code attempt is pretty pathetic since I really don't know what I am doing: data different1;    length Customer_ID 8 Order_Type 8.;    if _N_=1 then do;    if 0 then set orion.order_fact(keep=Customer_ID Order_Type);/*Using this method instead of the call missing to initialize the variables*/    declare hash test(dataset:'orion.order_fact',ordered='A',duplicate:'r');    test.definekey('Customer_ID','Order_Type');    test.definedata('Customer_ID','Order_Type');    test.definedone();    declare hiter t('test');    /*call missing('Customer_ID','Order_Type');*/    end;    t.removeDup();    if rc=0 then output different1;    stop; run; proc print data=different1 (obs=10); run; If anyone out there has any suggestions on what I should do to remedy this problem, please let me know. I know there are other ways I could go about this without using a hiter object, but this is for a homework assignment and I need to use a hiter object. Thanks, Alisa ... View more

Hello Everyone, I was wondering if someone might know how to do this because unfortunately I do not have an example to go from in my notes. What I have is a dataset with a bunch of Customer IDs and their countries which I need to turn into something that looks like this:             Customer              Customer             Country               List ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ             AU                    29, 41, 53, 111, 171, 183, 195, 215 If there is anyone out there who would know how to use hash objects to concatenate a list like this together, it would be greatly appreciated! Thanks! Alisa ... View more