About japelin

japelin · ‎09-01-2021

try using ifn function. for example x=y-ifn(missing(z),0,z);

japelin · ‎09-01-2021

I just took the test two weeks ago. At that time, I had no problem with this libname statement. I also used traditional SAS, not EG or SAS Studio. It is strange that nothing appears in the log. In the test, you are supposed to be logged into a virtual environment, so the key assignments were different and sometimes did not work properly. For example, the code was not submitted when I pushed the F3 key. If you don't see anything in the log, it means that the code may not have been submitted, so unfortunately, the only advice I can give you is to press the submit button and try to run it. I wish you the best of luck.

japelin · ‎09-01-2021

What do you mean it didn't work? Can you be more specific? What are the logs in SAS? Has a library been assigned, does the library have a dataset, can you open the dataset?

japelin · ‎09-01-2021

like this? As far as I know there is no way to do this, but please let me know why you want to do it that way. I'm interested. (The image above is just a variable label with a space in it.)

japelin · ‎09-01-2021

Perhaps libname statement was needed is this. libname cert 'c:\folder\subfolder'; You may want to take a practice exam first by visiting the following. https://vle.sas.com/course/view.php?id=436

japelin · ‎09-01-2021

try changing follows. %let id = %sysfunc(open(trans.loss)); %let close_flag = %sysfunc(close(&id)); ↓ %let dsid = %sysfunc(open(trans.loss)); %let close_flag = %sysfunc(close(&dsid));

japelin · ‎09-01-2021

data want; set have; array q{*} q_:; do i= dim(q) to 1 by -1; if q{i} ne . then last_value=q{i}; if q{i} ne . then leave; end; drop i; run; If possible, I would like a few obs of large datasets to check my code works or not.

japelin · ‎09-01-2021

how about this code? data want; set have; array q{*} q_:; do i=1 to dim(q); if q{i}=. then leave; last_value=q{i}; end; drop i; run;

japelin · ‎09-01-2021

First, since cats is a function that can only be used within the data step, change it as follows data _null_; call symputx('file_path',cats(&csv_location, &csv_file)); run; Then, the semicolon after proc import datafile= is unnecessary. Also, double quotation marks are necessary because we are concatenating the filepath string in the data step. proc import datafile= "&file_path" Finally, let's first create the code that works correctly without macro variables before starting macro coding. The following options are useful for debugging macros Please refer to them. options mprint mlogic symbolgen;

japelin · ‎09-01-2021

I think you can use SASAUTOS to make automatic calls. One more thing. I would also suggest using stored macros. You will have to rewrite the macro code a bit, though. You can consolidate your macros into one catalog for each category, or you can combine all of them into one macro catalog if they don't have the same macro name. LIBNAME mylib 'C:\temp'; OPTIONS MSTORED SASMSTORE=mylib; %MACRO msample /STORE;/* Macro stored in mylib.SASMACR */ /* Macro code */ %MEND msample; when next SAS session. LIBNAME mylib 'C:\temp'; OPTIONS MSTORED SASMSTORE=mylib; %msample;/* not %include need! */

japelin · ‎09-01-2021

For example. proc sql; create table c as select a.*, b.* from a left outer join b on (a.key=b.account_num and b.account_num ne .) or (a.key=b.card_num and b.card_num ne .) ; quit;

japelin · ‎09-01-2021

First of all, could you please present the usable data?

japelin · ‎09-01-2021

how about this code? data next; set have; catc=scan(category,1); if upcase(catc)='ALL' then catn=99; else if upcase(catc)='LESS' then catn=1; else if upcase(catc)='MORE' then catn=90; else catn=input(scan(category,1,'-','A'),best.); drop catc; run; proc sort data=next out=want(drop=catn); by catn; run;

japelin · ‎08-31-2021

I think it's Base SAS.

japelin · ‎08-31-2021

Why do you specify any for encoding= dataset option? ANY specifies that no transcoding occurs, so I think this is what is preventing it from displaying correctly. Try to submit the following code. data "&output_path" (compress=yes); set work.&dataset_name; 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: How do I replace . (missing) with 0 in a Aggregated Mesaure?

Re: SAS Certification exam, A00231, Base Programming

Re: SAS Certification exam, A00231, Base Programming

Re: Variable name from horizontal to vertical in sas dataset (not in p...

Re: SAS Certification exam, A00231, Base Programming

Re: sysfunc crdte error

Re: How to get the last value?

Re: How to get the last value?

Re: Creating a macro that reads CSV

Re: Including Macros - Autocall library, how to do it step by step?

Re: How to join two datasets when the joining key has mixed values fro...

Re: base sas programming

Re: Order char values

Re: Which essentials module covers error handling?

Re: SAS Universal Viewer Support For Japanese/Chinese or UTF-8 Chars.