About japelin

japelin · ‎12-10-2021

you can use -sysin for batch mode. In Task scheduler, - specify the full path of SAS.exe in Program/Script - specify the path of the sas program in -sysin, and the log output destination in -log as arguments, you can run the program in the task scheduler. For example [%PROGRAMFILES%\SASHome\SASFoundation\9.4\sas.exe] in Program/Script box and [-sysin "C:\Temp\test.sas" -log "C:\Temp\test.log"] in parameter box If you want to run multiple programs, you can create a bat file with the following command and register it in the scheduler. %PROGRAMFILES%\SASHome\SASFoundation\9.4\sas.exe -sysin "sasprogram1.sas" -log "logfilepath1.log" %PROGRAMFILES%\SASHome\SASFoundation\9.4\sas.exe -sysin "sasprogram2.sas" -log "logfilepath2.log"

japelin · ‎12-10-2021

The first step, though, is to fix the text date to a number. you can use proc sort with nodupkey and last. variable. data have;/* sample data */ do id=5 to 1 by -1; do i=20010 to 20000 by -1; dt=i+int(ranuni(i)*100); output; end; end; format dt yymmdd10.; drop i; run; proc sort data=have nodupkey; by id dt; run; data want; set have; by id dt; if last.id; run; or Use proc sql proc sql; select * from have as a where dt=(select MAX(dt) from have as b WHERE a.id=b.id); quit;

japelin · ‎12-10-2021

You can use retain statements to achieve this, but if you need specific code, please provide the data in a usable form, not as an image. Maybe the code is something like this. (I haven't tested it because I don't have the data) data want; set biosd.lab_wide; by caseid; retain height; if first.caseid then height=height_cm_; else height_cm_=height; drop height; run;

japelin · ‎12-10-2021

For example, the following code will store the length of the id in the group variable, allowing you to group them. data want; set have; group=length(id); end;

japelin · ‎12-09-2021

If Var1 value is only number, you can use z format. data have; length VAR1 $8; VAR1='56';output; VAR1='152';output; VAR1='7';output; run; data want; length VAR2 $8; set have; VAR2=put(input(VAR1,best.),z8.); run; or use repeat function data want; length VAR2 $8; set have; VAR2=cats(repeat('0',8-length(VAR1)-1),VAR1); run;

japelin · ‎12-09-2021

First, Is birthdate type numeric or character? If it is numeric, 09301999 is handled as 9301999. If it is character, quote is needed. With that out of the way, for the actual code, try the following. data have; birthdate='19881231'; output; birthdate='19670628'; output; birthdate='09301999'; output; run; data want; set have; birthdatewant=input(birthdate,??yymmdd8.); if birthdatewant=. then birthdatewant=input(birthdate,??mmddyy8.); format birthdatewant yymmdd10.;/* date format as you want */ run;

japelin · ‎12-08-2021

try this data sample; datec='04/14/2021'; date=input(datec,mmddyy10.); format date yymmdd10.; run;

japelin · ‎12-06-2021

Why not use the nobom option? filename output3 '\\lXXXX\D_PS.csv' encoding="utf-8" nobom;

japelin · ‎12-02-2021

If you use a SAS that can handle Unicode or DBCS, I think you can do it. For example, SAS Studio, SAS 9.4 (English with DBCS), SAS 9.4 (Unicode support), or SAS 9.4 (Japanese).

japelin · ‎11-25-2021

I know that we can get rid of it by using double quotation marks. I don't want it to be resolved at the time of storing it in the variable res, so I use single quotation marks.

japelin · ‎11-25-2021

Originally, I wanted to create a macro variable by combining the value of the macro variable specified in the parameter with the value stored in the dataset variable. For this reason, I used resolve instead of symget. Besides, even with symget, I encounter a similar problem to the first code I presented.

japelin · ‎11-25-2021

In the following two macro codes (Mtest1 and Mtest2), the process itself looks the same, but when I submit, the macro reference cannot be resolved in Mtest1. %Macro Mtest1(XXX); res=resolve('&XXX'); %Mend; data _null_; %Mtest1(abc); run; %Macro Mtest2(XXX); data _null_; res=resolve('&XXX'); run; %Mend; %Mtest2(abc); I know how to resolve it. All I have to do is change the single quotes to double quotes. (This may not be appropriate in this case, since it eliminates the need for the resolve function.) Anyway. I don't understand why there is such a difference between executing a macro reference in the data step and in the open code.

japelin · ‎11-25-2021

For example, you could try using a different file name once. options noxwait xsync; x 'rename C:\Temp\test.csv text0.csv'; x 'rename C:\Temp\test1.csv text.csv'; x 'rename C:\Temp\test0.csv text1.csv';

japelin · ‎11-11-2021

私の見間違えで、sql_tree じゃなく、sql _tree なんですね（投稿修正しました）。道理でググっても出てこないわけだ。（何れにせよリファレンスにはありませんね。9.1で既にあったみたいですが）テクサポへのバグ報告の際は明確な回答がない場合、米国本社への確認をお願いした方がいいと思います。（こんなことここで言っちゃっていいのかな）バグかどうか、hotfixを出すかどうかの判断は全て米国本社マターのようですので。（回答に納得できるかどうかは別ですが:P

japelin · ‎11-11-2021

同じように動くはずのもの（ここでは関数）が、ものによって細かい内部動作が異なることはあるようです（私はformatで遭遇しました）が、この場合は明らかに結果がおかしいのでバグのような気がします。テクニカルサポートに連絡されてはいかがでしょうか。ところで、proc sql _treeはundocumentedなんでしょうか。初めて聞きました。

Online Status	Offline
Date Last Visited	‎05-06-2023 12:52 PM

Re: Reduce run time

Re: Wrong command

Re: How to find length

Re: Char to numeric

Re: Creating SAS macro (YYYYMM) based on SAS macro (TIMESTAMP)

Re: Sort by datetime

Re: Grouping data

Re: Grouping data

Re: How to code this column (point)?

Re: Protecting data sets using read/write/alter syntax or is there a b...

Re: temp sas dataset

Re: Remove "The SAS System" title from the log (SAS Studio)

Re: SAS AF still alive

SAS AF still alive

Re: How to find largest and second largest values?

Re: Creating SAS macro (YYYYMM) based on SAS macro (TIMESTAMP)

Re: Protecting data sets using read/write/alter syntax or is there a b...

Re: Remove "The SAS System" title from the log (SAS Studio)

Re: How to Include Zero to %Do macro loop

Re: Macro variable was not created

Re: how to execute SAS base code using windows scheduler?

Re: How can we keep the most recent data with proc sort?

Re: Set value at one time point to all time points for each participan...

Re: How to separate those IDs into two parts

Re: char function add left zeroes

Re: How do I get the correct date format and filter out accordingly?

Re: Date entered as 04/14/2021 as character to be converted to date as...

Re: UTF-8 BOOM

Re: How can I create a Japanese language .xpt file from an English lan...

Re: Differences in behavior depending on where the macro reference is ...

Re: Differences in behavior depending on where the macro reference is ...

Differences in behavior depending on where the macro reference is exec...

Re: File name change

Re: proc SQLのmedian関数のバグ

Re: proc SQLのmedian関数のバグ