Folks,   I'm having a bit of trouble trying to understand why my code won't work. I've created a macro in order to carry out two different processes depending on the time period.    Basically what I have is a datasource based of survey response and one based off administrative data.    However, not all the individuals who are in the survey are actually in the administrative data set.   Therefore what I would like to do is stack on my missing individuals to my dataset to have a hybrid of survey values(when we can't find the person on the admin dataset) and admin values(when the person is on the admin dataset).   Depending on the year there is a need to call on different datasets. Therefore, I've created this macro.   However, I'm having issue getting it to run. Any input would be great. Perhaps I'm missing %end statment somwhere or something?   Any help would be great.    %macro nonadmin; %if year = 2011 %to 2013 %then %do; data survey_&year(rename=(sex=sex1)); set mywork.combined_sample_&year_7; run; data admin_&year(keep=gender calc person_id sex agen); set mywork.combined_sample_&year._7; run; proc sort data= survey_&year; by person_id; proc sort data= admin_&year; by person_id; data combine_&year; set ssurvey_&year admin_&year; by person_id; if first.person_id and last.person_id then output run; %end; %else %if year = 2014 %to 2015 %then %do; data survey_&year(rename=(sex=sex1)); set finaldat.survey&year; run; data admin_&year(keep=gender calc person_id sex agen); set mywork.combined_sample_&year._7; run; proc sort data= survey_&year; by person_id; proc sort data= admin_&year; by person_id; data combine_&year; set survey_&year admin_&year; by person_id; if first.person_id and last.person_id then output ; run; %end; %mend nonadmin; ... View more

Folks,   I would like to use proc transpose to go from the following format;   House_id Person_id1 Person_id2 Person_id3 Person_id4 Person_id5 Person_id6 Person_id7 House_size Adults Kids 1 2826 3045 4585 1461 810 4465 3923 7 3 4 2 575 2472 3972         3 1 2 3 3185 1712 108 2420 2541 683   6 2 4 4 5539 3972           2 2 0 5 1914 2279 441 3575       4 2 2 6 4455 513 2993 1827 4519     5 3 2   to this    Pesond_id House_id House_size Adults Kids 2826 1 7 3 4 3045 1 7 3 4 4585 1 7 3 4 1461 1 7 3 4 810 1 7 3 4 4465 1 7 3 4 3923 1 7 3 4 575 2 3 1 2 2472 2 3 1 2 3972 2 3 1 2 3185 3 6 2 4 1712 3 6 2 4 108 3 6 2 4 2420 3 6 2 4 2541 3 6 2 4 683 3 6 2 4     Any help would be most welcome.    ... View more

Folks,   I would like to create a visual aid for my data in order to help me understand outliers.    What I would like to do is compare values obtained from a survey with values from other sources to see if there is a mismatch and where.    I was thinking of creating a scatter plot and divding it into four sectors.   My X-axis would be survey values and Y would be Other values.   Therefore the top left would be low survey value high other value, top right high survey value, high admin value and so on.   I've seen such an example for proc gplot bubble graph but I can't seem to replicate it for a scatter graph. Could anyone provide some assitance please?   Here is some sample data for people to look at.   data sample; input id $ 2. survey other; datalines; 01 15000 65000 02 6500 6500 03 8426 10000 04 1650 16805 05 630 1500 06 110055 56812 07 24568 15200 08 6000 7800 ; run; ... View more

Folks,   I've a strange issue which perhaps somebody could shed some light on.    For some reason SAS has stopped working for me and has thrown up strange errors. For example, the following piece of code creates the following error.   %let year = 2015; %put &year.;   1 %_eg_hidenotesandsource; 2 ;*';*";*/;quit;run; 2 ;*' _ 49 2 ! ;*";*/;quit;run; NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. This is inexplicable. I'm worker on a server and have tried changing to a different one, yet the same error occurs. Basically, nothing will run. Does anyone have any idea why this may occur?   ... View more

Folks,   I've a query which perhaps people could shed some light on.    I'm utilsing the following piece of code to to get a count of the number of observations from each of my datasets, for a number of different libs.   proc sql; create table data as select libname, memname, nvar from dictionary.tables where libname in ('BUS2011','BUS2012','BUS2013','BUS2014','BUS2015');quit; However, within these datasets there is a particular variable I would like to get a count of. Let us call it 'ID'. ID is common in all datasets, across all years.    Within ID there are two indicators to whether the variable is blank. This is either 'XXXX' or 'NONE'.    What I would like to do is tell SAS if ID has either value to delete it.    From here I would only be left with values with an actual ID. I would then like a count of all of these observations.   I understand how to this in a datastep, but the fact I'm dealing with 5 different libs, with 20 datasets in each one, would mean it would take some time to carry this out.    Thus, I've turned to SQL, which I'm sure could speed up the process, but I'm just not too sure how to carry this out.    Any help would be much appreciated.  ... View more

Folks,   I've merged two datasets and have some reason duplicates corrected within it. I would like to know where these duplicates exist. Thus I've used the following piece of code;   proc sort data=accs dupout=dups nodupkey out=correct; by idinternal customernumber idoccurrence; RUN; In the accs dataset I've 315,050 observations and in the correct dataset I've 312,326. However, the dups dataset is empty.    So it would appear that I've circa 2,700 duplicate observations but they are no where to be seen?    Could somone shed some light on the this issue, please?  ... View more

Folks,   I have a dataset with a number of string variables. The actual values in these reference variables in a number of datsets.    What I would like to do is search these variables for references to particular words.    proc sql; create table alldata as select * from dictionary.columns where libname in ('X2011','X2012','X2013','X2014','X2015') order by libname, memname ; quit; data alldat1 (keep=libname memname name type label) ; set alldata; value=spedis(label, ' income '); run; So from the example I would like to tell SAS to search the variable label for any reference to the string income.   I'm not sure if this is the correct function to use for this feature?    Given these labels are basically sentences I'm not sure if SAS will be able to look for something such as income?   Any advice is welcome.  ... View more