About surajmetha55

surajmetha55 · ‎12-09-2024

@FreelanceReinh , Thank you. Perfect solution

surajmetha55 · ‎12-04-2024

Hi all, I have a data as follow: Make Model Type Origin DriveTrain MSRP Variable_list Acura MDX SUV Asia All $36,945 Make, Model, origin Acura RSX Type S 2dr Sedan Asia Front $23,820 Make, Model, Type, origin It has a variable called Variable_list (It has list of variable comma separated) I want to fetch value of each variable and store in one variable as show below dataset for variable " Variable_value" Expected output: Make Model Type Origin DriveTrain MSRP Variable_list Variable_value Acura MDX SUV Asia All $36,945 Make, Model, origin Acura, MDX, Asia Acura RSX Type S 2dr Sedan Asia Front $23,820 Make, Model, Type, origin Acura, RSX Type S 2dr, Sedan, Asia

surajmetha55 · ‎01-21-2022

I want to pass multiple value to one macro parameter. %macro cardataset (carlst=); data new; set sashelp.cars; if make in(&carlst); run; %mend cardataset; %cardataset(carlst="Audi","BMW","Ford") When I am trying to run above macro, I get following error Statement is not valid or it is used out of proper order. ERROR: All positional parameters must precede keyword parameters.

surajmetha55 · ‎09-07-2019

Thank you for replay. Trying 'getnames=no' just changed Variable name. Do you bring data text manually or programaticaly, if yes can you share program or give some hint. Even I tried using SAS import wizard but it is also not helping me out.

surajmetha55 · ‎09-06-2019

Dear all, I am trying to import Excel file using 2 different program and also tried using SAS import wizard but non of them help me out : Program 1: proc import datafile="W:\auto\Trial.xlsx" out = T dbms = xlsx ; sheet="TI"; getnames=yes; run; gives all observation but warning message in log : WARNING: Some character data was lost during transcoding in column: IETEST at obs 3. Program 2: libname sur pcfiles path="W:\auto\Trial.xlsx" ; data ag; set sur.'Ti$'n; run; Both of the program are not able to read "β" (Beta-symbol) and superscript number come to base. Can you please help me to deal with importing "xlsx" without changing special character. Sample excel data

surajmetha55 · ‎07-20-2019

Dear All, I want to extract all dates from term variable: The data in term vriables is: Days of 08 April 19 count on 10 May 2019, 05 May 2018, 08-Jan-2005 apply i.e. 08 April 19 and 10-Jan-2005 I want ro extract all dates from above variable, in one or multiple vriables using regex or perl regular expression I tried the following program but I am geting only last date data cd.new; set cd.Date_ex; dsdate=prxchange('s/.*(\d{2}(\s+|-)\w+(\s+|-)\d{2,4}).*/\1/', 1, term); run; Output: 08 April 19 08-Jan-2005 10-Jan-2005

surajmetha55 · ‎06-18-2019

You need not, need to Install R in your PC. You can directly use it on cloud platform. See the following link, might be helpfull. link: https://rstudio.cloud/

surajmetha55 · ‎05-22-2019

Tried with following changes but getting same output as shown in above screen shot. (two consecutive digits and greater then two consecutive digits ) where prxmatch('/\d{2}\s*$/',Value);

surajmetha55 · ‎05-21-2019

I am trying following code: data new; input id Value $; datalines; 1 50 2 1 3 500 4 56 5 1000 ; run; data new1; set new; where prxmatch('/\d{2}/',Value); run; After submitting above code, I am getting following output: According to following documentation https://support.sas.com/resources/papers/proceedings/proceedings/sugi29/265-29.pdf Expected output: id Value 1 50 4 56 But in output I am getting 2 digit number and greater then 2 digit number even-though my pattern is only for 2 digit number

Online Status	Offline
Date Last Visited	‎12-16-2024 02:59 PM

Re: Call the value for list of variables

Call the value for list of variables

Give multiple value to macro parameter

Re: Importing Excel file in SAS having special character

Importing Excel file in SAS having special character

Extracting multiple matched pattern from dataset

Re: Need to extract data from pdf file

Re: prxmatch, maximum number of matches not working

prxmatch, maximum number of matches not working

Re: Call the value for list of variables

Re: prxmatch, maximum number of matches not working

Re: prxmatch, maximum number of matches not working

Re: prxmatch, maximum number of matches not working

Re: Call the value for list of variables

Call the value for list of variables

Give multiple value to macro parameter

Re: Importing Excel file in SAS having special character

Importing Excel file in SAS having special character

Extracting multiple matched pattern from dataset

Re: Need to extract data from pdf file

Re: prxmatch, maximum number of matches not working

prxmatch, maximum number of matches not working