Hello,   I was doing some exercises to prepare for my SAS's exam and most of the tasks were focuses on the dataset sashelp.class.   Therefore, as i was doing some data steps I forgot to create new datasets using sashelp.class and instead i overwrote it.   Is there any way to return to the initial stage of this dataset? Or can i download it somewhere and somehow replace it on my PC?   That's extremely important as i could not find any answer online.   Thanks,   Wojtek ... View more

Hi guys,   i am wondering how can i change in a gmap procedure the way my regions show their values. I have a dataset which containts of 3 values: an identification variable (numeric), name of the identification variable(text) and the value (numeric). In the gmap procedure I use the id variable to create the map, but i would like to see the text variable when i put my mouse on a particular region. How can it be achieved? Please find the screen shot and the dataset attached. Below the code:   goptions reset=all; data poland; set maps.poland; run; data poland2; set maps.poland2; run; data poland_woj; merge poland poland2; by id; run; proc sort data=poland_woj; by wojid id; run; proc gremove data=poland_woj out=woj; by wojid; id id; run; proc import datafile="C:\Users\Wojtek\Downloads\ROLN_3179_XTAB_20170701180026.xlsx" out=rolnictwo dbms=xlsx replace; sheet="tablica"; run; title 'Suma powierzchni użytków rolnych na przekroju województw'; proc gmap data=rolnictwo map=woj all ; id wojid; choro powierzchnia / statistic=sum discrete ; run; footnote 'Źródło: Opracowanie własne.'; quit; title; ... View more

Hello,   I am actually trying to visualize my data using a map graph. Therefore, i decided to use proc gmap.   I have an excel file which contains different variables. One of them is the state id of polish voivodeships (in map Poland2 the variable is contained in the range between 1 to 16). For that reason I changed in the excel file the variable's name for wojid - so that it was the same in both input data set (the one from excel) and in the map dataset. I also changed the lenght of the variable (in the dataset imported from excel it was 8 and in the map it was 5) so using the data step i changed it in both for numeric 5. I sorted both map dataset by wojid and exported it by using 'out' statement and my excel dataset. I am not sure what steps should i take further. I have a variable dochg, which represents income. I would like to visualize the average income (var dochg) for every single voivedoship (var wojid) but unfortunately i am getting all the time an error. I am doing following procedures:   Sorting the dataset maps poland2 by var wojid and exporting it to dataset = polska.   proc sort data=maps.poland2 out=polska; by wojid; run;                                   Changing the length of var wojid to 5.   data gospy; set work.gospodarstwa; length wojid 5.; run;   Sorting the new dataset by var wojid   proc sort data=gospy; by wojid; run;   And then i would like to visualize the results by using below statement:   proc gmap data=gospy map=polska all; id wojid; choro dochg; run; quit;   And i get a following error :   34         proc gmap data=gospy map=polska; 35         id wojid; 36         choro dochg; 37         run; ERROR: Input data set missing X variable. ERROR: Input data set missing Y variable. 38         quit;   I should add that i would like to firstly create a dataset which contains the average of the variable dochg classed by the variable wojid, therefore i use:   proc means data=idvar sum; class wojid; var dochg; output out=sredniak; run;   Can someone please help me? I am struggling with this case for quite a long time without any success. If you need any further info please let me know. I should add that i am quite new to data analysis and therefore I am not so fluent with cases in which i face problems. I am attaching the excel file with the dataset.   Thanks a lot in advance for any queries/answers!   Tsievu100   ... View more