Hello, I am using the following code to write a text file; DATA _NULL_;
SET HAVE;
FILE 'pathofthefile/nameofthefile.txt' encoding="utf-8";
IF =_N_=1 THEN PUT 'TITLE OF THE FILE';
RUN; I check with notepad++ that the file is encoding in UTF-8 with BOM. I need it to be encode in UTF-8 without BOM Do know if it exists any option to achieve that . Thank You.
... View more
Hello I have the following data: DATA HAVE;
enfile cards turnover;
input columnA $ columnB $ columnC $;
datalines;
AAAA aaaa hello1
BBBB bbbb hello2
CCCC cccc hello3
DDDD dddd hello4
EEEE eeee hello5
;
RUN; I want to add a column representing the leading ColumnA; And have something like: DATA WANT;
enfile cards turnover;
input columnA $ columnB $ columnC $ leadingcolumnA $;
datalines;
AAAA aaaa hello1 BBBB
BBBB bbbb hello2 CCCC
CCCC cccc hello3 DDDD
DDDD dddd hello4 EEEE
EEEE eeee hello5
;
RUN; When I do DATA want;
merge have have(firstobs=2 Rename=columnA=LeadingColumnA);
run; It shifted the ColumnB and ColumnC as well, which is not what I want. Do you have any Idea how to do that ? Thank you
... View more
Hello I would like to remove the character located a the Second position of a string in the character variable IDCODE. Do you know how to do that ? Thank you.
... View more
In fact I use information of TABLEA conditionally on some information present in TABLEB. This information from TABLEA is then transformed using TABLEB information a stored in a TEMP Table at each stage of the loop, that is then append to a FINALTABLE. The only way i found to do that is using macrovariables to keep information in memory when going from one table to the other, does this seems correct for you ?
... View more
Hello I have a data set that consist of a column, 2 consecutive obs can have the same value just the second has a '/' DATA HAVE;
INPUT COLUMN $200;
DATALINES;
AAAA
BBBB
/BBBB
CCCC
DDDD
EEEE
/EEEE
FFFF
/FFFF
GGGG
;
RUN; I want to build a program that check if 2 consecutive rows have the same value and delete both. To have : DATA WANT;
INPUT COLUMN $200;
DATALINES;
AAAA
CCCC
DDDD
GGGG
;
RUN; Do you have any idea how to do that ?
... View more
All rows, but one row at a time, one single row at each stage of the loop and using 5 columns/variables for every row. I am using SAS EG GRID running on server, can it be a reason for slowness ?
... View more
%MACRO MYPROGRAM;
%LET I=1;
%DO %WHILE (&i<200)
DATA _NULL_;
SET TABLEA;
IF _N_=&i THEN CALL SYMPUT('MACROVARIABLE',VarThatINeed);
RUN;
DATA TEMP;
SET TEMP;
VARIABLE=SYMGET('MACROVARIABLE');
RUN;
PROC APPEND BASE=TABLEWANT DATA=TEMP;
%LET &I=%EVAL(&i+1)
%MEND; I am pretty sure the IF in the data step is not efficient, is there a way to point directly to i th observation without using " if _n_=&i " ?
... View more
What can I change in this code to avoid unitialized variables : DATA TEMP;
LENGTH VARIABLE1-VARIABLE10 $200;
OUTPUT;
RUN; By doing this i want to "initialize" the TEMP TABLE before adding values later in the macro program, but I feel that it's wrong. What do you think ?
... View more
Here is a simplified version of what I do : %MACRO MacroProgram; %let i=1; data TableWant; Lenght Variable1 $200; run; %DO %WHILE (&i<150);
data _null_;
set TableA;
if _N_=&i then
call symput('MacroVariable',SomeVariableFromTableA)
run;
data TEMP;
VariableTableTemp=&Macrovariable;
run;
Proc Append base=TableWant data=TEMP; %let i=%eval(&i+1); %mend; There is a 45000+ notes in the log saying: -that some variables are uninitialized; -some numeric values have been converted ro characters values; Maybe this is the reason why it takes time.
... View more
Hello I built a program that perform two nested loop in a pretty large table; the program takes a lot of time to be run. At some point SAS EG alerted me that the log was to big, and that the log will not be printed. After the message appeared the program started to run faster. Can I speed up my program by not printing the log ? If yes was is the option to do that ? Is there any other way to speed up a program? Regards
... View more
Hello, I have formated a DATETIME: DATA _null_;
now = datetime();
format now e8601dt19.;
put now=;
run; Now I would like to store the formatted date time in a macrovariable as text such that when I call the following: %put &DATETIME; I get: 2019-05-20T12:23:04; Do you have any idea about how to do that ? Thank you
... View more
Hello, Do you know if it exists a DATETIME format such like YYYY-MM-DDThh:mm:ss (note the 'T' between time and date), and if not how to create this format with functions. Thank you, Regards, Hugo_B.
... View more
