About dht115

dht115 · ‎01-12-2022

How to use Loop/macro for following code to reduce lines. I need to subset dataset if var1 eq 0 AND new_var1 <> 0 I have to use this condition for 10 times. data want; set have; where (Var1 = 0 AND New_var1<> 0) OR (Var2 = 0 AND New_var2 <> 0) OR (Var3 = 0 AND New_var3 <> 0) OR (Var4 = 0 AND New_var4 <> 0) OR (Var5 = 0 AND New_var5 <> 0) OR (Var6 = 0 AND New_var6 <> 0) OR (Var7 = 0 AND New_var7 <> 0) OR (Var8 = 0 AND New_var8 <> 0) OR (Var9 = 0 AND New_var9 <> 0) OR (Var10 = 0 AND New_var10 <> 0); run;

dht115 · ‎01-12-2022

I have two separate .dat files and need to create two separate dataset. both .dat files have different name both dataset needs to have different name.

dht115 · ‎01-12-2022

Hello, I have two separate .dat files. I need to import files by using DATA and INFILE statements. Both files have same variables different values. Is there a way for me to import two files so I can use same length, format options (reduce program size).

dht115 · ‎01-12-2022

Hello, I want to sum by variable and use that sum value to calculate additional variable. In following dataset, I need to do sum for var1, which is 10. I need to add this sum value to create var2. var2 = sum + var1 Input dataset: Final result should be: DATA have; input group $ var1; datalines; A 1 B 2 C 3 D 4 ; RUN; PROC SUMMARY DATA=have; var var1; output out=have1 (DROP = _TYPE_ _FREQ_) sum=; RUN; DATA want; set have1; rename var1 = var2; RUN;

dht115 · ‎01-11-2022

I download the code from https://github.com/art297/Papers/blob/master/Excelling_to_Another_Level_with_SAS/src/exportxl.sas Getting an error: ERROR: Undetermined I/O failure.

dht115 · ‎01-05-2022

How to obtain today's date in YYYY Month (ex. 2022 January) format? %let today = %sysfunc(today()); %put &today;

dht115 · ‎01-05-2022

In following example, I want to assigned test1 value to try1, test2 value to try2, test3 value to try3. DATA have; input IDnumber $ test1 test2 test3; datalines; aa 1 0 0 bb 0 0 0 cc 0 0 1 dd 1 1 1 ; RUN; DATA want; set have; array try {3}; RUN; I tried following, but did not work. Data want; Set have; Array try(3) test1-test3; Run; Desire output should be:

dht115 · ‎12-30-2021

I need to use historical data to calculate forecast.

dht115 · ‎12-30-2021

This will create all future qtr based on the date. I also need to create variable name - not the observation.

dht115 · ‎12-30-2021

Hello, I have following code and I need to create 19 addtional variables by using today's date (total 20 qtr info) by using 'fyqt1' variable (current qtr info). Desire output should have Qtr 2-2017 to Qtr 1-2022 result. This should auto change when I run this code in month of Jan or Apr. DATA have; format todaydt mmddyy10.; todaydt= date(); *call symput('todaydt',trim(left(input(todaydt,mmddyy10.)))); fy = catx('/',year(todaydt),year(todaydt)+1); fyqt = qtr(datepart(todaydt)); calyr = year(todaydt); calqt = catx('-',qtr(todaydt),year(todaydt)); fyqt1 = catx('-',qtr(datepart(todaydt)),year(todaydt)+1); var = cat('QTR-', substr(fyqt1, 1) ); run; desire result:

dht115 · ‎12-22-2021

Still no luck

dht115 · ‎12-22-2021

Still I am having an error. I am using following logic: if &var2. contains "try1" then where var2. ne 0; else where var2. > 0;

dht115 · ‎12-22-2021

Hello, I do need to subset my dataset by two different condition. I am getting LINE and COLUMN cannot be determined error. /*Create dataset*/ %macro prob(var1=, var2=); data demand&var1.problem; set qul.test0; /*Need to use two seperate where condition to subset data based on var2 value*/ if var2. contains "try1" then where var2. ne 0; else where var2. > 0; run; %mend; %prob(var1=Fcst, var2=test_try1); %prob(var1=sd, var2=test_test);

dht115 · ‎12-22-2021

Hello, I am trying to create multiple tables by using the SAS macro. /*Create test_a and test_b tables by using the sas macro*/ /*test_a should keep only type variable in the output*/ /*test_b should keep only make variable in the output*/ %macro test1(test=, req=); data count_by_"&test1."; set sashelp.cars(keep= req.); run; %mend; %test1(test=test_a, req=type); %test1(test=test_b, req=make);

dht115 · ‎12-20-2021

Thank you it works.

Online Status	Offline
Date Last Visited	‎06-24-2023 07:38 PM

Re: sas import excel give issue to convert numeric value

sas import excel give issue to convert numeric value

Re: choose all file name for macro variable by using loop

choose all file name for macro variable by using loop

Create variable that counts progressively how many times variable repe...

Validate left join result

Count distinct for multiple tables

create table for sas observation

SAS Merging two dataset by using Proc SQL

SAS Proc steps with the data step

sas program loop/macro

Re: import multiple .dat files in one step

import multiple .dat files in one step

Use Sum value by variable to calculate additional information

Re: How to retain the Variable Format when PROC EXPORT TO EXCEL

date format in data _null_

assign variable values to array variable

Re: create variable by using array

Re: create variable by using array

create variable by using array

Re: sas macro - subset dataset if variable contains string

Re: sas macro - subset dataset if variable contains string

sas macro - subset dataset if variable contains string

SAS macro - to creating multiple tables

Re: infile statement with macro