About SASJedi

SASJedi · ‎03-03-2021

What version of SAS are you each running? If the problem is with the SAS University Edition, have a look at a possible solution here: https://communities.sas.com/t5/SAS-Analytics-U/execution-of-large-data/td-p/217943

SASJedi · ‎03-01-2021

Because your file name includes special characters, you must enclose the member name in quotes. This should work: data _null_ ; infile inzip("one/two/test(2) .xpt") lrecl = 256 recfm = F length = length eof = eof unbuf ; file unzip lrecl = 256 recfm = N ; input ; put _infile_ $varying256. length ; return ; eof: stop ; run;

SASJedi · ‎02-24-2021

If things get more complicated, you could do a controlled transposition with a DATA step, like this: data have; infile datalines truncover; input Name:$1. Email_type:$8. Email:$20.; datalines; A Business xyz@blank A Personal abc@blank B Business 123@blank B Personal 456@blank ; data want; set have; by name; length Personal_Email Business_Email $20; retain Personal_Email Business_Email ; if first.name then do; call missing(Personal_Email, Business_Email); end; if email_type="Business" then Business_Email=Email; else if email_type="Personal" then Personal_Email=Email; if last.name then output; drop Email:; run;

SASJedi · ‎02-17-2021

Looks like your FILENAME SFTP statement syntax doesn't match the docs, and your DATA step is trying to read a local file that doesn't exist. First, test to ensure the local file exists: data _null_; /* Verify the file you are reading from is available on the SAS server */ infile "~/test.txt" truncover; /* Read a record from source */ input; /* Write the record to the log */ put _infile_; run; Review the log to ensure you are reading the file correctly. Fiddle with this code until you get it to work. Next, modify the code to write to the SFTP location instead of the log: Try something like this: filename outfile sftp "/user/myfolder/text.txt" host='XXX.XX.XX.XX' user='myUser' optionsx='-pw "myPass"' ; data _null_; /* Read from file on the SAS server */ infile "~/test.txt" truncover; input; /* Write the record to SFTP destination file */ file myFolder; put _infile_; run; This should help you isolate the problem and get things working more quickly. Let me know how it goes! May the SAS be with you!

SASJedi · ‎02-15-2021

This would probably be easier if you do it when you read in the original data, something like this. /* Make test data *. data have; infile datalines truncover dlm=','; input FULLNAME:$40.; datalines; BROWN JR JOHN K SPRAT III JACK CLIVE LAMB MARY H ;;;; data want; set have; array name[*] $ 20 Last First Middle Suffix; drop i element; element=0; do i=1 to dim(name); name[i-element]=scan(fullname,i,' '); if upcase(compress(name[i-element],,'ka')) in ('II','III','IV','JR','SR') then do; Suffix=name[i-element]; element+1; end; end; run;

SASJedi · ‎02-15-2021

The order in which you use TRANWRD to remove values is removing the first two characters from "III" leaving just a single "I" behind before the attempt to find "III", so a match will never be found for "III". Changing the order should resolve that issue: do word= 'JR', 'SR', 'III', 'II', 'IV' ; new_FirstName = tranwrd(' '||new_FirstName, ' '||strip(word)||' ', ' ');

SASJedi · ‎02-15-2021

OK - so you are using SAS On Demand for Academics, and you have successfully signed in. Did you follow all of the remaining steps in the instructions in the precise order listed? Setup Instructions for SAS OnDemand for Academics: SAS Studio To complete the practices in this course, you must complete the steps below to set up the data sets and practice files for SAS Studio. These instructions assume that you have an active SAS OnDemand for Academics account. Open this zip file and extract it to any location on your computer. The unzip process creates a folder named EMC1V2 that includes one SAS program: createdataMC1_oda.sas. Start SAS Studio from your SAS OnDemand for Academics Dashboard. In the Server Files and Folders panel, select Files (Home). At the top of the Server Files and Folders panel, click New and select Folder. In the Name box, type EMC1V2 in uppercase exactly as shown. Click Save. If necessary, expand Files(Home) and verify that the EMC1V2 folder was created. Select the EMC1V2 folder and click Upload In the Upload Files window, click Choose Files. Browse to the EMC1V2 folder on your computer, select createdataMC1_oda.sas, and click Open. Click Upload. The program is added to the EMC1V2 folder on the server. In SAS Studio, double-click createdataMC1_oda.sas to open the program. Click Run or press F3 to run the program. This program creates all the SAS files and data you need for this course, so it might take a few moments to run. After the program runs, a list of SAS tables is displayed in the Results tab. In the Server Files and Folders panel, you can see the EMC1V2 folder. Double-click libname.sas and run the program. You can now access the data for the course. Each time you sign into SAS OnDemand for Academics: SAS Studio, you must run the libname.sas program to access the data. In the EMC1V2 folder, you should have six subfolders: activities, autocall, case_study, data, demos, and practices.

SASJedi · ‎02-15-2021

Have you: 1. Determined how you will access SAS for studying (SAS On Demand for Academics or SAS University Edition) Free software option How the software works How you access the software SAS OnDemand for Academics You register for an account to get access to SAS in the cloud. All you need is a web browser with an internet connection. Go here and click the Getting Started tab. Follow the instructions in the Independent Learners section to register and log in. SAS University Edition You download and install virtualization software, and then download the SAS University Edition vApp. There are instructions that walk you through these steps! After you are set up, you don't need an internet connection to run the software. Go here and then click Get free software. 2. Completed the detailed instructions provided for your SAS version in the section titled "Setting Up the Course Data Files (REQUIRED)"? If you are having trouble with the instructions provided, please indicate what particular step is causing the problem and/or what error you are getting in the SAS Log. May the SAS be with you! Mark

SASJedi · ‎02-15-2021

Congratulations on passing the certification exam! SAS Communities is best suited for getting technical help with SAS questions, it's not really a jobs site. I'd recommend polishing your LinkedIn profile and including your new certification badge. And I just Googled "best sites for SAS jobs in the UK" - several interesting job listings popped up...

SASJedi · ‎02-15-2021

What macro course are you taking?

SASJedi · ‎02-15-2021

Your first DATA step is not executing because you misspelled "sashelp" as "sahelp". First, correct that. Next, your SQL query asks for rows where the count is >2. Because you only have 2 data sets created, no rows meet the criteria, so no output. With the code corrected: data ds; set sashelp.class; run; data ds1; set sashelp.class; run; proc sql; select Name,count(Name) from dictionary.columns where libname='WORK' group by name having count(Name)>=2; quit; You get results: Column Name Age 2 Height 2 Name 2 Sex 2 Weight 2

SASJedi · ‎02-11-2021

I'd use an array: data have; infile datalines truncover; input; length Var_umbrella $60; Var_umbrella=strip(_infile_); datalines; |Var_1 a | Var_2 b | Var_3 c | Var_4 d | Var_5 e | |Var_1 f | Var_4 g | |Var_2 h | Var_3 i | Var_5 j | |Var_5 k| ; data want; set have; /* Creates variables Var_1-Var_5 as single character */ array V[5] $1 Var_1-Var_5 ; /* Scan first name-value pair*/ _i=1; _t=scan(var_umbrella,_i,'|'); /* Extract name and value as long as there are more avialable */ do while (not missing(_t)); /* Extract the name from this name-value pair*/ _name=scan(_t,1,' '); do _j=1 to dim(v); /* Find the array element that matches the name and assign the value */ if vname(v[_j]) = _name then v[_j]=scan(_t,-1,' '); end; /* Scan next name-value pair*/ _i+1; _t=scan(var_umbrella,_i,'|'); end; drop _: ; run; This is the result. You can drop the var_umbrella - I just left it for you to see the code worked: Obs Var_umbrella Var_1 Var_2 Var_3 Var_4 Var_5 1 |Var_1 a | Var_2 b | Var_3 c | Var_4 d | Var_5 e | a b c d e 2 |Var_1 f | Var_4 g | f g 3 |Var_2 h | Var_3 i | Var_5 j | h i j 4 |Var_5 k| k In the future, you can use this same technique when reading in the original text file, and produce the result you want directly on the first pass: /* make temporary file with the original text in it for testing */ filename myText temp; data _null_; file myText; set have; put var_umbrella; run; /* Print the text file to the log so you can see it */ data _null_; infile myText; input ; put _infile_; run; /*Just read it straight into the correct variables from the input buffer! */ data want1; infile myText truncover; input; array V[5] $1 Var_1-Var_5 ; /* Scan first name-value pair*/ _i=1; _t=scan(_infile_,_i,'|'); /* Extract name and value as long as there are more avialable */ do while (not missing(_t)); /* Extract the name from this name-value pair*/ _name=scan(_t,1,' '); do _j=1 to dim(v); /* Find the array element that matches the name and assign the value */ if vname(v[_j]) = _name then v[_j]=scan(_t,-1,' '); end; /* Scan next name-value pair*/ _i+1; _t=scan(_infile_,_i,'|'); end; drop _: ; run; This is the result: Obs Var_1 Var_2 Var_3 Var_4 Var_5 1 a b c d e 2 f g 3 h i j 4 k

SASJedi · ‎02-11-2021

If you just want a random sample. PROC SURVEYSELECT is probably the best choice. proc surveyselect data = sashelp.cars sampsize = 5 out = work.cars_sample; ; run; If you want the sample to be repeatable, i.e. to get the same "random" sample the next time you run the program, you must specify a seed: proc surveyselect data = sashelp.cars seed=12345 sampsize = 5 out = work.cars_sample; ; run;

SASJedi · ‎02-10-2021

I'd do it with an array and a little boolean expression: data have; input id $ tot1 tot2 tot3 tot4 tot5 tot6 mark11 mark12 mark21 mark22 mark31 mark32; datalines4; a 10 10 10 10 10 10 1.0 1.0 1.0 1.0 1.0 1.0 b 10 0 10 0 10 0 1.0 0.0 1.0 0.0 1.0 0.0 c 0 10 0 10 0 10 0.0 1.0 0.0 1.0 0.0 1.0 x 4 2 0 5 6 0 0.4 0.2 0.0 0.5 0.6 0.0 y 7 3 2 2 7 8 0.7 0.3 0.2 0.2 0.7 0.8 z 10 8 4 0 1 3 1.0 0.8 0.4 0.0 0.1 0.3 ;;;; data want; set have; /* Just look at the variables where the name starts with 'mark'*/ array m[*] mark:; /* zero out the count variable */ no_test=0; do _i=1 to dim(m); /* if the variable name ends in '2' and the value is >.5, this expression is true, otherwise false (1 otherwise 0 in SAS) */ /* Add the result to the count variable */ no_test+(char(reverse(vname(m[_i]) ),1)='2' and m[_i]>.5); end; drop _:; run; This produces this result: Obs id tot1 tot2 tot3 tot4 tot5 tot6 mark11 mark12 mark21 mark22 mark31 mark32 no_test 1 a 10 10 10 10 10 10 1.0 1.0 1.0 1.0 1.0 1.0 3 2 b 10 0 10 0 10 0 1.0 0.0 1.0 0.0 1.0 0.0 0 3 c 0 10 0 10 0 10 0.0 1.0 0.0 1.0 0.0 1.0 3 4 x 4 2 0 5 6 0 0.4 0.2 0.0 0.5 0.6 0.0 0 5 y 7 3 2 2 7 8 0.7 0.3 0.2 0.2 0.7 0.8 1 6 z 10 8 4 0 1 3 1.0 0.8 0.4 0.0 0.1 0.3 1 May the SAS be with you! Mark

SASJedi · ‎02-10-2021

proc sort data=have out=havesorted; by ID; run; data want; set havesorted(obs=5); run;

Online Status	Offline
Date Last Visited	Friday