About 1239

1239 · ‎04-12-2023

Hi andreas, Thanks for this code and it worked.

1239 · ‎04-11-2023

Hi, I am using EG running SAS 9.4 version and need to know is they any SAS function to sort a value within variable or any other way to achieve the desired output shown below. Thanks for your help. Input raw value - X = D; K; B; S; O Desired output value - X = B; D; K; O; S

1239 · ‎11-23-2022

Thanks for the code however Row # 4 WHEATGRAIN WHEAT-GRAIN didn't pull from your code. Only last row shouldn't be pulled but rest of the rows should be pulled.

1239 · ‎11-23-2022

Hi, I am trying to find the values when Name1 contains Name2 values then it should output however I am not able to find out either with FIND or INDEX functions. Please help in getting the output. I want all the records as matching except last record. data test1; input Name1 $12. Name2 $25.; datalines; ORANGE APPLE APPLE OATS WHEAT WHEAT WHEAT GRAIN GRAIN WHEATGRAIN WHEAT-GRAIN WHEAT-GRAIN WHEAT APPLE ORANGE ORANGE WEAT ORANGE GRAIN ; run;

1239 · ‎10-21-2022

Hi All, I have the below dataset with exponentiation values in variable 'a' and I want to filter the particular value ( 6.7705698E14 ) in the dataset and how do I apply where condition or if statement to pull 6.7705698E14 ? Thanks for your help in advance! data test; a=6.5693077E14; output; a=6.7705698E14; output; a=6.8283942E14; output; a=6.5693077E14; output; a=6.7705698E14; output; a=6.8283942E14; output; run;

1239 · ‎05-27-2022

Hello @sbxkoenk, I use SAS 9.4 M6. Thanks for all your help and I appreciate it!

1239 · ‎05-27-2022

Hello @Tom Your code works now and earlier it didn't work because that I was trying your code and @sbxkoenk code and dataset names were same. Thanks for your help!

1239 · ‎05-26-2022

Hello @sbxkoenk, Please see the PROC PRINT below and extra "," is present in obs = 2 and 3. data have; LENGTH A B C D E $ 2; infile datalines delimiter='#'; input A $ B $ C $ D $ E $; datalines; AB #CD # EF #GH #IJ #MN # #QR #ST # # EF #GH #IJ AB # # EF # # ; run; data want; LENGTH concat1 $ 10 concat2 $ 10 concat $ 20; set have; sp1=', '; sp2='@'; concat1 = CATX(SP1, A, B); concat2 = CATX(SP2, C, D, E); if strip(concat1) ^= '' then do; concat = strip(concat1)!!', '!!strip(concat2); end; else do; concat = strip(concat2); end; concat=compress(concat,'@'); run; proc print data= want; run;

1239 · ‎05-26-2022

@sbxkoenk and @Tom The code will result as " , MN, QRST" but I need MN, QRST. I don't want additional "," when data is empty. Please refer desired output value.

1239 · ‎05-26-2022

Hi, I need to apply delimiter (",") only when data is present in A and B but not for C, D and E variables. I am trying the below code but unable to achieve the desired output values. Kindly refer below SAS code, input data (.csv file attached) and desire output. Please help me in achieving the desired output value. data need; set have; V = cats(V1, ",", V2, ",", V3, V4, V5); run; Input data: A B C D E AB CD EF GH IJ MN QR ST EF GH IJ AB EF desired output value AB, CD, EFGHIJ MN, QRST EFGHIJ AB, EF

1239 · ‎02-18-2022

Hi All, I am trying to find out Non missing from both Character and Numeric Data Type and then overwrite date as shown below from SAS 9.4 EG. I wanted to know is there any simple code to achieve quickly as I have this kind of requirement for multiple datasets? Thanks for your help! data want; set test; if missing(bsasdt) and (not missing(bsdostr) or not missing(bsdorea_1) or not missing(bsdorea_2) or not missing(bsdorea_3) or not missing(bsdorea_4) or not missing(status)) then bsasdt = created_dt; else bsasdt = bsasdt; run; SAS Attributes of Test dataset shown below:

1239 · ‎11-23-2021

Hi, Thanks for your help. Your code also working but I couldn't explore more on PRXCHANGE function.

1239 · ‎11-22-2021

Hi, I am trying to find out is there any way to achieve final output in a better way wherein I need to pull the middle value between first and last delimiter. For example: final = ABC -DEF -IJKL data test1; x='014-ABC -DEF -IJKL -20 NOV 2019'; run; data test2; set test1; y = substr(x, 1, index(x, "-")); yl = length(y)+1; y6 = substr(x, yl); y2 = scan(y6, -1, "-"); y2l = length(y2)+1; y3l = length(y6)-y2l; final = substr(x, yl, y3l); run;

1239 · ‎11-12-2021

Hi All, How to change the date&time fromat from 09SEP21:00:00:00 to 09-SEP-2021 00:00 (DD-MMM-YYYY HH:MM). Please help.

1239 · ‎09-08-2021

Hi, I am trying to import .csv with pipe delimiter where some of the values are converting into question mark symbol and I am not sure whether this unicode character issue or some other. Could you please review the below code along with sample file and help me in importing this .csv pipe delimiter file with values correctly as currently output value mm² is read as mm� filename temp "C:\Test.csv" encoding="utf-8"; PROC IMPORT OUT=test DATAFILE= temp DBMS=DLM REPLACE; DELIMITER='|'; GETNAMES=YES; DATAROW=2; GUESSINGROWS=MAX; RUN;

Online Status	Offline
Date Last Visited	‎04-12-2023 03:15 AM

Re: sorting value within a variable

sorting value within a variable

Re: Search matching character values

Search matching character values

How to filter exponentiation values in sas dataset

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

how to apply delimiter based on condition

Re: sorting value within a variable

sorting value within a variable

Re: Search matching character values

Search matching character values

How to filter exponentiation values in sas dataset

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

Re: how to apply delimiter based on condition

how to apply delimiter based on condition

how to I find out Non missing from both Character and Numeric Data Typ...

Re: pull the middle value between first and last delimiter

pull the middle value between first and last delimiter

Reformatting of Date (DD-MMM-YYYY HH:MM) format

how to read .csv with pipe delimiter data correctly in proc import