About Alpay

Alpay · ‎06-13-2012

You can create a format from your data set using proc format and specifying your format data set (cntlin option). For further explanation please see the documentation for proc format in help files. I have not tested the following code but it gives an idea as a starting point. data zipfile; input Region ZipCode $; datalines; 1 48001 2 28003 3 34564 1 48002 ; run; data zipfmt; set zipfile; retain zipfmt '$zipfmt'; Start =Zipcode; Label = Region; keep fmtname Start Label; run; proc format cntlin=zipfmt; run;

Alpay · ‎06-13-2012

I am not sure what's happening there in inline query. I have added alfa2 in select statement and dropped the same in a data set option. It seems this returns what's needed. proc sql; create table arq_join2(drop=alfa2) as select alfa1, alfa2, count(*) as qte_alfa1, qte_alfabeta2 from arq1_, (select alfa2,beta2,count(*) as qte_alfabeta2 from arq2_ group by 1,2) where alfa1=alfa2 group by 1 ; quit;

Alpay · ‎06-13-2012

An alternative could be using a generic macro to check whether fileref t exists first in current session. If so, get the PATHNAME associated with this fileref. Otherwise, use SYSIN option's value (in batch mode) or SAS_EXECFILEPATH macro variable's value (in interactive mode). /* Save this as getpath.sas and compile in your session */ %macro getpath; %if %SYSFUNC(FEXIST(t)) %then %let path = %SYSFUNC(PATHNAME(t,F)); %else %let Path = %SYSFUNC(IFC( "%SYSFUNC(GETOPTION(SYSIN))" ne "", %SYSFUNC(GETOPTION(SYSIN)), %SYSGET(SAS_EXECFILEPATH))); %put Path = &Path; %mend; /* Master program */ filename t "d:\temp\zip\a.sas"; %include t; filename t "d:\temp\zip\b.sas"; %include t; /* a.sas */ %getpath; %put 123; /* b.sas */ %getPath; %put ABC;

Alpay · ‎06-13-2012

You can get the name of the running program by using filerefs inside included programs. Here, the physical path is specified in a filename statement referred as fileref t and its path resolved using PATHNAME function in the included program(s). This will work when filename t is assigned in another program and a.sas and b.sas are included. If one executes a.sas alone filename t wouldn't have been assigned or coıuld have been assigned to another file in an interactive session. /* Master program */ filename t "d:\temp\zip\a.sas"; %include t; filename t "d:\temp\zip\b.sas"; %include t; /* a.sas */ %let path = %SYSFUNC(PATHNAME(t,F)); %put path = &path; /* b.sas */ %let path = %SYSFUNC(PATHNAME(t,F)); %put path = &path;

Alpay · ‎06-12-2012

If you want the difference between TEST and the average TEST of that Class you can make use of 1st scenario. Second and third ones are average of average group means and overall mean for TEST, respectively. data x; input Product Machine Test; datalines; 0 0 1 0 0 4 0 0 3 0 1 2 0 1 4 1 0 3 1 0 7 1 1 4 1 1 2 ; run; proc sort data=x; by Product Machine; run; /* Difference between TEST and group mean */ proc summary data=x nway missing; class Product Machine; var Test; output Out=x_group_mean(drop=_:) mean=Mean; run; data want_dif_group_mean; merge x x_group_mean; by Product Machine; DIF = Test - Mean; run; /* Difference between TEST and mean of group means */ proc summary data=x_group_mean nway missing; var Mean; output Out=x_mean_of_group_mean(drop=_:) mean=Mean; run; data want_dif_mean_of_group_mean; if _n_ = 1 then set x_mean_of_group_mean; set x ; DIF = Test - Mean; run; /* Difference between TEST and overall mean */ proc summary data=x nway missing; var Test; output Out=x_overall_mean(drop=_:) mean=Mean; run; data want_dif_overall_mean; if _n_ = 1 then set x_overall_mean; set x ; DIF = Test - Mean; run;

Alpay · ‎06-12-2012

You will need to either add an "order by varnum" statement into your sql code or get rid off "distinct" to have it return the variables in the order they are in the data set. The same goes for data set X where the variables in it happened to be in alphabetical order. /* got rid off distinct */ proc sql; select name into :var1- :var%TRIM(%LEFT(&num_vars)) from dictionary.columns where libname="WORK" and memname="L2" ; quit; /* added order by varnum */ proc sql; select distinct(name) into :var1- :var%TRIM(%LEFT(&num_vars)) from dictionary.columns where libname="WORK" and memname="L2" order by varnum ; quit;

Alpay · ‎06-12-2012

For example: Download the following file from www.census.gov web site (2010 TIGER/Line® Shapefiles: ) 2012 TIGER/Line Shapefiles: ZIP Code Tabulation Areas for Michigan. You can download the shape files for other states as well and define your zip code to region format. proc format; value $zipfmt '48001'-'48999' = 'Region 1' '49000'-'49999' = 'Region 2' other = 'Region 3'; run; proc mapimport datafile="D:\Temp\Zip\tl_2010_26_zcta510.shp" out=mi; run; proc sql; create table mi_1 as select -1*x as x, y, ZCTA5CE10 as Zip, Segment, put(ZCTA5CE10,$zipfmt.) as Region from mi; run; proc sort data=mi_1; by Region Zip Segment; run; proc gremove data=mi_1 out=mi_2; by Region; id Zip Segment; run; proc gproject data=mi_2 out=mi_prj degrees; id Region; run; goptions device=png htext=3 gunit=pct cback=verylightmoderateyellow; title; proc gmap data=mi_prj map=mi_prj; id Region; choro Region / discrete coutline=Black nolegend; run;

Alpay · ‎06-12-2012

How many variables are there in your data set? You may need to work with less number of variables than what is in your data set to make it work. Try creating another data set with let's say 1000 variables.We had a similar issue with over 5000 variables and 12 milliions observations and we ended up spliting the data set into 7 sets.

Alpay · ‎06-12-2012

Use RENAME statement to rename the column. Beware that when you change the column name the label of the column won't change. proc freq data=sashelp.class; table Sex/out=class_summary; run; proc datasets lib=work nolist; modify class_summary; rename Count = New_Variable; label New_Variable = 'New Label'; run; quit;

Alpay · ‎06-12-2012

You will need to use the column/variable name right after LABEL. Frequency Count seems to the label associated with this column. Right click on the column labeled Frequency Count and check out the name of the variable. You can also use Proc Contents for this data set to figure out the column/variable names. proc datasets lib=work; modify abc; label VariableName="New Variable Label"; run; quit;

Alpay · ‎06-11-2012

If I unserstand it right, you want to drill down from region to zip codes and color it on a map and remove the inerior boundaries for regions. Do these regions have discontiguous areas? You will probably need shape files for zip codes (www.census.gov).

Alpay · ‎06-11-2012

Then use LABEL statement. proc datasets lib=work; modify abc; label oldvar="New Label"; run; quit;

Alpay · ‎06-11-2012

RENAME will rename a variable's name. data x; set sashelp.class; rename Age=AgeNew; run; If you want to do it in an existing data set you may use PROC DATASETS; This will change the variable name without recreating the data set. proc datasets lib=work; modify abc; rename oldvar=newvvar; run; quit;

Alpay · ‎06-11-2012

You may try collecting different id variables under one variable. 500K obs would go up to 2500K obs (500 x 5). proc sql; connect to odbc(dsn=<yourdsnname>); create table x as select * from connection to odbc( select a.* from largetable a inner join (select id1 id from smalltable UNION ALL select id2 id from smalltable UNION ALL select id3 id from smalltable UNION ALL select id4 id from smalltable UNION ALL select id5 id from smalltable ) b on a.id = b.id ); disconnect from odbc; quit;

Alpay · ‎06-08-2012

Without seeing your code it is impossible to know why you get the above mentioned error. An alternative way could be using user-defined formats to assign labels(Ages 0 or greater than 100 are not accounted for). Zafer proc format; value age 1 -< 20 = 'Child' /* [1,20) */ 20 -< 40 = 'Youth' /* [20,40) */ 40 - 100 = 'Oldies' /* [40,100] */; run; data test; input Age; Group = PUT(Age,age.); put (Age Group) (=); datalines; 1 19 20 39 40 100 ; run; Age=1 Group=Child Age=19 Group=Child Age=20 Group=Youth Age=39 Group=Youth Age=40 Group=Oldies Age=100 Group=Oldies

Online Status	Offline
Date Last Visited	‎07-30-2018 04:57 PM

Re: SAS Model Implementation Platform 3.1 New Features

Re: Dates = numbers? HOW

Re: Need help in introducing parallel processing.

Re: How to get one subset like this?

Re: How to get one subset like this?

Re: Top 10 retailors according to Script Count for Tpye

Re: Need help in introducing parallel processing.

Re: Need help in introducing parallel processing.

Re: Why this do until loop using all the observations?

Re: Transform dates to weeks and match with other dates?

Re: Row/column headings colors in tabulate

Re: how avoiding proc sorting before proc transpose

Re: Whats the problem about this loop?

Re: %SYSFUNC format problem

Re: proc sql summary table considering distints subjids

Re: Transform Data by Zip Code into US Regions

Re: SQL - different results inline x where

Re: %include a file in a seprate location with a %sysget(SAS_EXECFILEP...

Re: %include a file in a seprate location with a %sysget(SAS_EXECFILEP...

Re: Calculation within a data step

Re: Rename variable with macro in two datasets

Re: Transform Data by Zip Code into US Regions

Re: Dealing with big database

Re: Rename sets

Re: Rename sets

Re: Transform Data by Zip Code into US Regions

Re: Rename sets

Re: Rename sets

Re: Matching payments to people

Re: SAS Macros Help - Generating IF ELSE Conditions dynamically using ...