Home

alepage

Hello, I am running many SAS code in cascade and I have this error: ERROR: You cannot open WORK.FICHIER_IBC_CORR.DATA for output access with member-level control because WORK.FICHIER_IBC_CORR.DATA is in use by you in resource environment IOM ROOT COMP ENV. How to solve this issue. Is it related to my SAS EG config.

Scooby3g

Hi all, I am trying to use SAS to append a dataset into a SQL table. I am using this code (modified the table names). My dates are in YYDDMM10. format, numeric = type, length = 8, informat =10. and they cannot be appended because of type of mismatch. The variables in the SQL table is set to the data type = "date" and it has allow nulls checked off. any help is appreciated!! >.< libname Dummy odbc dsn='Dummy_data' schema=stg; data org.procedures; set procedures; RunDate = today(); format RunDate date9.; if firstobs then Obs_ID = 1; else Obs_ID +1; run; *remove exisiting data from table; data Dummy.data_Numerators; modify Dummy.data_Numerators; if Obs_ID not = '.0y' then remove Dummy.data_Numerators; run; *append new data to table; proc append data= org.procedures base = Dummy.data_Numerators force; run;

Ankur23

Hi Need help with data transformation and feature engineering for a project based on credit scorecard. How can I do it on SAS Miner.

sassy_seb

Hello, I am getting the following error messages when trying to merge two datasets. One of the datasets I am getting from a csv file, so maybe the issue could be there? I was trying to specify the length of the PID variable for the redcap_sort dataset from the redcap one, which is the one we got from the csv file. However, I keep getting messages that the variable has multiple lengths and it keeps truncating the data. Any PID after 999 gets shortened. So 1000 and 1001 become 100, 1010 becomes 101, etc. Any help or a nudge in the right direction would be greatly appreciated, thank you so much. Edit: The programming with the csv file already has: data work.redcap; %let _EFIERR_ = 0; infile &csv_file delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=1 ; informat pid $500. ; informat pid_ini $500. ; and the code for format: format pid $500. ; It has this for all the variables. I thought the above code would make it so that the variables would have that limit of 500 characters?

BruceBrad

I'm trying to strip some operators from a string, leaving behind variable names. I'm using the following code which doesn't work. Is there some quoting needed? %let expression = vara / (varb + varc); %macro stripsym(string); %sysfunc(translate(&string,,+-*/())); %mend stripsym; %put Output: %stripsym(&expression); %put Desired: vara varb varc;