About david27

david27 · ‎07-08-2022

Missed asking this question here Very similar question, but put quotes for Horsepower > 250 and NOT put quotes for Horsepower if it does not meet the condition. data _null_; file "/path/output/unix/cars.csv" dsd dlm = ','; set sashelp.cars; if _n_ = 1 then put @1 "Make,Model,Type,Origin,DriveTrain,MSRP,Invoice,EngineSize,Cylinders,Horsepower,MPG_City,MPG_Highway,Weight,Wheelbase,Length"; put Make Model Type Origin DriveTrain MSRP Invoice EngineSize Cylinders Horsepower ~ MPG_City MPG_Highway Weight Wheelbase Length; run;

david27 · ‎07-08-2022

Quick question: Is there a way to conditionally quote the values? For example-- put quotes only if the horsepower is more than 250?

david27 · ‎07-08-2022

To match someone else's output for validation purposes. Why this other person adds quotes around variables that don't need it-- I have no idea.

david27 · ‎07-08-2022

So I do the below, and it quotes some variables when they have a comma in them. I want put quotes on selective column like Horsepower ONLY. Please adivse. data _null_; file "/path/output/unix/cars.csv" dsd dlm = ','; set sashelp.cars; if _n_ = 1 then put @1 "Make,Model,Type,Origin,DriveTrain,MSRP,Invoice,EngineSize,Cylinders,Horsepower,MPG_City,MPG_Highway,Weight,Wheelbase,Length"; put Make Model Type Origin DriveTrain MSRP Invoice EngineSize Cylinders Horsepower MPG_City MPG_Highway Weight Wheelbase Length; run;

david27 · ‎07-07-2022

Thank You @pink_poodle for your reply. But, I also have to handle duplicates.

david27 · ‎07-07-2022

Hello, Below is what I HAVE and what I WANT The problem that i have is the delimiter. I have COMMA inside the column value and also after concatenation, I need to have comma as a separator. In my actual data, these are First Names and Last Names. So if a person's name is repeated, I keep that person's name only once. Please advise. data have; infile datalines dlm="|"; input id n1 :$4. n2 :$4. n3 :$4. n4 :$4.; datalines; 1|a,b| |a,b|d 2|a| | | 3|a,b| |b,d|d 4| |b| |d ; run; data want; infile datalines dlm="|"; input id final $16.; datalines; 1|a,b , d 2|a 3|a,b , b,d , d 4|b , d ; run;

david27 · ‎06-06-2022

Thank You @Tom. I am trying to convert the string into a number and then test if it is larger than twenty. This solves the problem.

david27 · ‎06-06-2022

Hello, Please review the code below. For all the ALPHABETS in the column have_column I get below warning. WARNING: INPUT function reported 'WARNING: Illegal first argument to function' while processing WHERE clause. Please advise as to how can I avoid this warning. /*There is an empty first row*/ data have; input have_column $5.; datalines; 00 02 06 08 10 24 29 30 39 NA AB CD ;RUN; proc sql; create table want as select have_column from have where input(have_column,best.)>=20 ;quit;

david27 · ‎05-25-2022

Team, This is what I have: data have; input have $12.; datalines; 1 2 3 4,5 6,7,8 1 ; run; I want all the values in single macro variable separated by comma(,) want='1','2','3','4','5','6','7','8'

david27 · ‎05-10-2022

Thank You

david27 · ‎05-10-2022

Thank You.

david27 · ‎05-10-2022

Hello, I have this: /*This works*/ proc sql; connect to oracle (user=&usr password=&psswd path=&path buffsize=5000); create table temp as select * from connection to Oracle( select count(*) from schema.table ); disconnect from oracle; quit; But if I add a %include and have the query inside that, then it does NOT work. Why? /*This works*/ proc sql; connect to oracle (user=&usr password=&psswd path=&path buffsize=5000); create table temp as select * from connection to Oracle( %include "/path/to/code/code.sas"; ); disconnect from oracle; quit;

david27 · ‎03-30-2022

Thank You very much @Tom

david27 · ‎03-30-2022

So I have this information: Name of the variable Type( Character / Numeric) Length Format Based on this information, I am required to produce a SAS Dataset with an additional date variable- YearMonth (YYYYMM) We can populate the values inside the variable randomly. The list of variables can be 2, 10 or 50.(var1 , var2, var3.....) HAVE: /*HAVE*/ data have; infile datalines missover ; input varname :$8. type length format $8.; datalines; var1 1 8 var2 1 8 var3 2 8 var4 2 1 var5 1 8 ;run; WANT: YEARMONTH VAR1 VAR2 VAR3 VAR4 VAR5 202002 1 2 A B 5 202003 3 3 C D 6 202004 4 4 E F 7 202005 5 5 G H 8 Please advise. Thank You

david27 · ‎03-11-2022

Why is this index not working? Trying to search for a string inside a variable using index. Index is in a datastep which is inside a macro. %MACRO dev_macro; data class; set sashelp.class; %if %eval(%index(lowcase(name),'a')) > 0 %then %do; result=1; %end; %else %do; result=0; %end; run; %mend dev_macro; %dev_macro; Please advise!! Thank You

Online Status	Offline
Date Last Visited	‎11-22-2024 01:34 PM

Difference in time- minutes.

Last Iteration of do/end not resolving

Re: SQL Into by groups

SQL Into by groups

Re: Dynamic SQL Case When

Dynamic SQL Case When

Write a Temporary SAS Code for a SQL Query

Re: Proc format for negative values

Re: Proc format for negative values

Proc format for negative values

Re: Write a Temporary SAS Code for a SQL Query

Re: Proc format for negative values

Re: PROC Report Conditional Formatting

Re: Time Series Plot with reference line

Re: Time Series Plot with reference line

Remove Comma from Macro number

Re: Display rules in Crosstabs

Selectively/Conditionally put QUOTES around values of a variable

Re: Selectively Quote variables when output them to csv.

Re: Selectively Quote variables when output them to csv.

Selectively Quote variables when output them to csv.

Re: Concatenate Unique Values from Columns

Concatenate Unique Values from Columns

Re: SAS Character to Numeric for ALPHA Numeric Column

SAS Character to Numeric for ALPHA Numeric Column

Create a List from Column

Re: %include inside Oracle Connection

Re: %include inside Oracle Connection

%include inside Oracle Connection

Re: Create Datasets Based on Contents

Create Datasets Based on Contents

Index function inside Macro