python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sas

Reading and extracting files from a directory using SAS

I have a directory /run/return/files/archives/prep/share/ that contains both .txt and .csv files. For example IA_PROD.txt and retour_PROD.csv I want to read both types of files and extract only their ...
test-img

missy

sas

Votes: 0

Answers: 2

Latest Answer

Not sure if it answers your question, but I think this answers your problem :) What I propose it to filter your input files with ls : %let REP_BLOCTEL_ALLER = /run/return/files/archives/prep/share/; ...
test-img

Gaadek

Insert multiple columns into a single column using pandas

I am converting a SAS code to python and got stuck here. My input table is like:- St sgmt Val A CD 200 A PQ 300 My output should be like:- Col Val A 500 CD 200 PQ 300 500...
test-img

user18734161

python

pandas

dataframe

sas

proc-sql

Votes: 0

Answers: 1

Latest Answer

You can melt to combine the "St" and "sgmt" columns, then GroupBy.sum to aggregate per name: (df .melt('Val', value_name='Col') .groupby('Col', as_index=False) ['Val'].sum() ) ...
test-img

mozway

How to export editor code in SAS to word (rtf) file with tables

I have this code in SAS for an assignment. I am learning SAS and have completed all of the items already coded for and successfully have reviewed the output in the log and the results tab of SAS. I ha...
test-img

barnsm2

sas

Votes: 0

Answers: 0

Assign groups based on variables

In SAS, I have a dataset(have) as below, I need to add a group variable based on test and visitnum. When visitnum is 101 and 108, they need to be in the same group. The desired as shown as data want. ...
test-img

Jill

sas

Votes: 0

Answers: 1

Latest Answer

First sort your data by test and visitnum. There are two cases when we want to increment the group number: When it's the start of a test group and the visitnum is 101 or 108 When it's the start of a ...
test-img

Stu Sztukowski

Posts

Questions

Blogs

Jobs