About Tom

Tom · ‎11-02-2011

Did you look at the PARMS statement for GLIMMIX, VARIOGRAM etc? The syntax is a little different but if there is anyway to get it to generate the values and output them into a dataset then you could pull those values into a space delimited values to use for the ARRAY statement.

Tom · ‎11-02-2011

Edit your .scr file and turn on TRACE and ECHO. Normally the ones from SAS already have the trace on; echo on; commands in them, but they are commented out. If you do not see anything obviously wrong in the responses from your mainframe then open a ticket with SAS support and they should be able to help you more detail.

Tom · ‎11-02-2011

You can set an IP address. options helphost='1.2.3.4';

Tom · ‎11-02-2011

You will want to use the DATEPART, TIMEPART, and DHMS functions. datetm3 = dhms(datepart(datetm1),0,0,timepart(datetm2));

Tom · ‎11-01-2011

Are there other statements or procedures that allow a similar syntax for specifying values? That could be used to help determine the number of values specified. Value labels for an AXIS statement perhaps? Someone with REGEX skills might be able to convert the string to a series of 1's and + signs so that %EVAL() could count the number of terms. %let parm= (4*40 3*(3*7 8 9 10)); %let parm2=(4*1+3*(3*1+1+1+1)); %let nparm=%eval(&parm2); %put nparm=&nparm; nparm=22

Tom · ‎11-01-2011

Perhaps a recursive macro to parse the initialization string and count the number of entries? Might not be too hard for numeric values.

Tom · ‎11-01-2011

If it is just the first line with the column headers then import it without names and with the FIRSTOBS=2 option to skip that line. data want ; infile 'myfile.csv' dsd dlm=',' truncover firstobs=2; input col1-col20; run;

Tom · ‎11-01-2011

Easiest is to SAS/Access to Oracle and pull directly from Oracle to SAS without the CSV file. Otherwise get whoever generates the CSV file to be a little more sophisticated. I think there are stored procedures available for Oracle that will properly quote data that contains the delimiter. If not then you will need to see if you can find a delimiter that is not included in the data as Art suggested above.

Tom · ‎11-01-2011

The suggestion was that the names would be in MACRO variables. Try changing _INPUT2 to &_INPUT2 in your code. Is there some way to see the code and/or log from the generated transform to see if it does reference macro variables?

Tom · ‎11-01-2011

One way is to try to pull a record from the view. This is done easily with PROC SQL. Here is a macro that will make a list of all of the good views in a library and put them into a macro variable. %macro goodviews(libref=work,mvar=goodviews); %if not %symexist(&mvar) %then %do; %global &mvar; %end; %let &mvar=; %local i nviews view views flag; proc sql noprint ; select catx('.',libname,memname) into :views separated by ' ' from dictionary.members where libname="%upcase(&libref)" and memtype='VIEW' ; %let nviews=&sqlobs; %do i=1 %to &nviews; %let view=%scan(&views,&i,%str( )); select 1 into :flag from &view; %if &sqlobs %then %let &mvar=&&&mvar &view; %end; quit; %mend; %goodviews;

Tom · ‎10-31-2011

Might be easier to MERGE the datasets. data want ; merge set1 (in=in1 rename=(pass=pass1)) set2 (in=in2 rename=(pass=pass2)) ; by city1 city2; if in1 and in2; run; If you really want to keep the structure vertical then here is one way. data want ; any1=0; any2=0; do until (last.city2); set set1(in=in1) set2(in=in2); by city1 city2; if in1 then any1=1; if in2 then any2=1; end; length source dsname $41; do until (last.city2); set set1 set2 indsname=dsname; by city1 city2; source=dsname; if any1 and any2 then output; end; run;

Tom · ‎10-31-2011

What do you mean by subset? I just want a subset of the actual variables with their original data. Usually a subset means a reduction in the number of OBSERVATIONS? data seniors; set have; where 65 <= age ; run; But it appears that you are talking about a subset of the number of VARIABLES? data core; set have; keep id var1-var6; run; Either way there is no need to copy and paste anything. What do you mean by "with their original data"? A subset by definition would be a copy of the original data. Did you want to do some analysis? Perhaps calculate some statistic on the data and combine it some way with the original data? Did you want to calculate statistics across observations? Such as a mean or a sum? proc sql noprint; create table want as select id,var1,mean(var1) as mean_var1 from have ; quit; Did you want to calculate a statistic across variables? data want; set have; mean = mean(of var1-var6); run;

Tom · ‎10-31-2011

Not that macro approach is right for this problem, but the main problem with your code is that you never created the dataset variables you wanted to store the values of the macro variables. %macro change; data B; set A; %do F=1 %to 2; %do C=1 %to 3; y=F&F.C&C; f=&f; c=&c; output; %end; %end; run; %mend change; %change;

Tom · ‎10-31-2011

It looks like you are doing graph analysis. You want to get the connected sub-graphs. Here is a simplified version of a macro I did years ago for this. Not sure how fast it is, but it will work as long as your disk is large enough. I think this version might be for directed graphs. You could either fix the selection logic to check both directions or just duplicate your data with the values of pair1/pair2 flipped. %macro subnet(in=,out=,from=from,to=to,subnet=subnet); /*---------------------------------------------------------------------- SUBNET - Build connected subnets from pairs of nodes. Input Table :FROM TO pairs of rows Output Table:input data with &subnet added Work Tables: NODES - List of all nodes in input. NEW - List of new nodes to assign to current subnet. Algorithm: Pick next unassigned node and grow the subnet by adding all connected nodes. Repeat until all unassigned nodes are put into a subnet. ----------------------------------------------------------------------*/ %local subnetid next getnext ; %*---------------------------------------------------------------------- Put code to get next unassigned node into macro variable because it is used in two places in the program. -----------------------------------------------------------------------; %let getnext= select node into :next from nodes where subnet=.; %*---------------------------------------------------------------------- Initialize subnet id counter. -----------------------------------------------------------------------; %let subnetid=0; proc sql noprint; *----------------------------------------------------------------------; * Get list of all nodes ; *----------------------------------------------------------------------; create table nodes as select distinct . as subnet, &from as node from &in union select distinct . as subnet, &to as node from &in ; *----------------------------------------------------------------------; * Get next unassigned node ; *----------------------------------------------------------------------; &getnext; %do %while (&sqlobs) ; *----------------------------------------------------------------------; * Set subnet to next id ; *----------------------------------------------------------------------; %let subnetid=%eval(&subnetid+1); update nodes set subnet=&subnetid where node=&next; %do %while (&sqlobs) ; *----------------------------------------------------------------------; * Get list of connected nodes for this subnet ; *----------------------------------------------------------------------; create table new as select distinct a.&to as node from &in a, nodes b, nodes c where a.&from= b.node and a.&to= c.node and b.subnet = &subnetid and c.subnet = . ; *----------------------------------------------------------------------; * Update subnet for these nodes ; *----------------------------------------------------------------------; update nodes set subnet=&subnetid where node in (select node from new ) ; %end; *----------------------------------------------------------------------; * Get next unassigned node ; *----------------------------------------------------------------------; &getnext; %end; *----------------------------------------------------------------------; * Create output dataset by adding subnet number. ; *----------------------------------------------------------------------; create table &out as select distinct a.*,b.subnet as &subnet from &in a , nodes b where a.&from = b.node ; quit; %mend subnet ; data in; input pair1 pair2 @@; cards; 1 2 1 3 2 4 5 6 run; %subnet(in=in,out=out,from=pair1,to=pair2,subnet=group); proc print data=out; run; Obs pair1 pair2 group 1 1 2 1 2 1 3 1 3 2 4 1 4 5 6 2

Tom · ‎10-31-2011

The difference you are seeing has nothing to do with PC versus Mainframe. You are running SAS interactively on your PC whereas you were submitting batch mode on the Mainframe. You can submit batch programs on the PC. Just save them to a file first. You can batch submit from Windows explorer by right clicking on the file and select batch submit. Or add the SAS directory to your search path and type the command "sas filename" to run it non-interactively just as you would on a "Mainframe" (Unix, CMS, TSO, VMS etc.). To run blocks of code interactively highlight the block of code and submit it. You can map a key to the submit command (usually F3) or hit the icon that is linked to the submit command. You can also submit blocks of code by use SUBTOP [nnn] command. This will submit just the first N lines (default is 1).

Online Status	Offline
Date Last Visited	yesterday