NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
NOTE: This...
Actually it derives from a stupid question.
I have the data file like
Ulti Part Tply
120.00 86.11 0.0064
119.00 84.22 0.0063
123.00 86.90 0.0065
117.00 83.11 0.0063
120.00 85.91 0.0062
I expect to get statistics...
Sorry, repeat the reply.
Actually what I wanna know is how to import SAS data to merged cell, very important and not avoidable problem for me
thanks a lot
filename title dde 'excel|[ASAP1.xls]INPUT DATA!r10c4:r10c4' notab lrecl=20000;
data _null_;
file title;
put 'CTD';
run;
But this cell is merged by two closed cells. I've got information like "Can't change part of a merged cell", and there is no answer in related tech document.
Thanks for...
proc means data=sample.b CV;
Var f15 f16 Avgtply NormUlti Norm2percent;
Title 'Summary of PB1 final';
output out=sample.a;
Run;
My simple question is:
How to output procedure data to dataset, with CV.
Each time I get something like MEAN N STED... But no CV
Another foolish question, why I can't input character variable from keyboard by %windows macro, I can only input numbers.
%window dialoguewindow
icolumn=15
irow=10
columns=80
rows=20
"<Creat a summary sheet>"
#3 @20 "Adjusted Table Format"
#5 @15 "please enter information of tables"
#7 @15...
I'm really confused about macro and data step in SAS.
Can I do like this?
%macro append;
DATA sample.export1;
if &TestProp NE 100
then %clipboard;
Run;
PROC APPEND BASE=sample.export1 DATA=sample.export1 FORCE;
run;
%mend append;
%macro merge;
x=4;
ulabel:x=x-1;
%append
if x GT 1...
%macro merge;
DATA sample.export1;
if &TestProp NE 100
then %clipboard;
Run;
PROC APPEND BASE=sample.export1 DATA=sample.export FORCE;
run;
%mend merge;
%merge
What I'm doing is merging several tables ( from 2 to 5)into a summary sheet. Each time get new list of observations from a clipboard...
Hey, you guys!I encountered a small problem
While I was seting a parameter-feedback window
%window feedback
icolumn=15
irow=10
columns=80
rows=20
"<Creat a summary sheet>"
#3 @20 "Adjusted Table Format"
#5 @15 "please enter information of tables"
#7 @15 "The Testing Property" @40 TestProp 6...
I have read the instruction of DDE. It really helps. But still some question I can't figure out.
1. How to add content to one cell.
2. How to move the table entirely to some specific position in the sheet, or how to add empty columns and lines.
3. I want to keep some content in orginal template...
Hi.
I have a variable with name "specimen#" given data format like A0N1A114A, I hope to get the fourth number(1 in the case) and create a new column. please help me.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.