Home

jaypennington

I have a dataset Id system1 system2 system3 system4 1 0001 0001 0001 0002 2 0002 0001 0002 0003 3 0003 0002 0002 0004 4 missing 0001 missing missing I want to the new data set to include a new column which is the most frequent value across these systems. Id system1 system2 system3 system4 mostfrequent countofmostfrequent 1 0001 0001 0001 0002 0001 3 2 0002 0001 0002 0003 0002 2 3 0003 0002 0002 0004 0002 2 4 missing 0001 missing missing 0001 1 Any help you can provide would be greatly appreciated!

SASuserlot

I have sas 9.4 TS level 1M7 version. I am having a problem using sas. When I increase my display setting on the computer is more than 100%. Sas becomes slow, has a hard time opening the dataset, moving between the tabs, lag, and stickiness of the scroll bar for the editor window. With the 100% setting, the font is very small in all Icons like filenames, folder names in the system, and even the font in the dataset; my eyes really get bad with this kind of setting. What to do?

vamsinuthalapat

Few business units using customized workspace folders instead of default work spaces (like /saswork, /tmp). Is there any way to check customized workspace configuration in SAS 9.4 M7?

BeerSultan

Brand new to SAS. I'm doing something that I expect is relatively easy, but I'm struggling to get it right. The requirement is basic - I'm reading in a long file with many rows, if a record matches a criteria I want it to be shipped to a different "bypass" file that I'll work on in a later process, but it should be removed from the original read-in file. Environment is zOS - input file is defined and passed in via JCL (all working). I get the following errors if I remove my actual logic - if I leave the FILENAME statement in without referencing it there's no errors. ERROR: Invalid logical name. ERROR: Error in the FILENAME statement. ERROR: Invalid file, BYPASS_FILE. FILENAME BYPASS_FILE BYPASS1; /***********************************************************/ /* READ FILE */ /***********************************************************/ DATA DATAIN; INFILE DATAIN; INPUT @ 00001 RECORD_NUMBER $CHAR8. @ 01769 COMPONENT_STATUS $CHAR1. ; /*******************************************************************/ /* CREATE BYPASS FILE - USED TO STORE RECORDS WHICH HAVE AN */ /* INACTIVE COMPONENT: COMPONENT_STATUS = I */ /*******************************************************************/ IF COMPONENT_STATUS = 'I' THEN DO; FILE BYPASS_FILE; PUT; DELETE; END;

smackerz1988

Hi, I'm currently waiting to get access for sas viya but I have a test case scenario to compare between sas eg and sas viya and just want to verify the sas viya code. For bootstrapping in sas eg I have this code proc surveyselect data=data out=BootSamples noprint seed=25 reps=2000 method=urs samprate=1 outhits; run; Am I right that this would be the equivalent code in sas viya or am i missing something? /* Start CAS session and load data into CAS */ cas mysess sessopts=(caslib='casuser'); libname mylib cas sessref=mysess; /* Load example data */ proc casutil; load data=data casout="sample" replace; run; /* Perform bootstrap resampling using the sampling action set */ proc cas; action sampling.srs result=r / table={caslib='casuser', name='sample'} output={casout={caslib='casuser', name='BootSamples', replace=true}} samppct=100 /* Sampling rate of 100% for bootstrap */ method='URS' /* Unrestricted random sampling with replacement */ seed=25 /* Seed for reproducibility */ reps=2000; /* Number of bootstrap replicates */ selection={name='Freq', includeFreq=true}; /* Include frequency counts in the output */ quit; /* Fetch and display some of the bootstrap samples (Optional) */ proc cas; table.fetch / table={caslib='casuser', name='BootSamples'} to=10; quit; /* End CAS session */ cas mysess terminate;