About r_behata

r_behata · ‎05-26-2021

Try This : filename myfile email to=() cc=() subject="" attach=(""); data _null_; file myfile; if _n_=1 then do; put ' '; put ' <Insert Email Body Here >'; put ' '; put ' Thanks!'; end; run;

r_behata · ‎05-20-2021

I would suggest that you to start a new thread for the issues you are facing as a consequence of renaming the original variables in your existing code. Please provide some samples.

r_behata · ‎05-19-2021

Works fine with a small modification. The before and after variable name should be different. %macro rename(lib,dsn,prefix); data _null_; if _n_=1 then call execute("proc datasets library=work nodetails nolist; modify &dsn; rename "); set sashelp.vcolumn(where=(libname="%upcase(&lib)" and memname="%upcase(&dsn)")) end=last; vlength=length(name); if vlength>25 then do; /*Taking out underscores to shorten the vbl name*/ put '1. Before: ' name= vlength=; newname=compress(translate(trim(name),'','_')); put '1. After: ' newname= vlength=; end; call execute(catt(name,'=&prefix._',newname)); if last then call execute(';quit;'); run; %mend rename; %rename(WORK,case6,CI) 1 + proc datasets library=work nodetails nolist; modify case6; 1 + rename 2 + _Diagnosis_Date_time__Associated=CI_DiagnosisDatetimeAssociated 3 + ; NOTE: Renaming variable _Diagnosis_Date_time__Associated to CI_DiagnosisDatetimeAssociated. 3 + quit;

r_behata · ‎05-19-2021

If you want to remove both the hyphens and backslashes. Try : disch_disp=compress(disch_disp, "/-");

r_behata · ‎05-18-2021

Data Facility; infile datalines delimiter='|'; input FacilityName :$20. FacilityAddress :$20. FacilityServices :$20.; datalines; Skybuilding1|123 Main St|Cardiology Skybuilding1|123 Main St|Oncology Skybuilding2|124 Main St|Primary Care Skybuilding2|124 Main St|Primary Care Meadowsbuilding3|125 Main St|Radiology Meadowsbuilding4|177 Fake St|Dermatology ; run; proc sort data=Facility; by FacilityName FacilityAddress ; run; data want(rename=(FacilityServices_=FacilityServices)); length FacilityServices_ $100.; FacilityServices_=''; do until(last.FacilityAddress); set Facility ; by FacilityName FacilityAddress ; FacilityServices_=catx(',',FacilityServices_,FacilityServices); end; drop FacilityServices; run;

r_behata · ‎05-18-2021

Which version of SAS are you using ? Have you explored the SAS Environment Manager. https://support.sas.com/resources/papers/proceedings15/SAS1520-2015.pdf

r_behata · ‎05-18-2021

Try using SQL Server syntax inside Pass-thru query. PROC SQL ; CONNECT TO odbc(dsn = 'xxxx' user = xxxxx pw = xxxx); CREATE TABLE birds.pn01a AS SELECT * FROM connection to odbc ( SELECT TOP 100 c.ELG_CUSTOMER_BUS_KEY AS Customer_Id, p.PRODUCT_CATEGORY_NAME, p.PRODUCT_BRAND_NAME, p.PRODUCT_SUB_BRAND_NAME, p.product, f.DATE_KEY, CONVERT(TIME,f.transaction_date) as time_, f.transaction_date, f.transaction_hour, f.transaction_minute, f."BET AMOUNT" AS Bet_Amt, f."NET SALES AMOUNT" as Net_Sales, f.transaction_cnt AS Games_Played

r_behata · ‎05-18-2021

I am not quite sure how you want these rows to be represented in your output. They seem to be having different dates unlike the first sample you have shown. 1 b 8 3 4thjan 6 1 b 8 3 5thjan 7 Would you like the y_score, y_date to be converted as Y_Score1,Y_Score2...YScoren and Y_date1,Y_Date2...Y_Daten ?

r_behata · ‎05-18-2021

@Nrjn7 The code can be slightly modified to adjust to your needs. Have you tried running the code with your actual data to see what happens ? The sample output you have shown has fixed columns such as : x_score1,x_score2. If your data has more than 2 events , say 5 or 10 does the output columns needs to change accordingly. If yes, show us some samples.

r_behata · ‎05-17-2021

Here is one way : data want(rename=(x_tpoint_=x_tpoint)); array x_date_[3] $ x_date1- x_date3; array x_score_[3] $ x_score1-x_score3; x_tpoint_=.; do _n_=1 by 1 until(last.id); set have; by id; x_date_[_n_]=x_date; x_score_[_n_]=x_score; if x_tpoint ^=. then x_tpoint_=x_tpoint; end; keep ID x_tpoint_ x_date1 x_date2 x_score1 x_score2 dis_date y_tpoint y_score y_date; run;

r_behata · ‎05-15-2021

Running a proc contents on the dataset will reveal the answer for you. Data Set Name SASHELP.CARS Observations 428 Member Type DATA Variables 15 Engine V9 Indexes 0 Created 10/24/2018 21:22:18 Observation Length 152 Last Modified 10/24/2018 21:22:18 Deleted Observations 0 Protection Compressed NO Data Set Type Sorted YES Label 2004 Car Data Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64 Encoding us-ascii ASCII (ANSI)

r_behata · ‎05-14-2021

IMO, changing pt_discharge from numeric to character is not necessary here. You may recode this using Formats. Untested code : proc format; value $ recode -999 = "missing2" 12 = "homeH" 11 = "hospice" 10 = "otherD" -9 = "missing" -7 = "unknown" -5 = "invalid" 9 = "otherH" 8 = "dead" 7 = "court" 6 = "long" 5 = "short" 4 = "LAMA" 3 = "admit" 1 = "home" ; run; proc sql; create table pt_discstat as select *, put(pt_discharge,$recode.) as pt_recode from pt_discharge_x where pt_discharge in (-999, 12, 11 ,10, -9 ,-7 ,-5, 9, 8, 7, 6, 5, 4, 3, 1); quit;

r_behata · ‎05-14-2021

data have; input id event $ date :mmddyy10.; format date mmddyy10.; datalines; 1 6_W 12/03/2020 1 8_W . 2 6_W 04/07/2012 2 8_W . 3 6_W 05/08/2012 3 8_W . 3 10_W . ; run; data want; set have(where=(event='6_W') in=a) have(in=b keep=id event) ; by id; if a then event='S_1'; run;

r_behata · ‎05-13-2021

data have; input ID $ VALUE $; infile cards truncover; cards; ABC 2 CDE EEA 2,3 AWE 4,5,6 DDE 5 QWE WQE 5,3,2 ; run; data want; set have; count=ifc(^ missing(VALUE),left(countw(VALUE,',')),''); run;

r_behata · ‎05-13-2021

Try : newvar = compress(catx(',', of a1-a100),'.');

Online Status	Offline
Date Last Visited	2 weeks ago

Re: Conversion of SAS Code to Python

Re: Count based on ID

Re: How to apply row level security on Page in SAS VA 7.5?

Re: RETAIN and impute

Re: How do I select one row based on max value with more than one grou...

Re: Keep all variables from dataset when using proc summary

Re: Calculating age from birthdate in YYYYMMDD format

Re: Proc report column header indentation

Re: Create a temp table in Postgres DB

Re: Perl regular expression to get number between PT and either M or H

Re: Remove every row for an ID if on every row for that ID all 3 varia...

Re: Extract tables

Re: PROC SQL - Include zeros in totals

Re: Long to wide

Re: SET data sets and retain values

Re: Support WITH clauses in SQL

Re: Saving Start and End Time to Dataset

Re: File locked by another user

Re: Calculating age from birthdate in YYYYMMDD format

Re: Perl regular expression to get number between PT and either M or H

Re: How to embed a output in email body

Re: Renaming variables through a macro

Re: Renaming variables through a macro

Re: compressing hyphens and slashes

Re: HELP with conditional statements based on duplicated and nonduplic...

Re: When Stored Procedures last accessed

Re: proc sql pass through separate time in datetime stamp

Re: Long to wide format

Re: Long to wide format

Re: Long to wide format

Re: encoding and label

Re: PUT function

Re: adding observation to an existing data

Re: comma and countc

Re: array or loop help