Have a closer look at the parameters of scan: i think a comma is missing right after calling vname. ... View more

If SAS is running on a server, that server won't be able to access your local computer. ... View more

Please post data in usable form (data step with datalines), many users won't open office files due to security threads caused by the file-format. ... View more

@David_Billa wrote: @Patrick  Got this error when I ran your code in SASViya. So I don't have access to local machine from SAS server?   ERROR: Insufficient authorization to access PIPE. On Viya xmcd is disabled by default, so you can't execute os commands. ... View more

Please post data in usable form and the expected result. ... View more

@mkraman85 wrote: ...   Does it require a separate license for workspace server to run on the default port 8591?, will it not be available in the base SAS 9.4? As far as i know, a bi-server licence is required. ... View more

I am not a stats guy, but maybe this paper helps: https://support.sas.com/resources/papers/proceedings17/1404-2017.pdf ... View more

Please post (an excerpt) of the data you have as data step using datalines and show the expected result. This will give us something to work with and we can verify the results our code creates. ... View more

What have you tried? The problem can be solved by using DOW-loops, other ways exist, of course, using multiple steps. data want_dow; if 0 then set have; /* maintain variable order */ freq = 0; oi = 0; ft = 0; do _n_ = 1 by 1 until(last.clusterid); set have; by clusterid; freq = freq + 1; ft = ft + ifn(item_type = 'FT', score, 0); oi = oi + ifn(item_type = 'OI', score, 0); end; if oi > 0 then sum = oi; else sum = ft; do _n_ = 1 by 1 until(last.clusterid); set have; by clusterid; output; end; drop ft oi; run; ... View more

Can you post a working data step containing example data? That would make it easier to suggest working code. Showing the expected results would be useful, too.   ... View more

@vsandoval6 wrote: I'm having issues on the problem: Tabulate the percent of observations in the SASHELP.HEART dataset that have non-missing values for all the predictor variables that you will use in later analyses: AgeAtStart, BP_Status, Chol_Status, Cholesterol, Diastolic, Height, MRW, Sex, Smoking, Smoking_Status, Systolic, Weight, and Weight_Status.   Please help! This is a new question, too. Please create a new topic and show what you have already tried. ... View more

@AMweneykhondo wrote: Greetings i am so lost. The professor told us to copy and paste the code. but it keeps giving me errors. I am so frustrated. It is the exact question Please start a new topic and post the log, so that we see the errors actually. ... View more

The dataset you want to create looks like a report, having data in variable names is almost always a bad idea making the next steps more difficult. So, why do you need that structure?   Afaik your problem can't be solved by using proc transpose once, but by calling it twice and merging the results:   proc sort data= have out= sorted; by Id year; run; proc transpose data= sorted out= transposed1(drop= _name_) prefix= number1_; by Id; var number1; id year; run; proc transpose data= sorted out= transposed2(drop= _name_) prefix= number2_; by Id; var number2; id year; run; data want; merge transposed1 transposed2; by id; run; This should work, code is untested, because data wasn't provided in usable form. ... View more

This does not answer your question, but if you have to copy multiple datasets from one library to another, using proc copy is much faster than a data step.   Idea to solve the problem: - extract the relevant format from sashelp.vformat (libname = 'WORK', memname = 'FORMATS') - process sashelp.vcolumn (libname = 'OBK'), load the extracted information into a hash object, build the name the format should have an verify that it exists in the hash, use call execute with proc datasets to attach the format.   ... View more