About Pooja2

Pooja2 · ‎04-16-2020

Hi, I am working on a project where I need to import graphs from a website (one webpage has one graph) and then export that to an excel sheet with some specifications. I have never done that kind of stuff. I need someone to help me with this. Thanks in advance.

Pooja2 · ‎11-08-2019

Thanks. My seed value was too long for mathematical evaluation. I reduced it to 6 digits and that resolved the issue. Thank you so much. I appreciate all the prompt responses.

Pooja2 · ‎11-08-2019

Cynthia. Sorry for that. That's a typo. I am not copying and pasting from my another computer. Sorry about that. There is no 's' in the let statement.

Pooja2 · ‎11-08-2019

Seed value I am getting from lets statement and &I value I am getting from a data step; it is a macro % lets samplesize = 40; %lets seed = 12345; %lets number = 1; %macro want; do I = 1 %to &number; data want; set have nobs=tot; retain; select = min(&samplesize, tot); do I = Tot to 1 by -1; set have; if ranuni(&seed + (&I - 1)) < select /I then do; select + - 1; output; end; end; run; %mend want; %want;

Pooja2 · ‎11-08-2019

% lets samplesize = 40; %lets seed = 12345; data want; set have nobs=tot; retain; select = min(&samplesize, tot); do I = Tot to 1 by -1; set have; if ranuni(&seed + (&I - 1)) < select /I then do; select + - 1; output; end; end; run; I am running this code to randomly select 40 customers from data have and getting following in my log: Note: Limit set by errors=option reached. further errors of this type will not be printed. mathematical operations could not be performed at the following places. the results of the operators have been set to missing values. this is not selecting 40 claims rather giving me everything whatever I have in 'have' data set. Thanks,

Pooja2 · ‎09-27-2019

no. I have not. But thanks for the link.

Pooja2 · ‎09-27-2019

I have a list of 2000 observations. I have to look for other details from a datawarehouse for these 2000 observations. I have tried two methods: proc sql; create table want as select a.* /*selecting a total of 20 variables*/ from datawarehouse a where a.var1 in (select distinct obs2000 from have); quit; this section is taking forever. I also tried following: proc sql noprint; select distinct obs2000 from have into :obs; quit; proc sql; create table want as select a.* /*selecting a total of 20 variables*/ from datawarehouse a where a.var1 in (&obs.); quit; this section is giving me an error "length is more than 256 characters long" My question is what are other ways to solve a query like these. Thanks,

Pooja2 · ‎08-05-2019

I have unique cust in each row. It is a clean data.

Pooja2 · ‎08-05-2019

Thanks Ballardw. I am still learning and I am aware I need to improve. I explained my problem in detail in the post. I hope you can give me your suggestion based on my problem.

Pooja2 · ‎08-05-2019

Thanks Tom for your response. it is giving me "2412","erer","ghgh" for nonmissing values but if I have any missing value it is giving me "2431"," "," " if I have missing values. If I have missing values then I just want "2431". so that my data pull does not give me any blank cells when I use this in my where clause. Thanks, I have a dataset where I have different customers cust 1, cust 2, ...custn in each rows and then their corresponding ids as id1, id2, id3. Sometimes more than 1 id is missing but at least one id will be populated. I have 150 rows. I have to create a summary for each customer (if there id in id1,id2, and id3) for example - how many shirts they have bought. so if I have a variable for id then I can use that in a where clause as PROC SQL ; SELECT COUNT(*) INTO :NUMROWS FROM want; QUIT; 　 PROC DELETE DATA=TOGETHER; %MACRO SHIRT; %DO I=1 %TO &NUMROWS; DATA CHECK;SET WANT; IF _N_=&I;RUN; PROC SQL; SELECT CUST AS CUST, ID AS ID INTO :CUST, :ID FROM CHECK; QUIT; PROC SQL; CREATE TABLE CLMS AS SELECT * FROM OTHERDATA WHERE A.ID IN ("&ID.") AND A.CUSTOMER IN ("&CUST.") QUIT; %END; Thanks,

Pooja2 · ‎08-05-2019

data have; infile datalines missover; input IDnumber1 $ IDnumber2 $ IDnumber3 $; datalines; 2477 sdsd dfdf 2431 2456 dfdf ghgh 2412 erer ghgh ; run; I want to create a variable for each obs like this newvar for row 1: '2477','sdsd', 'dfdf' newvar for row 2: '2431' newvar for row 3: '2456','dfdf','ghgh' newvar for row 4: '2412','erer','ghgh' I want to create this to use them as a macro in a where clause. Thanks, Pooja

Pooja2 · ‎07-03-2019

@PeterClemmensen Thanks for helping. one more question. lets say the data set will have '2' or '3' as values for their visit variable. there was a point when it reach to sum 9 and since there is no '1' to pick to make it 10 - it has to be either 2 or 3 - it goes into endless looping. can you suggest how to fix that.

Pooja2 · ‎07-02-2019

one more question - I want to put a seed number so that every time I get the same response. may be in future I want to replicate my results. How can I do that.

Pooja2 · ‎07-01-2019

@PeterClemmensen thank you so much for your help!! Thanks!

Pooja2 · ‎07-01-2019

yes, it can be a data step. It doesn't have to be PROC SURVEY SELECT. Thanks!

Online Status	Offline
Date Last Visited	‎04-23-2020 03:39 PM

sas import an image from a website and export that to an excel sheet

Re: sas 9.4 data step

Re: sas 9.4 data step

Re: sas 9.4 data step

sas 9.4 data step

Re: proc sql

proc sql

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

Re: sas 9.4 data step

Re: sas 9.4 data step

sas import an image from a website and export that to an excel sheet

Re: sas 9.4 data step

Re: sas 9.4 data step

Re: sas 9.4 data step

sas 9.4 data step

Re: proc sql

proc sql

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

Re: SAS: create a string to use as a macro

SAS: create a string to use as a macro

Re: proc survey select with conditions

Re: proc survey select with conditions

Re: proc survey select with conditions

Re: proc survey select with conditions