topic Re: Need help with problem 2 in SAS Programming

Need help with problem 2

Curious4 — Thu, 19 Nov 2020 01:11:34 GMT

Anyone has advice on how I can go about doing problem 2 of this sneario? I have already done part 1

Re: Need help with problem 2

PaigeMiller — Wed, 18 Nov 2020 15:54:44 GMT

Hello, @Curious4 . I'm sorry to be so picky, but the text in your screen captures is barely readable. Can you provide the text in the screen captures in somewhat larger size? (I do not download attachments, they are a security threat, so I cannot look in your zip file)

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 16:06:32 GMT

I can send a more zoomed in picture but the zip is the only way to show it as the purpose of the assignment is to work with zipped files without extracting.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 16:10:32 GMT

I have updated the post with better images.

Re: Need help with problem 2

PaigeMiller — Wed, 18 Nov 2020 16:15:39 GMT

Well, thank you, I can now read problem 2, but since I refuse to download .zip files (or any files, really), you'll have to wait for someone else to help.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 16:16:13 GMT

Okay. Thanks anyway!

Re: Need help with problem 2

Reeza — Wed, 18 Nov 2020 16:41:15 GMT

Zip files have nothing to do the second question so you could provide the original data as a data step or as the text file.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 17:04:49 GMT

I printed it to the original post. thats all i know how to do

Re: Need help with problem 2

Reeza — Wed, 18 Nov 2020 17:10:33 GMT

Have you not imported the file into a SAS data set?

Re: Need help with problem 2

Reeza — Wed, 18 Nov 2020 17:18:54 GMT

data ia.prob02;
set ia.prob01;

prize =  (2012-since) * 10000 /*years*/ + floor(miles/100)*100  /*miles*/;

keep first_name last_name miles state_code prize;

run;

@Curious4 wrote:

Anyone has advice on how I can go about doing problem 2 of this sneario? I have already done part 1
libname ia "/folders/myfolders/DATASETS";

data prob1; set ia.prob1;
Filename zipfiles zip '/folders/myfolders/DATASETS/sweepstakes.zip'; 
Infile zipfiles(sweepstakes.dat); 

Filename sweepstakes zip '/folders/myfolders/DATASETS/sweepstakes.zip' member ='sweepstakes.dat';
infile sweepstakes;

proc print data=prob1;
sweepstakes.dat:

Jessica Cho
Gold 2006 46,153
American Express
VA

Bashid Al Herrum
Platinum 2011 21,848
Visa
CT

Johnathan Dudashman
Silver 2010 109,677
Visa
NY

Paul Duncan
Gold 2004 5,988
Mastercard
DC

Sarah Smith
Gold 2010 17,325
Visa
FL

Amanda Cole
Platinum 2008 68,077
Visa
MD

Gregory De Silva
Platinum 2007 92,785
American Express
DE

Re: Need help with problem 2

Reeza — Wed, 18 Nov 2020 17:21:01 GMT

FYI - If Problem 1 was not solved correctly you cannot answer problem 2. Your code as shown would not be a correct answer to problem 1.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 17:28:29 GMT

The assignment does not ask me to do that. it just says to read it from the zip.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 17:59:29 GMT

Yes, I am still working on problem 1 but I don't know why I am still getting errors. This is my revised code, I think I am on a better track but haven't gotten rid of all errors.

Filename zipfiles zip '/folders/myfolders/DATASETS/sweepstakes.zip';
/*Filename sweepstakes zip '/folders/myfolders/DATASETS/sweepstakes.zip' member ='sweepstakes.dat';*/
data prob1a;

Infile zipfiles(sweepstakes.dat);

/*infile sweepstakes;*/

proc print data=prob1a;

Re: Need help with problem 2

Reeza — Wed, 18 Nov 2020 18:02:35 GMT

I read it as asking you to create the permanent sas data set as shown but I guess I don't understand your problem then. Good Luck.

@Curious4 wrote:
The assignment does not ask me to do that. it just says to read it from the zip.

Re: Need help with problem 2

Curious4 — Wed, 18 Nov 2020 19:10:02 GMT

Okay, I am not sure. the instructor said to not use set ia.prob1 so i took it as not