About japelin

japelin · ‎03-02-2022

Excuse me, but have you been able to isolate whether it is really a problem with the password string, or with your sas account, or with the site you are trying to access with proc http? If it is a problem with the special symbols in the password, are you double coating the password when specifying it in proc http? Why don't you use single quotation marks? Use single quotation marks when you don't want to expand or reference a macro.

japelin · ‎03-02-2022

I think it's because fund_arng_cd is a character variable, but the format is "3.". Try modifying it to "$3.".

japelin · ‎03-02-2022

call symput can store the value of a variable into a macro variable in the data step In the following, the value of Alfred's SEX is stored in the macro variable "MACRO_SEX". data sample0; set sashelp.class; if(name='Alfred')then do; call symput('MACRO_SEX',SEX); end; run; %put &=MACRO_SEX; Please note that there are statements and functions for put and input. The put function converts a numeric variable to a character variable, and the input function converts a character variable to a numeric variable The put statement outputs the value of a variable to a log or file, and the input statement imports the value specified in a file or datalines. Convert age to character with put function data sample2; set sample1; AGE_N=input(AGE_C,3.); run; Converting characters to numbers with the input function data sample1; set sashelp.class; AGE_C=put(age,3.); run; Output name and age to the log with put statement data sample3; set sashelp.class; put name age; run; Converting Values Described in Datalines into Data Sets with the input Statement data sample; input name $ age; datalines; ALFRED 14 ALICE 13 ; run;

japelin · ‎03-01-2022

I think it is because the number of rows generated from the following two sql is different. Try to run it by adding source_var to group by. proc sql; create table max_lengths_ds_1 as select max(var_length) as max_length from input group by dataset,varible,lable; quit; proc sql; create table max_lengths_ds_2 as select dataset,variable,label,source_var from input group by dataset,varible,lable; quit;

japelin · ‎02-28-2022

how about this. Use put statement with @. data have;/* sample */ length vars $32759; do i=1 to 5; vars=put(i,best.); output; end; drop i; run; filename out temp ; data _null_; set have; file out LRECL=163795; put vars @; run;

japelin · ‎02-27-2022

First of all, can you tell me exactly what kind of data you want to derive from what kind of data? Not inaccurate data steps.

japelin · ‎02-27-2022

Try to increase "." after "&i.". proc export data=ds(where=(name="&&names&i..")) outfile="/home/u35263349/My_Folder/&&names&i...xlsx" dbms=xlsx replace; run; %end;

japelin · ‎02-27-2022

The SAS code can be pasted using the "Insert SAS Code" icon on the editing screen for easier viewing. What is the "NAME" you are referring to? I can't determine it from the code alone; please paste the data in a usable format, such as a data step using datalines or as an attachment. Please add a more specific description what you want to do.

japelin · ‎02-27-2022

First of all, the data step you presented does not work correctly, please correct it to the correct one. If you want to find a string, you can use the find function. if(find(diseaseName,'cervical','I'))then newcode=code;

japelin · ‎02-26-2022

I don't think this is relevant to SAS too much, so I'll be brief. Instead of using a username/password combination, why not use an app password? https://support.google.com/mail/answer/185833?hl=en

japelin · ‎02-26-2022

首先，如果有日志，请公布该日志信息。日志对于排除故障至关重要。同时，你可以尝试卸载和重新安装该软件。

japelin · ‎02-25-2022

use noxwait option. options noxwait;

japelin · ‎02-24-2022

SAS has nothing to do with it, it's a matter of tar usage. I recommend that you first make sure that tar can be handled properly at the command prompt without using x statement, and then implement it with sas. I don't know, I haven't tried it, but the -C option of the tar command may not be supported except for the system drive. In that case, you can use the cd command and execute the following beforehand. cd /D e:\outsas So, if you want to write it in one line, it would look like this cd /D e:\outsas & tar -zxvf e:\20210618.tar.gz index_md_20210618.csv Give it a try.

japelin · ‎02-04-2022

try this code. data want; set example; length score measure 8; array sc{3} score1-score3; array ms{3} measure1-measure3; do i=1 to dim(sc); score=sc{i}; measure=ms{i}; output; end; drop i score1-score3 measure1-measure3; run; proc sort data=want; by score; run;

japelin · ‎02-02-2022

how about this data want; set have; dmy=intnx ('month',mdy(month,1,year),0,'E'); format dmy date9.; run;

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: Sas Internal account password including special characters

Re: ERROR: Character expression requires a character format

Re: call symput

Re: How to remove Note : The query required remerging summary statisti...

Re: Export table in one row file

Re: How to find a string within another string and then grab the value...

Re: Export each observation from a dataset using macros do loops

Re: How i can count the name many times in SAS?

Re: How to find a string within another string and then grab the value...

Re: Gmail to suspend 3rd party access soon: SAS email alternatives?

Re: 软件安装

Re: How to unzip file into a specific directory

Re: How to unzip file into a specific directory

Re: How to combine multiple columns into one in the same dataset?

Re: Convert year and month columns to a date in one column