SAS Support Communities

shivagujjaru · ‎02-24-2024

proc sort data=have; by usubjid AVISITN vistyp; run; data want; set have; by usubjid AVISITN; if first.usubjid then flag = "" if first.AVISITN then flag = ""; if vistyp = 1 and first.AVISITN then flag = "Yes"; else if vistyp ne 1 and first.AVISITN then flag = "Yes"; else if vistyp = 1 and flag = "" then flag = "Yes"; if last.AVISITN then output; drop visdup; run; proc print data=want; run; Hope this should work This code first sorts the have dataset by usubjid, AVISITN, and vistyp. Then, it processes the data by groups of usubjid and AVISITN. Within each group, it sets the flag variable based on the specified conditions. Finally, it keeps only the first record per visit (AVISITN) and drops the unnecessary Try and let me know if it doesn't work

shivagujjaru · ‎02-24-2024

Hi Everyone, Is it possible in sas to do web scraping accurately, Go to a website and enter the zip code as shown in picture 1 and extract the city and other city information from picture 2 and store into a dataset. And again go to "edit and search again" in picture 2 and search for new zip code ? Can I do it for more than 1000+ zips ?

shivagujjaru · ‎10-15-2019

hello guys can someone tell me How to create Password protected xlsx file using Unix sas or Using x or systask command

shivagujjaru · ‎07-10-2019

Hi I run SAS codes using IBM TWS which are getting aborted due to RC 127. When I debug . While job get submit it creates host.servername.com , job.id ,job.lock, code.sas Files under sasutil location. In general they get create at /sasutil/login ID/jobnamefolder Here few jobs getting aborted right after creating this folder but not creating the files mentioned above As per me these files will be created by SAS LSF . Only few job are getting aborted due this issue , where all our job use the same location and scripts . I have checked the permission, assigned the full directory but not able to find the issue

shivagujjaru · ‎05-14-2019

What about bulkload ?

shivagujjaru · ‎05-14-2019

What is the max insertbuff I can submit In general I use insertbuff=10000

shivagujjaru · ‎05-14-2019

Hi guys, I want to work on parallel processing like I have a insert step in two tables I pick data from 1 tables , So I want to use parallel process to load data in two tables at once

shivagujjaru · ‎05-08-2019

What value does temp represent here

shivagujjaru · ‎05-08-2019

Id. Dateofjoining 101 21Aug2018 102 22Aug2018 103 17Aug2018 104 25Aug2018 As per series 103 should be 23 or 24 Aug . How to pick the odd one out or remove 103 row.

shivagujjaru · ‎04-21-2019

I have applied some loop inside the macro . It's like when file is not exits it's still using the local macro variable while checking a condition. Thanks , now it's working

shivagujjaru · ‎04-21-2019

Adding a point Symdel delete global macro variable . But I have created local macro variable. Thanks alot guys

shivagujjaru · ‎04-21-2019

Hi guys, I need to delete a temporary variable. Created by using select distinct variable name into: variable1. How can I delete this variable1 from work lib .

Online Status	Offline
Date Last Visited	‎02-29-2024 02:54 AM

SAS Support Communities

Re: Picking unique visit among multiple based on specific condition

Web scraping using sas

Password protected xlsx file in SAS

I run SAS codes using IBM TWS which are getting aborted with RC 127

Re: Insertbuff

Insertbuff

Parallel processing

Re: Give a best solution

Give a best solution

Re: Delete temporary variable

Re: Picking unique visit among multiple based on specific condition

Web scraping using sas

Password protected xlsx file in SAS

I run SAS codes using IBM TWS which are getting aborted with RC 127

Re: Insertbuff

Insertbuff

Parallel processing

Re: Give a best solution

Give a best solution

Re: Delete temporary variable

Re: Delete temporary variable

Delete temporary variable

Follow Us

What is...