About japelin

japelin · ‎03-30-2022

This message is displayed because you are using the sum() function, which is normal "The query requires remerging summary statistics back with the original data." And which code remove the negative dollars? Also, when writing code, please paste the code itself in the edit window as "SAS code" and post it, not the code output in the log.

japelin · ‎03-30-2022

try fixing below. delete "and" before "group by". group by rollupeventid, eventDate;

japelin · ‎03-29-2022

First, the macro code is stored encrypted by specifying the /store secure option to the macro. Also, specify options such as nosource nosource2 nomlogic nosymbolgen nomprint when executing the macro. Prevent sas code from being output to the log. This will keep the sas code secret. libname macout 'C:\temp'; options mstored sasmstore=macout; %Macro samplemacro /STORE SECURE; options nosource nosource2 nomlogic nosymbolgen nomprint; /* describe your code below */ %Mend;

japelin · ‎03-21-2022

how about these two codes. proc sql; create table Brooking as select count (CRESIDZIP_EXT), case when( age< 5) then 0 when( 5<=age<14) then 1 when(15<=age<24) then 2 when(25<=age<34) then 3 when(35<=age<44) then 4 when(45<=age<54) then 5 when(55<=age<64) then 6 when(65<=age<74) then 7 when(75<=age<84) then 8 when(85<=age) then 9 else . end as age_group from CLEANED.death2020 group by age_group; quit; or proc sql; create table Brooking as select count (CRESIDZIP_EXT), round(age/10,1) as age_group from CLEANED.death2020 group by age_group; quit;

japelin · ‎03-21-2022

Are the variables m_date and c_date character types? Or is it a numeric type? And what do you want to do with this date in Dutch notation, e.g. 21FEB2022? If it is a character type, you can use the input function to convert it to a SAS date value, and if it is a numeric type, you can apply a different format to display it as desired.

japelin · ‎03-18-2022

First, the first three lines need a semicolon at the end of the line. The second argument of %SCAN must then be an integer representing the position.

japelin · ‎03-17-2022

Can you provide specific samples of the original data and desired results?

japelin · ‎03-17-2022

Use double quotes instead of single quotes when you want to expand macro variables. PUT "unknown contracts: &count_NO_contract"; PUT "unknown sales: &count_NO_sales";

japelin · ‎03-15-2022

If you want to merge, you must do SORT first. proc sort data=apple; by size; run; proc sort data=orange; by size; run; data fruit; merge apple orange; by size; run; Also, you do not need "and" in merge statement. Just describe them space-separated.

japelin · ‎03-14-2022

how about this data have; input Clientid Purchase_Date:mmddyy10. item_name $ amount:dollar4.; format Purchase_Date mmddyy10. amount dollar4.; datalines; 1 01/01/2020 book $20 1 01/01/2020 book $-20 2 03/01/2020 pen $2 3 04/01/2020 game $70 2 03/01/2020 pen $-2 1 06/01/2020 bike $200 ; run; proc sql; create table want as select a.* from have as a left join have as b on a.Clientid=b.Clientid and a.Purchase_Date=b.Purchase_Date and a.item_name=b.item_name and a.amount=b.amount*(-1) where b.amount=.; quit;

japelin · ‎03-14-2022

SAS is processed as a set by submit, from compilation to execution. Basically, it is not possible to compile only. It may be possible to do something similar by using an empty data set. However, syntax errors are detected in the compile phase, but any problems with the dataset or variables are detected as errors in the execution phase, so it is not very useful unless the data is actual data. Therefore, I sometimes test run the program with "obs= system options" or "obs= dataset options" to limit the number of observations before a time-consuming process.

japelin · ‎03-12-2022

Isn't it because the value of EXMWGTU_DEC for the observation EXWGTMD_DEC = 'Actual' is empty?

japelin · ‎03-12-2022

The data you are presenting is exex1 or exex?

japelin · ‎03-12-2022

The force option skips the confirmation message. https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.management/clear-recyclebin?view=powershell-7.2#3--clear-all-recycle-bins-without-confirmation

japelin · ‎03-11-2022

how about this data have; input Client_id Purchase_date:mmddyy10.; format Purchase_date mmddyys10.; datalines; 1 1/02/2020 2 4/02/2020 1 5/02/2020 1 7/02/2020 2 9/02/2020 1 11/02/2020 ; run; proc sort data=have out=sorted; by client_id Purchase_date; run; data want; set sorted; by client_id Purchase_date; retain dt; if first.client_id then do; days_since_last_purchase=0; end; else do; days_since_last_purchase=intck('day',dt,Purchase_date); end; dt=Purchase_date; drop dt; 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: GROUP and WHERE statements

Re: GROUP and WHERE statements

Re: How to save MACRO unviewable to anyone?!

Re: SAS Query

Re: Changing the date from dutch to English

Re: First name last using %scan function

Re: SSN formatting

Re: Variable value does not appear in Email

Re: proc merge

Re: Matching clients with SAS

Re: SAS options

Re: Can someone tell me why the variable "WEIGHT_Actual" is not popula...

Re: Can someone tell me why the variable "WEIGHT_Actual" is not popula...

Re: How to empty recycle bin windows 10 using coding

Re: Calculate number of days since last pruchase for unique clients wi...