In data step, I have to check whether the delimiter is space or tab. When I open the file with notepad. It can't distinguish space and TAB. My question is "How to distinguish space with TAB in raw data?" I use spread sheet to open it first then identify the delimiter. Is there any way to examine it?
... View more
This is my data in the text file. MPG WEIGHT PRICE
----------------------
22 2930 4099
17 3350 4749
22 2640 3799
20 3250 4816
15 4080 7827 I want to use do loop and array to generate the dadaset. But I am not sure how to deal with the second line, which is dash line. I want to skip it.
... View more
Hi, I want the result can be an arrary format, so I can retrieve the first element and second item etc. So for example, for AA, it is an array. The first item of the array is A, the second item of array is A also.
... View more
Say we have 4 letters--"A", "B","C","D". Now I want to get the combinations, the result should be 16 ELEMENTS. AA
AB
AC
AD
BA
BB
BC
BD
CA
CB
CC
CD
DA
DB
DC
DD Thank you.
... View more
Hi, I don't understand the model in glm. Say. proc glm data=mydata;
class name;
model a b c d = name;
ods output modelanova=myanova;
run; I am not sure the meaning of "=" in the line of model. Can we rewrite the code as model a =name b c d;
Or model a b =name c d;
... View more
The reason I asked is I want to reference the parameter into the tite statement. title "the least abudant group is %upcase(¶m)" I want to replace the word "least" in the title statement with the param as they are same words.
... View more
I have a macro paragram. %macro test(param);
proc print data=customer;
where customer_group="¶m";
%if ¶m=A members %then %do;
title "the most abudant group is %upcase(¶m)";
%end;
%else %do;
title "the least abudant group is %upcase(¶m)";
%end;
var name gender age customer_group;
run;
%mend test;
options mprint mlogic;
%let least=Internet/Catalog Customers;
%test(&least); But I get an error: MPRINT(TEST): where customer_group="Internet/Catalog Customers";
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric operand
is required. The condition was: ¶m=A members
... View more
Say I have a variable x in a data set, I use PROC FREQ to sort the dataset. PROC FREQ MyData;
tables x;
run; So I get the frequencies. Say x has three groups. Group one has 4, group two has 24, group three has 59. Now I want to print the details (names and ages) with the smallest count group(group one). How?
... View more
I added if condition but it seems not applied. if state= 3 then
do i = 1 to 4;
if a[2*i-1] NE 0 then
do;
b[4*i-3] = c[i] - a[(2*i-1)];
b[4*i-2] = b[4*i-3] / a[(2*i-1)];
end;
if a[2*i] NE 0 then
do;
b[4*i-1] = c[i] - a[2*i];
b[4*i] = b[4*i-1] / a[2*i];
end;
end; Why?
... View more
