Hello Raveena,
This is a solution:
[pre]
data i;
retain n;
input NO Prov Lice;
if Prov NE Lice;
n + 1;
drop NO;
rename n=NO;
datalines;
1 100675 100897
2 100989 100989
3 100897 100897
4 100976 100972
run;
[/pre]
Sincerely,
SPR
... View more
Hello Littlestone,
I made some changes in your code:
[pre]
data _null_; /*data step 2*/
dsid = open ('work.testl');
NumOfVar = attrn (dsid,'NVAR');
call SYMPUTX('NumOfVar',NumOfVar);
run;
data test2; /*data step 3*/
array NewVar{&NumOfVar} newvar1-newvar&NumOfVar;
do i=1 to &NumOfVar;
newvar[i]=i;
end;
run;
[/pre]
Sincerely,
SPR
Message was edited by: SPR
Message was edited by: SPR
... View more
How are you going to use a variable contaning greek letters? May be you need them only for titles, axis , etc? For example, for Title you can use the following code:
[pre]
ods escapechar="^";
title "Greek letter ^{unicode 03B1}";
data a;
a=1;
run;
proc print data=a;
run;
[/pre]
that prints greek alpha in the title;
SPR
... View more
Hello SASUser1000,
"What about the Problem of multicolinearity in this case? between lag1(y) and
lag2(y) ? should I be concerned about that? What should I look for in that case"
proc REG has special options to test collinearity, see "Collinearity Diagnostics" topic in SAS help for proc REG.
model y=lag1y+lag2y+X1+X2/ tol vif collin;
switches on the diagnostics.
Sincerely,
SPR
... View more
The following program outputs all available letters, digits ans symbols:
[pre]
data a;
do i=0 to 255;
s=BYTE(i);
output;
end;
run;
[/pre]
I ran it om my computer. the output does not contain the alpha character. Your result could be different because characters 127-255 depend on character set used.
SPR
... View more
Hello Sudhakar_A,
What are you trying to accomplish? I used BYTE(224) and got the following result:
[pre]
data a;
x=BYTE(224);
y=BYTE(65);
put x= y=;
run;
[/pre]
In the LOG:
[pre]
x=à y=A
[/pre]
Is this what you need?
Sincerely,
SPR
... View more
Hello Bncoxuk,
I use EG 4.3 and tested the suggestion I provided. If LENGTH is before SET then everything works as expected. This is a program that I tested:
[pre]
PROC FORMAT;
VALUE $sexf
'F' = 'Female'
'M' = 'Male'
;
RUN;
DATA class;
LENGTH sex $8; /*to change the length from 1 to 8*/
SET sashelp.class;
sex=PUT(sex,$sexf.);
sex1=PUT(sex,$sexf.);
RUN;
[/pre]
Sincerely,
SPR
Message was edited by: SPR
... View more
Hello Bncoxuk,
The problem is that your sex variable in the file02 dataset still has a length of 1 (the length is inherited from file01). To get what you need it is necessary to place LENGTH before SET.
Sincerely,
SPR
... View more
Hello FL,
Do you really need a do loop? You could get all necessary information by the following code:
[pre]
proc univariate data=sample0 noprint;
where exchcd=1;
var sv1 sv2 sv3;
by date;
output out=nyse pctlpts=30 70 pctlpre=sv1 sv2 sv3;
run;
[/pre]
Sincerely,
SPR
... View more
Hello Uli,
It is a solution:
[pre]
data i;
input a;
format a E9.3;
if a LT 100 then r=INPUT(PUT(a,E9.3),15.8);
else r=INPUT(PUT(a,15.3),15.3);
datalines;
2
22
100
250.678
250.6786
0.0067
0.00006789
0.7567
run;
[/pre]
Sincerely,
SPR
... View more
Hello SASPhile,
This is my solution:
[pre]
proc SQL noprint;
select COUNT(distinct memname) as N into :N
from SASHELP.VMEMBER where libname="WORK" and memtype="DATA";
%let N=%TRIM(&N);
select distinct memname as name into :N1-:N&N
from SASHELP.VMEMBER where libname="WORK" and memtype="DATA";
quit;
%macro a;
%local i obs;
%global nobs;
%do i=1 %to &N;
proc SQL noprint;
select COUNT(*) as obs into :obs from &&n&i
;quit;
%if &i = 1 %then %let nobs=&obs;
%let nobs=%EVAL(&nobs+&obs);
%end;
%mend;
%a;
%put nobs=&nobs;
[/pre]
Sincerely,
SPR
... View more
Hello Efunk,
Is this what you need?
[pre]
data i;
input date ANYDTDTE10.;
format date YYMMDDP10.;
date1=SUBSTR(put(date,WEEKU9.),1,6);
datalines;
2009.01.05
2009.01.06
2010.01.05
2011.01.05
run;
[/pre]
Sincerely,
SPR
... View more
![SASGF 2020 [Virtual] Attendee](/html/@A53A708409112314CE528E074D4C8C1F/badge_icons/badge_sasgf20_attendee.png "SASGF 2020 [Virtual] Attendee"){kind=icon}
